How do I change default values?

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 );

by rikemsen 5 (4 reviews)

DbTable to DataTable

Name: DbTable to DataTable
Rating: 5.0 (4 reviews)
Author: rikemsen

Display mysql datas into datatable.

DbTable to DataTable ranks #25,792 among WordPress.org plugins with 20+ active installations, is #1,914 of 4,977 in the Utilities & Tools category, a 5/5 rating from 4 reviews, and was last updated Feb 12, 2016. Data from WordPress.org, refreshed twice daily — see methodology.

Tested up to WP 4.4 (Current: 7.1.2)

vtrunk Current Version vtrunk

Updated 10 years ago Last Update on 12 Feb, 2016

Refreshed 14 hours ago Last Refreshed on

#1,914 of 4,977 in Utilities & Tools Top 50% by installs No update in over a year

View on WordPress.org

Rank

#25,792

+84 this week

Active Installs

20+

-20%

KW Avg Position

— No change

Downloads

+3 today

Support Resolved

— No change

Rating

100%

Review 5 out of 5

5 (4 reviews)

Next Milestone 30

Total Progress 30%

20+ 30+

12,926

Ranks to Climb

Growth Needed

8,000,000

Active Installs

Pro

Unlock Exact Install Count

See the precise estimated active installs for this plugin, calculated from real-time ranking data.

Exact install estimates within tiers
Track install growth over time
Milestone progress predictions

Upgrade to Pro

Need 7 more installs to reach 30+

Rank Changes

Current #25,792

Change

Best #

Upgrade to Pro

Unlock 30-day and 90-day rank history charts with a Pro subscription.

Upgrade Now

Active Installs Growth

Upgrade to Pro

Active Installs 0,000,000+

Growth +0.0%

Peak 0,000,000

Downloads Growth

Downloads

Growth

Peak

Upgrade to Pro

Unlock 30-day, 90-day, and yearly download history charts with a Pro subscription.

Upgrade Now

Reviews & Ratings

5.0

4 reviews

Overall 100%

4 (100%)

0 (0%)

Track This Plugin

Get detailed analytics, keyword tracking, and position alerts delivered to your inbox.

Start Tracking Free

Plugin Details

Version: trunk
Last Updated: Feb 12, 2016
Requires WP: 4.4+
Tested Up To: 4.4
PHP Version: N/A
Author: rikemsen

Support & Rating

Rating: ★ ★ ★ ★ ★ 5
Reviews: 4
Support Threads: 0
Resolved: 0%

Keywords

datatable jquery mysql sortable table

Upgrade to Pro

Unlock keyword rankings, search positions, and detailed analytics with a Pro subscription.

Upgrade Now

Similar Plugins

Adminify – White Label, Admin Menu Editor, Login Customizer

6K+ installs

#2,758

Master Addons for Elementor – Elementor Addons, Widgets, Mega Menu Builder, Popup Builder, Widget Builder & Template Kits

30K+ installs

#1,008

Elementor Website Builder - more than just a page builder

10M+ installs

Contact Form 7

10M+ installs

All-in-One WP Migration and Backup

5M+ installs

#10

UpdraftPlus: WP Backup & Migration Plugin

3M+ installs

#15

WPCode - Insert Headers and Footers + Custom Code Snippets - WordPress Code Manager

View all Utilities-and-tools plugins

Frequently Asked Questions

Common questions about DbTable to DataTable

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 <table> '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 );

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.