Title: DbTable to DataTable Author: rikemsen Published: 2016 年 2 月 12 日 Last modified: 2016 年 2 月 12 日 --- 搜尋外掛 這個外掛**並未在最新的 3 個 WordPress 主要版本上進行測試**。開發者可能不再對這個 外掛進行維護或提供技術支援，並可能會與更新版本的 WordPress 產生使用上的相容性問題。 ![](https://s.w.org/plugins/geopattern-icon/dbtable-to-datatable.svg) # DbTable to DataTable 由 [rikemsen](https://profiles.wordpress.org/rikemsen/) 開發 [下載](https://downloads.wordpress.org/plugin/dbtable-to-datatable.zip) * [詳細資料](https://tw.wordpress.org/plugins/dbtable-to-datatable/#description) * [使用者評論](https://tw.wordpress.org/plugins/dbtable-to-datatable/#reviews) * [安裝方式](https://tw.wordpress.org/plugins/dbtable-to-datatable/#installation) * [開發資訊](https://tw.wordpress.org/plugins/dbtable-to-datatable/#developers) [技術支援](https://wordpress.org/support/plugin/dbtable-to-datatable/) ## 外掛說明 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. ### 例如： 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. ## 安裝方式 #### From your WordPress dashboard * Visit ‘Plugins > Add New’ * Search for ‘DbTable to DataTable’ * Activate DbTable to DataTable from your Plugins page. * That’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’s it ! ## 常見問題集 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’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’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. ## 使用者評論 ![](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/) 2020 年 9 月 13 日 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/) 2016 年 9 月 3 日 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/) 2016 年 9 月 3 日 It’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/) 2016 年 9 月 3 日 Simple and effective, do the job. [ 閱讀全部 4 則使用者評論 ](https://wordpress.org/support/plugin/dbtable-to-datatable/reviews/) ## 參與者及開發者 以下人員參與了開源軟體〈DbTable to DataTable〉的開發相關工作。 參與者 * [ rikemsen ](https://profiles.wordpress.org/rikemsen/) [將〈DbTable to DataTable〉外掛本地化為台灣繁體中文版](https://translate.wordpress.org/projects/wp-plugins/dbtable-to-datatable) ### 對開發相關資訊感興趣？ 任何人均可[瀏覽程式碼](https://plugins.trac.wordpress.org/browser/dbtable-to-datatable/)、 查看 [SVN 存放庫](https://plugins.svn.wordpress.org/dbtable-to-datatable/)，或透過 [RSS](https://plugins.trac.wordpress.org/log/dbtable-to-datatable/?limit=100&mode=stop_on_copy&format=rss) 訂閱[開發記錄](https://plugins.trac.wordpress.org/log/dbtable-to-datatable/)。 ## 變更記錄 #### 0.1 * First version ## 中繼資料 * 版本 **0.1** * 最後更新 **10 年前** * 啟用安裝數 **20+** * WordPress 版本需求 ** 4.4 或更新版本 ** * 已測試相容的 WordPress 版本 **4.4.34** * 語言 * [English (US)](https://wordpress.org/plugins/dbtable-to-datatable/) * 標籤: * [datatable](https://tw.wordpress.org/plugins/tags/datatable/)[jquery](https://tw.wordpress.org/plugins/tags/jquery/) [mysql](https://tw.wordpress.org/plugins/tags/mysql/)[sortable](https://tw.wordpress.org/plugins/tags/sortable/) [table](https://tw.wordpress.org/plugins/tags/table/) * [進階檢視](https://tw.wordpress.org/plugins/dbtable-to-datatable/advanced/) ## 評分 5 星，滿分為 5 星 * [ 4 個 5 星使用者評論 ](https://wordpress.org/support/plugin/dbtable-to-datatable/reviews/?filter=5) * [ 0 個 4 星使用者評論 ](https://wordpress.org/support/plugin/dbtable-to-datatable/reviews/?filter=4) * [ 0 個 3 星使用者評論 ](https://wordpress.org/support/plugin/dbtable-to-datatable/reviews/?filter=3) * [ 0 個 2 星使用者評論 ](https://wordpress.org/support/plugin/dbtable-to-datatable/reviews/?filter=2) * [ 0 個 1 星使用者評論 ](https://wordpress.org/support/plugin/dbtable-to-datatable/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/dbtable-to-datatable/reviews/#new-post) [查看全部使用者評論](https://wordpress.org/support/plugin/dbtable-to-datatable/reviews/) ## 參與者 * [ rikemsen ](https://profiles.wordpress.org/rikemsen/) ## 技術支援 使用者可在技術支援論壇提出意見反應或使用問題。 [檢視技術支援論壇](https://wordpress.org/support/plugin/dbtable-to-datatable/)