rikemsen

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 <code>[dbtable]</code> into an article or a page and you will have a nice and clean table.
<h3>Examples:</h3>
All parameters that contain more than one value have to be separated by commas without spaces.
Minimum needed : <code>[dbtable from=MysqlTableName]</code>
<ul>
<li><code>select=field1,field2,field3</code> will display all rows of the table and only specified fields</li>
<li><code>except=field1,field2,field3</code> will display all rows of the table except specified fields</li>
<li><code>cssClass=class1,class2</code> will add class1 and class2 to the class attribut of the table</li>
<li><code>comments=true|(false)</code> 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.</li>
<li><code>pagination=true|(false)</code> will show/hide the bottom pagination links. If false, make sure you have the limit parameter large enough to display all your datas</li>
<li><code>limit=25</code> Display 25 rows by default.</li>
</ul>

DbTable to DataTable

shawfactor

Table Sorter turns standard HTML table (with THEAD and TBODY tags) in your post, page, or CPT content into a sortable table without page refresh. It has many useful features including :
<ol>
<li>Multi-column sorting.</li>
<li>Disable sorting from particular column(s).</li>
<li>Different sorting types.</li>
<li>Cross-browser support</li>
</ol>
To make a table just add class=”sortable” to the table element in the html view.
NOTE Unlike other plugins this plugin will not unneccessarily slow down your site. The javascript to add the sorting is only added to the page is the above class is added to a table in the content.
As the javascript is vanilla it is unlikely to connflict with other plugins
This plugin uses Jonas Earendel’s <a href="https://github.com/tofsjonas/sortable" rel="nofollow ugc">Sortable table library</a>. So advanced documenation can be found there and its many other features can be found there.
View a demo here: <a href="https://lhero.org/sortable-table-demo/" rel="nofollow ugc">https://lhero.org/sortable-table-demo/</a>.
Like this plugin? Please consider <a href="https://wordpress.org/support/view/plugin-reviews/lh-sortable-tables/" rel="ugc">leaving a 5-star review</a>.
Love this plugin or want to help the LocalHero Project? Please consider <a href="https://lhero.org/portfolio/lh-sortable-tables/" rel="nofollow ugc">making a donation</a>.

LH Sortable Tables

No more old static tables, make your HTML tables sortable.

DbTable to DataTable vs LH Sortable Tables