Deskripsi
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 [dbtable]
into an article or a page and you will have a nice and clean table.
Contoh:
All parameters that contain more than one value have to be separated by commas without spaces.
Minimum needed : [dbtable from=MysqlTableName]
select=field1,field2,field3
will display all rows of the table and only specified fieldsexcept=field1,field2,field3
will display all rows of the table except specified fieldscssClass=class1,class2
will add class1 and class2 to the class attribut of the tablecomments=true|(false)
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.pagination=true|(false)
will show/hide the bottom pagination links. If false, make sure you have the limit parameter large enough to display all your dataslimit=25
Display 25 rows by default.
Instalasi
Dari dasbor WordPress Anda
- Kunjungi ‘Plugin > Tambah Baru’
- Search for ‘DbTable to DataTable’
- Activate DbTable to DataTable from your Plugins page.
- That’s it!
Dari WordPress.org
- Download DbTable to DataTable.
- Upload the ‘DbTable2DataTable’ directory to your ‘/wp-content/plugins/’ directory, using your favorite method (ftp, sftp, scp, etc…)
- Activate ‘DbTable to DataTable’ from your Plugins page.
- That’s it !
Tanya Jawab
- 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 <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 );
- What the `comments` attribut does?
-
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'
- Why can’t I display datas from a WordPress Table ?
-
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.
- How can I force the plugin to shows WP tables ?
-
You can remove the security check
line 58
by deletingor substr($atts['from'], 0,strlen($wpdb->prefix)) === $wpdb->prefix
- Why the language doesn’t change?
-
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 beFrench
with the first letter in uppercase.
Ulasan
Kontributor & Pengembang
“DbTable to DataTable” adalah perangkat lunak open source. Berikut ini mereka yang sudah berkontribusi pada plugin ini.
KontributorTerjemahkan “DbTable to DataTable” dalam bahasa Anda.
Tertarik mengembangkan?
Lihat kode, periksa repositori SVN , atau mendaftar ke log pengembangan melalui RSS.
Log Perubahan
0.1
- First version