Download wpDataTables - easy tables in WordPress

Documentation and examples site contains main documentation, tutorials, feature explanation, and live demos for most of the table types and features. Sandbox demo site shows you the front-end data editing feature, and there you can see the results of all action that you do in the WP admin panel

Documentation and examples site contains main documentation, tutorials, feature explanation, and live demos for most of the table types and features.

Sandbox demo site shows you the front-end data editing feature, and there you can see the results of all action that you do in the WP admin panel. All changes and uploads are flushed once per hour.

Sandbox WP Admin panel (login: demo, password: demo) is designed so you could try the plugin, test and see it from the inside before you buy. All changes and uploads are flushed once per hour.

Control panel login: demo/demo

Check out the PHP module on which the plugin is based!

For the people who want to request support: please make sure that you check the FAQ first. if your question isn’t there feel free to contact me through the contact form here. I receive a lot of requests nowadays, so I ask you for understanding in case of delayed replies.

wpDataTables ver. 1.3

Latest update: 06.12.2013
New in this version:

• Front-end data editing for MySQL-based tables. Editing, deleting and inserting new rows from the site front-end. You can select an editor input type for your rows – text inputs, textareas, datepickers, file uploads and many more supported. For now the front-end editing is only supported with these limitations: 1) MySQL-tables only; 2) Server-Side processing should be enabled; 3) Only one table can be edited with the wpDataTables plugin. See the related documentation page and the demo site for details.
• Placeholder for current user ID. I received many requests for using the current user ID in the MySQL query which creates the table, so implemented it. Now you can put CURRENT_USER_ID placeholder in the query, and it will be replaced with the real ID value when executed.
• Setting default sorting column and sorting direction. Now you can choose which column will be used for sorting on page open, and in which direction (ASC/DESC).
• Selectbox filters for server-side based tables. Now selectboxes are also available for server-side based MySQL tables, but you have to specify all the values.
• Updated and tested with WordPress 3.7.1 – keeping up-to-date with WP

For more info on what’s new and changelog you can see this page.

Update procedure: Disable plugin, overwrite with files from the new package, enable plugin again. This is necessary since the database structure has to be updated on reactivation.

Video previews

• Tables in WordPress from Excel files
• Tables in WordPress from MySQL queries:

Overview

wpDataTables 1.3 is a plugin, based on a phpDataTables module, and is designed to make table process of data representation quick, easy and effective. Now to insert big interactive multi-functional tables in your WordPress site you don’t need to write a single line of code, or HTML markup – wpDataTables allow you to quickly build and render interactive tables with such features as sorting, or saving to PDF from almost any possible data source: MySQL query, CSV files, Excel files, serialized PHP arrays, XML and JSON data sources.

Features

A short list of wpDataTables features:

• Cute interactive multi-functional front-end jQuery tables with filtering, sorting and pagination features rendered by DataTables jQuery plugin. You can manipulate all features easily from the WordPress admin panel. The initial javascript is compilated by PHP and then executed in your browser.
• Advanced front-end table features: print view, save to PDF, save to CSV, save to Excel, Copy to clipboard by TableTools DataTables plugin.
• Different column types: strings, integer, float, date, URL links, e-mail links, images.
• Column reordering, hiding, specifying different headers and other “runtime” tweaks.
• Fixed headers and fixed columns feature based on modified FixedHeader DataTables plugin. For high, and wide tables, table header and chosen amount of columns “stick” to the window border when you scroll the table – analog of Excel’s “Freeze Pane” feature. See live example.
• Row grouping based on Row Grouping DataTables plugin. If a lot of rows have same values of some column you can group them based on the value of this column. The sorting will be performed inside of these groups. See live example.
• Charts based on Google Chart Tools. Easily render charts from the same dataset as your table. Line charts, Pie charts.

WP Admin panel screenshots

Click to see full screenshot



Documentation and examples

Check out the documentation and live examples before you purchase on our demo site. Offline version of documentation also included in the package.