WP Table Manager: Tables From Database

WP Table Manager allows you create tables from your database tables.

At WP Table Manager dashboard, click on Create New > Database Table  button on the top left panel.

 

new-database-table

 

Then you'll be able to select tables and columns from your database. By hitting control you can select several tables, columns.

 

database-selection

 

columns-selection

 

On column selection you can define a custom title and a default order for your data in the table, when displayed on public side.

 

column-titleandordering

 

Then you got some options and filter to apply to your tables:

  • A pagination default level (to be used with a large amount of data)
  • Number of rows for the pagination
  • Apply some filter to your data ie. a column can be equal, different... from a defined value
  • The possibility to group some values in the columns

 

database-table-options

 

Finally you can preview and generate your table like any other table.

The only difference is that themes cannot be applied on tables but you can customize all the display like in any other tables.

 

When your table is generated you will still have access to the database by going to Menu Table > Data Source to update the table.

 

database-table-generated