| 开发者 | rikemsen |
|---|---|
| 更新时间 | 2016年2月12日 16:35 |
| PHP版本: | 4.4 及以上 |
| WordPress版本: | 4.4 |
| 版权: | GPLv2 or later |
[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 fieldsexcept=field1,field2,field3 will display all rows of the table except specified fieldscssClass=class1,class2 will add class1 and class2 to the class attribut of the tablecomments=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 dataslimit=25 Display 25 rows by default.You can edit the main dbTable2dataTable.php file and change these values :
$this->defaults = array(
'from' => null, // Mysql source table
'select' => null, // Select specific columns
'except' => null, // Ignore specific columns
'cssclass' => null, // Specify custom CSS class for the
'comments' => false, // Use field comments instead of column name
'pagination' => false, // Enable / Disable pagination
'limit' => 25, // Limit of results per page
'width' => '100', // Set width in % of the table
'language' => 'English' // Default language : French
);
comments attribut does?By default, column names will be the field name (e.g: product_id, custom_field). But if you want to have custom/pretty names you should modify your table and add comments to the fields (e.g : ALTER TABLE product CHANGE product_id product_id INT( 11 ) COMMENT 'Product ID'
This plugin is not intended to display WordPress datas. I blocked this for security reasons. It aims to give you the ability to show custom datas from custom tables. I had to extract informations from an ERP and display them.
You can remove the security check line 58 by deleting or substr($atts['from'], 0,strlen($wpdb->prefix)) === $wpdb->prefix
You probably misstyped the language name. Make sure you write it exactly with the correct name.
Refer to : https://www.datatables.net/plug-ins/i18n/
E.g for french : //cdn.datatables.net/plug-ins/1.10.10/i18n/French.json , the parameter will be French with the first letter in uppercase.