Title: DbTable to DataTable Author: rikemsen Published: 2016년 2월 12일 Last modified: 2016년 2월 12일 --- 플러그인 검색 이 플러그인은 **최근 3개의 주요 워드프레스 출시와 시험 되지 않았습니다**. 워드프레스의 좀 더 최근 버전으로 이용할 때 더 이상 관리되지 않고 지원되지 않고 호환성 문제가 있을 수 있습니다. ![](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://ko.wordpress.org/plugins/dbtable-to-datatable/#description) * [평가](https://ko.wordpress.org/plugins/dbtable-to-datatable/#reviews) * [설치](https://ko.wordpress.org/plugins/dbtable-to-datatable/#installation) * [개발](https://ko.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. ## 설치 #### 워드프레스 알림판에서 * ‘플러그인 > 새로 추가’ 방문 * Search for ‘DbTable to DataTable’ * Activate DbTable to DataTable from your Plugins page. * That’s it! #### 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 ! ## 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’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/)를 확인하시거나, [개발 기록](https://plugins.trac.wordpress.org/log/dbtable-to-datatable/)을 [RSS](https://plugins.trac.wordpress.org/log/dbtable-to-datatable/?limit=100&mode=stop_on_copy&format=rss) 로 구독하세요. ## 변경이력 #### 0.1 * First version ## 기초 * 버전 **0.1** * 최근 업데이트: **11년 전** * 활성화된 설치 **20+** * 워드프레스 버전 ** 4.4 또는 그 이상 ** * 다음까지 시험됨: **4.4.34** * 언어 * [English (US)](https://wordpress.org/plugins/dbtable-to-datatable/) * 태그: * [datatable](https://ko.wordpress.org/plugins/tags/datatable/)[jquery](https://ko.wordpress.org/plugins/tags/jquery/) [mysql](https://ko.wordpress.org/plugins/tags/mysql/)[sortable](https://ko.wordpress.org/plugins/tags/sortable/) [table](https://ko.wordpress.org/plugins/tags/table/) * [고급 보기](https://ko.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/)