DbTable to DataTable
by Guillaume Raineri
Description
This plugin allows you to display the content of MySql tables into sortable html tables thanks to the DataTable jQuery Plugin.
You don’t need any configuration and once installed, it is ready to use.
Simply add the shortcode
[dbtable]
into an article or a page and you will have a nice and clean table.
Examples:
All parameters that contain more than one value have to be separated by commas without spaces.
Minimum needed :
[dbtable from=MysqlTableName]
select=field1,field2,field3
will display all rows of the table and only specified fields
except=field1,field2,field3
will display all rows of the table except specified fields
cssClass=class1,class2
will add class1 and class2 to the class attribut of the table
comments=true|(false)
true will use comments specified in each field of the MySql table as datatable column names. If true and if a comment is missing, the plugin fallback on field name only for the one missing, not for the entire table.
pagination=true|(false)
will show/hide the bottom pagination links. If false, make sure you have the limit parameter large enough to display all your datas
limit=25
Display 25 rows by default.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
To create a collection, simply click on the 
symbol on the desired plugin.
You can see this symbol when you move the mouse over the plugin.
Current Level
You have reached 0 views on your collections and are currently Plugin Magican. You magically help people find the right plugins and are a great asset to the community