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

Shaun Scovil

Ever want to list your WordPress posts in an easy-to-read, sortable data table? This plugin makes it easy to do just that. It supports post thumbnails, custom post types, custom taxonomies, and (as of v4.0) custom fields.
By default, the plugin outputs the following columns:
<ol>
<li>Post Thumbnail (if enabled)</li>
<li>Post Title</li>
<li>Post Date</li>
<li>Post Categories</li>
<li>Post Tags</li>
</ol>
Options include:
<ul>
<li>Omit any of the default columns</li>
<li>Replace <code>Post</code> with a custom post type</li>
<li>Replace <code>Categories</code> and <code>Tags</code> with custom taxonomies</li>
<li>As of version 4.0 you can insert any number of custom field columns</li>
</ul>
How To Use
<pre><code>[sorttablepost]
</code></pre>
Place this shortcode into a post or page to insert a sortable table of all posts.
Hide Standard Columns
<pre><code>[sorttablepost nothumb="true" notitle="true" nodate="true" nocats="true" notags="true"]
</code></pre>
You can omit any undesired columns by using one or more of these shortcode options.
Show Custom Post Type
<pre><code>[sorttablepost type="my-custom-post-type"]
</code></pre>
You can specify the name of a custom post type (or <code>page</code>), instead of showing posts.
Use Custom Taxonomies
<pre><code>[sorttablepost cat="my-custom-taxonomy" tag="another-custom-taxonomy"]
</code></pre>
You can replace the standard <code>Categories</code> or <code>Tags</code> columns (or both) with custom taxonomies.
Use Custom Fields
<pre><code>[sorttablepost meta="Custom Field Key,Another Custom Field Key,Yet Another"]
</code></pre>
As of v4.0, you can add as many custom field columns as you like. Use a comma-seperated list of field keys.
Assign Unique ID to Table
<pre><code>[sorttablepost id="mytable"]
</code></pre>
As of v4.2, you can give each table a unique ID. This is particularly useful when displaying multiple tables on the same page, as it allows you to style each one differently.
About This Plugin
For more information about this plugin, visit: http://mynewsitepreview.com/sorttablepost/
To see a live demo, visit: http://mynewsitepreview.com/sorttablepost-wordpress-plugin-live-demo
About SortTable.js
The sortable table portion of this plugin is made possible by Stuart Langridge’s awesome Javascript library.
Documentation for sorttable.js can be found at: http://www.kryogenix.org/code/browser/sorttable/

SortTable Post

This plugin allows you to display an index of posts (or a custom post type) in a sortable table on any page or post, using a simple shortcode.

DbTable to DataTable vs SortTable Post