Title: DbTable to DataTable Author: rikemsen Published: Èrèlé 12, 2016 Last modified: Èrèlé 12, 2016 --- Ṣàwárí àwọn plugin Plugin yìí **kò tíì ṣe àyẹ̀wò pẹ̀lú àwọn ìtújáde mẹ́ta pàtàkì tó kẹ́yìn ti WordPress**. Ó lè jẹ́ pé a kò tọ́jú tàbí ṣe àtìlẹ́yìn fún un mọ́, ó sì lè ní àwọn ọ̀ràn ìbámu nígbà tí a bá lò ó pẹ̀lú àwọn ẹ̀yà WordPress tuntun. ![](https://s.w.org/plugins/geopattern-icon/dbtable-to-datatable.svg) # DbTable to DataTable Láti ọwọ́ [rikemsen](https://profiles.wordpress.org/rikemsen/) [Ṣe ìgbàsílẹ̀](https://downloads.wordpress.org/plugin/dbtable-to-datatable.zip) * [Àwọn àlàyé](https://yor.wordpress.org/plugins/dbtable-to-datatable/#description) * [Àwọn àgbéyẹ̀wò](https://yor.wordpress.org/plugins/dbtable-to-datatable/#reviews) * [Ìgbéwọlẹ̀](https://yor.wordpress.org/plugins/dbtable-to-datatable/#installation) * [Ìdàgbàsókè](https://yor.wordpress.org/plugins/dbtable-to-datatable/#developers) [Ìrànlọ́wọ́](https://wordpress.org/support/plugin/dbtable-to-datatable/) ## Àpèjúwe This plugin allows you to display the content of MySql tables into sortable html tables thanks to the DataTable jQuery Plugin. You donÌtumọ̀ Yorùbá: ’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. ### Examples: 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 fields * `except=field1,field2,field3` will display all rows of the table except specified fields * `cssClass=class1,class2` will add class1 and class2 to the class attribut of the table * `comments=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 datas * `limit=25` Display 25 rows by default. ## Ìgbéwọlẹ̀ #### From your WordPress dashboard * Visit ‘Plugins > Add New’ * Search for ‘DbTable to DataTable’ * Activate DbTable to DataTable from your Plugins page. * ThatÌtumọ̀ Yorùbá: ’s it! #### From 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Ìtumọ̀ Yorùbá: ’s it ! ## FAQ 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 ); ``` 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Ìtumọ̀ Yorùbá: ’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 deleting `or substr($atts['from'], 0,strlen($wpdb->prefix)) === $wpdb->prefix` Why the language doesnÌtumọ̀ Yorùbá: ’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 be `French` with the first letter in uppercase. ## Àwọn àgbéyẹ̀wò ![](https://secure.gravatar.com/avatar/f0f5553efa2fd9fd2865693ee69119452ec8c5976cb92d7ae13f1f04d907a0bc? s=60&d=retro&r=g) ### 󠀁[Great](https://wordpress.org/support/topic/great-12026/)󠁿 [franmoracr](https://profiles.wordpress.org/franmoracr/) Ọwẹ́wẹ̀ 13, 2020 Great plugin very easy to use. ![](https://secure.gravatar.com/avatar/15be2600265c6916f9e7bf68b87debb11b60e156ce3b45eca4bda5908f0c80a1? s=60&d=retro&r=g) ### 󠀁[CSS](https://wordpress.org/support/topic/css-123/)󠁿 [haloya090984](https://profiles.wordpress.org/haloya090984/) Ọwẹ́wẹ̀ 3, 2016 how to change css? ![](https://secure.gravatar.com/avatar/961cf8c865840f941c2d457699632dfe8ef792384a3930f76d5fd9515dd22ee3? s=60&d=retro&r=g) ### 󠀁[Great !!](https://wordpress.org/support/topic/great-4490/)󠁿 [mrphung](https://profiles.wordpress.org/mrphung/) Ọwẹ́wẹ̀ 3, 2016 ItÌtumọ̀ Yorùbá: ’s great !!!!!!! ![](https://secure.gravatar.com/avatar/4f556acb3f8ed803a31ad66633b42a17997563fe5f4bce6de9abcdb9e93c8c89? s=60&d=retro&r=g) ### 󠀁[Nice job](https://wordpress.org/support/topic/nice-job-113/)󠁿 [63ck0](https://profiles.wordpress.org/63ck0/) Ọwẹ́wẹ̀ 3, 2016 Simple and effective, do the job. [ Ka gbogbo àwọn àgbéyẹ̀wò 4 ](https://wordpress.org/support/plugin/dbtable-to-datatable/reviews/) ## Àwọn Olùkópa & Olùgbéejáde “DbTable to DataTable” jẹ́ ètò ìṣàmúlò orísun ṣíṣí sílẹ̀. Àwọn ènìyàn wọ̀nyí ti ṣe ìkópa sí plugin yìí. Àwọn Olùkópa * [ rikemsen ](https://profiles.wordpress.org/rikemsen/) [Túmọ̀ “DbTable to DataTable” sí èdè rẹ.](https://translate.wordpress.org/projects/wp-plugins/dbtable-to-datatable) ### Ṣe o nífẹ̀ẹ́ sí ìdàgbàsókè? [Ṣàwárí koodu](https://plugins.trac.wordpress.org/browser/dbtable-to-datatable/), ṣàyẹ̀wò [ibi ìpamọ́ SVN](https://plugins.svn.wordpress.org/dbtable-to-datatable/), tàbí ṣe àgbékalẹ̀ sí [àkọsílẹ̀ ìdàgbàsókè](https://plugins.trac.wordpress.org/log/dbtable-to-datatable/) nípasẹ̀ [RSS](https://plugins.trac.wordpress.org/log/dbtable-to-datatable/?limit=100&mode=stop_on_copy&format=rss). ## Àkọsílẹ̀ àwọn àyípadà #### 0.1 * First version ## Àkójọpọ̀ Meta * Ẹ̀yà **0.1** * Ìgbàgbọ́hùn tó kẹ́yìn **ọdún 10 sẹ́yìn** * Àwọn ìgbéwọlẹ̀ tó ṣiṣẹ́ **20+** * Ẹ̀yà WordPress ** 4.4 tàbí ju bẹ́ẹ̀ lọ ** * Dánwò dé **4.4.34** * Èdè * [English (US)](https://wordpress.org/plugins/dbtable-to-datatable/) * Àwọn àmì * [datatable](https://yor.wordpress.org/plugins/tags/datatable/)[jquery](https://yor.wordpress.org/plugins/tags/jquery/) [mysql](https://yor.wordpress.org/plugins/tags/mysql/)[sortable](https://yor.wordpress.org/plugins/tags/sortable/) [table](https://yor.wordpress.org/plugins/tags/table/) * [Ìwòye Tó Péye](https://yor.wordpress.org/plugins/dbtable-to-datatable/advanced/) ## Àwọn ìbò 5 lára àwọn ìràwọ̀ 5. * [ 4 5-star reviews ](https://wordpress.org/support/plugin/dbtable-to-datatable/reviews/?filter=5) * [ 0 4-star reviews ](https://wordpress.org/support/plugin/dbtable-to-datatable/reviews/?filter=4) * [ 0 3-star reviews ](https://wordpress.org/support/plugin/dbtable-to-datatable/reviews/?filter=3) * [ 0 2-star reviews ](https://wordpress.org/support/plugin/dbtable-to-datatable/reviews/?filter=2) * [ 0 1-star reviews ](https://wordpress.org/support/plugin/dbtable-to-datatable/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/dbtable-to-datatable/reviews/#new-post) [See all reviews](https://wordpress.org/support/plugin/dbtable-to-datatable/reviews/) ## Àwọn Olùkópa * [ rikemsen ](https://profiles.wordpress.org/rikemsen/) ## Ìrànlọ́wọ́ Nǹkan wà tí o fẹ́ sọ? Ṣé o nílò ìrànlọ́wọ́? [Wo àpéjọ ìrànlọ́wọ́](https://wordpress.org/support/plugin/dbtable-to-datatable/)