AI助手支持GPT4.0
This plugin allows you to display the content of MySql tables into sortable html tables thanks to the DataTable jQuery Plugin.
借助DataTable jQuery插件，此插件可让您将MySql表的内容显示为可排序的html表。
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.
[dbtable]
只需将简码 [dbtable] 添加到文章或页面中，您将获得一个漂亮干净的表。Examples:示例：All parameters that contain more than one value have to be separated by commas without spaces.所有包含多个值的参数都必须用逗号分隔，且不能使用空格。Minimum needed : [dbtable from=MysqlTableName]最少需要： [dbtable from = MysqlTableName] select=field1,field2,field3 will display all rows of the table and only specified fields select = field1，field2，field3 将显示表的所有行，并且仅显示指定的字段except=field1,field2,field3 will display all rows of the table except specified fields except = field1，field2，field3 将显示表中除指定字段外的所有行cssClass=class1,class2 will add class1 and class2 to the class attribut of the table cssClass = class1，class2 会将class1和class2添加到表的类属性中comments=true|(false) true will use comments specified in each field of the MySql table as datatable column names. comments = true |（false） true将使用在MySql表的每个字段中指定的注释作为数据表列名称。If true and if a comment is missing, the plugin fallback on field name only for the one missing, not for the entire table.如果为true，并且缺少注释，则插件仅在缺少字段名称时退回字段名称，而不是整个表。pagination=true|(false) will show/hide the bottom pagination links. pagination = true |（false）将显示/隐藏底部的分页链接。If false, make sure you have the limit parameter large enough to display all your datas如果为false，请确保您的limit参数足够大以显示所有数据limit=25 Display 25 rows by default. limit = 25 默认显示25行。
[dbtable] 添加到文章或页面中，您将获得一个漂亮干净的表。Examples:示例：All parameters that contain more than one value have to be separated by commas without spaces.所有包含多个值的参数都必须用逗号分隔，且不能使用空格。Minimum needed : [dbtable from=MysqlTableName]最少需要： [dbtable from = MysqlTableName] select=field1,field2,field3 will display all rows of the table and only specified fields select = field1，field2，field3 将显示表的所有行，并且仅显示指定的字段except=field1,field2,field3 will display all rows of the table except specified fields except = field1，field2，field3 将显示表中除指定字段外的所有行cssClass=class1,class2 will add class1 and class2 to the class attribut of the table cssClass = class1，class2 会将class1和class2添加到表的类属性中comments=true|(false) true will use comments specified in each field of the MySql table as datatable column names. comments = true |（false） true将使用在MySql表的每个字段中指定的注释作为数据表列名称。If true and if a comment is missing, the plugin fallback on field name only for the one missing, not for the entire table.如果为true，并且缺少注释，则插件仅在缺少字段名称时退回字段名称，而不是整个表。pagination=true|(false) will show/hide the bottom pagination links. pagination = true |（false）将显示/隐藏底部的分页链接。If false, make sure you have the limit parameter large enough to display all your datas如果为false，请确保您的limit参数足够大以显示所有数据limit=25 Display 25 rows by default. limit = 25 默认显示25行。
All parameters that contain more than one value have to be separated by commas without spaces.
所有包含多个值的参数都必须用逗号分隔，且不能使用空格。
Minimum needed : [dbtable from=MysqlTableName]
[dbtable from=MysqlTableName]
最少需要： [dbtable from = MysqlTableName] select=field1,field2,field3 will display all rows of the table and only specified fields select = field1，field2，field3 将显示表的所有行，并且仅显示指定的字段except=field1,field2,field3 will display all rows of the table except specified fields except = field1，field2，field3 将显示表中除指定字段外的所有行cssClass=class1,class2 will add class1 and class2 to the class attribut of the table cssClass = class1，class2 会将class1和class2添加到表的类属性中comments=true|(false) true will use comments specified in each field of the MySql table as datatable column names. comments = true |（false） true将使用在MySql表的每个字段中指定的注释作为数据表列名称。If true and if a comment is missing, the plugin fallback on field name only for the one missing, not for the entire table.如果为true，并且缺少注释，则插件仅在缺少字段名称时退回字段名称，而不是整个表。pagination=true|(false) will show/hide the bottom pagination links. pagination = true |（false）将显示/隐藏底部的分页链接。If false, make sure you have the limit parameter large enough to display all your datas如果为false，请确保您的limit参数足够大以显示所有数据limit=25 Display 25 rows by default. limit = 25 默认显示25行。
[dbtable from = MysqlTableName] select=field1,field2,field3 will display all rows of the table and only specified fields select = field1，field2，field3 将显示表的所有行，并且仅显示指定的字段except=field1,field2,field3 will display all rows of the table except specified fields except = field1，field2，field3 将显示表中除指定字段外的所有行cssClass=class1,class2 will add class1 and class2 to the class attribut of the table cssClass = class1，class2 会将class1和class2添加到表的类属性中comments=true|(false) true will use comments specified in each field of the MySql table as datatable column names. comments = true |（false） true将使用在MySql表的每个字段中指定的注释作为数据表列名称。If true and if a comment is missing, the plugin fallback on field name only for the one missing, not for the entire table.如果为true，并且缺少注释，则插件仅在缺少字段名称时退回字段名称，而不是整个表。pagination=true|(false) will show/hide the bottom pagination links. pagination = true |（false）将显示/隐藏底部的分页链接。If false, make sure you have the limit parameter large enough to display all your datas如果为false，请确保您的limit参数足够大以显示所有数据limit=25 Display 25 rows by default. limit = 25 默认显示25行。
select=field1,field2,field3
select = field1，field2，field3 将显示表的所有行，并且仅显示指定的字段except=field1,field2,field3 will display all rows of the table except specified fields except = field1，field2，field3 将显示表中除指定字段外的所有行cssClass=class1,class2 will add class1 and class2 to the class attribut of the table cssClass = class1，class2 会将class1和class2添加到表的类属性中comments=true|(false) true will use comments specified in each field of the MySql table as datatable column names. comments = true |（false） true将使用在MySql表的每个字段中指定的注释作为数据表列名称。If true and if a comment is missing, the plugin fallback on field name only for the one missing, not for the entire table.如果为true，并且缺少注释，则插件仅在缺少字段名称时退回字段名称，而不是整个表。pagination=true|(false) will show/hide the bottom pagination links. pagination = true |（false）将显示/隐藏底部的分页链接。If false, make sure you have the limit parameter large enough to display all your datas如果为false，请确保您的limit参数足够大以显示所有数据limit=25 Display 25 rows by default. limit = 25 默认显示25行。
except=field1,field2,field3
except = field1，field2，field3 将显示表中除指定字段外的所有行cssClass=class1,class2 will add class1 and class2 to the class attribut of the table cssClass = class1，class2 会将class1和class2添加到表的类属性中comments=true|(false) true will use comments specified in each field of the MySql table as datatable column names. comments = true |（false） true将使用在MySql表的每个字段中指定的注释作为数据表列名称。If true and if a comment is missing, the plugin fallback on field name only for the one missing, not for the entire table.如果为true，并且缺少注释，则插件仅在缺少字段名称时退回字段名称，而不是整个表。pagination=true|(false) will show/hide the bottom pagination links. pagination = true |（false）将显示/隐藏底部的分页链接。If false, make sure you have the limit parameter large enough to display all your datas如果为false，请确保您的limit参数足够大以显示所有数据limit=25 Display 25 rows by default. limit = 25 默认显示25行。
cssClass=class1,class2
cssClass = class1，class2 会将class1和class2添加到表的类属性中comments=true|(false) true will use comments specified in each field of the MySql table as datatable column names. comments = true |（false） true将使用在MySql表的每个字段中指定的注释作为数据表列名称。If true and if a comment is missing, the plugin fallback on field name only for the one missing, not for the entire table.如果为true，并且缺少注释，则插件仅在缺少字段名称时退回字段名称，而不是整个表。pagination=true|(false) will show/hide the bottom pagination links. pagination = true |（false）将显示/隐藏底部的分页链接。If false, make sure you have the limit parameter large enough to display all your datas如果为false，请确保您的limit参数足够大以显示所有数据limit=25 Display 25 rows by default. limit = 25 默认显示25行。
comments=true|(false)
comments = true |（false） true将使用在MySql表的每个字段中指定的注释作为数据表列名称。If true and if a comment is missing, the plugin fallback on field name only for the one missing, not for the entire table.
If true and if a comment is missing, the plugin fallback on field name only for the one missing, not for the entire table.
如果为true，并且缺少注释，则插件仅在缺少字段名称时退回字段名称，而不是整个表。
pagination=true|(false)
pagination = true |（false）将显示/隐藏底部的分页链接。If false, make sure you have the limit parameter large enough to display all your datas
If false, make sure you have the limit parameter large enough to display all your datas
如果为false，请确保您的limit参数足够大以显示所有数据
limit=25
limit = 25 默认显示25行。
原文出处:http://www.sanshu.cn/a/10305.html
群主管理都是支付大佬
