{"id":34859,"date":"2015-03-03T04:14:33","date_gmt":"2015-03-03T04:14:33","guid":{"rendered":"https:\/\/wordpress.org\/plugins-wp\/simple-table-manager\/"},"modified":"2025-01-19T23:50:13","modified_gmt":"2025-01-19T23:50:13","slug":"simple-table-manager","status":"publish","type":"plugin","link":"https:\/\/gd.wordpress.org\/plugins\/simple-table-manager\/","author":14309243,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"1.6.1","stable_tag":"1.6.1","tested":"6.7.5","requires":"6.2","requires_php":"7.3","requires_plugins":null,"header_name":"Simple Table Manager","header_author":"Ryo Inoue & lorro","header_description":"","assets_banners_color":"acc9e9","last_updated":"2025-01-19 23:50:13","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"","header_author_uri":"https:\/\/www.topcode.co.uk\/developments\/simple-table-manager\/","rating":4.8,"author_block_rating":0,"active_installs":400,"downloads":24473,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":{"1.6.1":{"tag":"1.6.1","author":"lorro","date":"2025-01-19 23:50:13"}},"upgrade_notice":{"1.6.1 (2025-01-14)":"<ul>\n<li>Changes to meet wordpress.org plugin security guidelines<\/li>\n<li>Checked to work with WordPress 6.7<\/li>\n<\/ul>"},"ratings":{"1":0,"2":0,"3":0,"4":1,"5":3},"assets_icons":{"icon-128x128.png":{"filename":"icon-128x128.png","revision":1133727,"resolution":"128x128","location":"assets","locale":""}},"assets_banners":{"banner-772x250.png":{"filename":"banner-772x250.png","revision":1134129,"resolution":"772x250","location":"assets","locale":""}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.6.1"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":2496816,"resolution":"1","location":"assets","locale":""},"screenshot-2.png":{"filename":"screenshot-2.png","revision":2496816,"resolution":"2","location":"assets","locale":""},"screenshot-3.png":{"filename":"screenshot-3.png","revision":2496816,"resolution":"3","location":"assets","locale":""},"screenshot-4.png":{"filename":"screenshot-4.png","revision":2496816,"resolution":"4","location":"assets","locale":""},"screenshot-5.png":{"filename":"screenshot-5.png","revision":2496816,"resolution":"5","location":"assets","locale":""},"screenshot-6.png":{"filename":"screenshot-6.png","revision":2496816,"resolution":"6","location":"assets","locale":""}},"screenshots":{"1":"List records","2":"Edit record","3":"Add record","4":"Settings"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[56868,153,1859,1627,2289],"plugin_category":[59],"plugin_contributors":[175820,196987],"plugin_business_model":[],"class_list":["post-34859","plugin","type-plugin","status-publish","hentry","plugin_tags-crud","plugin_tags-database","plugin_tags-export","plugin_tags-mysql","plugin_tags-table","plugin_category-utilities-and-tools","plugin_contributors-lorro","plugin_contributors-ryo0inoue","plugin_committers-lorro","plugin_committers-ryo0inoue"],"banners":{"banner":"https:\/\/ps.w.org\/simple-table-manager\/assets\/banner-772x250.png?rev=1134129","banner_2x":false,"banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/simple-table-manager\/assets\/icon-128x128.png?rev=1133727","icon_2x":false,"generated":false},"screenshots":[{"src":"https:\/\/ps.w.org\/simple-table-manager\/assets\/screenshot-1.png?rev=2496816","caption":"List records"},{"src":"https:\/\/ps.w.org\/simple-table-manager\/assets\/screenshot-2.png?rev=2496816","caption":"Edit record"},{"src":"https:\/\/ps.w.org\/simple-table-manager\/assets\/screenshot-3.png?rev=2496816","caption":"Add record"},{"src":"https:\/\/ps.w.org\/simple-table-manager\/assets\/screenshot-4.png?rev=2496816","caption":"Settings"},{"src":"https:\/\/ps.w.org\/simple-table-manager\/assets\/screenshot-5.png?rev=2496816","caption":""},{"src":"https:\/\/ps.w.org\/simple-table-manager\/assets\/screenshot-6.png?rev=2496816","caption":""}],"raw_content":"<!--section=description-->\n<p>Simple Table Manager enables editing table records and exporting them to CSV files through a minimal database interface from your dashboard.<\/p>\n\n<ul>\n<li>Simply CRUD table contents on your wp-admin screen<\/li>\n<li>Search and sort table records<\/li>\n<li>No knowledge of MySQL or PHP required<\/li>\n<li>Export table records to a CSV file<\/li>\n<li>Does not allow users to create tables or change the structure of the table<\/li>\n<\/ul>\n\n<p>Simple Table Manager is a tool suited for the initial development phase of a website. It is ideal when you want to ask someone else with no database expertise to keep track of table records on your website. This was the motivation for developing this plugin.<\/p>\n\n<p>Note that to comply with wordpress.org plugin security guidelines, edited and added record fields are filtered through wp_kses_post() to prevent sql injection attacks. In some cases, wanted tags may be filtered out leading to field corruption.<\/p>\n\n<!--section=installation-->\n<ol>\n<li>Via the Dashboard &gt; Plugins &gt; Add plugin menu page.<\/li>\n<li>Or upload the entire 'simple-table-manager' folder to the '\/wp-content\/plugins\/' directory.<\/li>\n<li>Activate the plugin through the 'Plugins' menu in WordPress.<\/li>\n<li>On the plugin's 'Settings' page, select the table you want to view and manage.<\/li>\n<\/ol>\n\n<p>Filter call examples for developer use:<\/p>\n\n<p>\/\/ change a value<\/p>\n\n<pre><code>add_filter( 'tstm_list_field', 'custom_list_field_value', 10, 4 );\nfunction custom_list_field_value( $field_value, $current_table, $column_name, $key_value ) {\n  if( 'wppb_options' == $current_table ) {\n    if( 'option_value' == $column_name ) {\n      if( 7 == $key_value ) {\n        if( $field_value ) {\n          $field_value = \"true\";\n        } else {\n          $field_value = \"false\";\n        }\n      }\n    }\n  }\n  return $field_value;\n}\n<\/code><\/pre>\n\n<p>\/\/ change the default text input for radios<\/p>\n\n<pre><code>add_filter( 'tstm_add_field_html', 'custom_field_html', 10, 4 );\nadd_filter( 'tstm_edit_field_html', 'custom_field_html', 10, 4 );\nfunction custom_field_html( $field_html, $current_table, $column_name, $field_value, $key_value = true  ) {\n  if( 'wppb_options' == $current_table ) {\n    if( 'option_value' == $column_name ) {\n      $column_name = urlencode( $column_name );\n      if( $field_value ) {\n        $field_html = '&lt;input type=\"radio\" name=\"'.$column_name.'\" value=\"1\" checked&gt; Yes&lt;br&gt;';\n        $field_html .= '&lt;input type=\"radio\" name=\"'.$column_name.'\" value=\"0\"&gt; No';\n      } else {\n        $field_html = '&lt;input type=\"radio\" name=\"'.$column_name.'\" value=\"1\"&gt; Yes&lt;br&gt;';\n        $field_html .= '&lt;input type=\"radio\" name=\"'.$column_name.'\" value=\"0\" checked&gt; No';      \n      }\n    }\n  }\n  return $field_html;\n}\n<\/code><\/pre>\n\n<p>\/\/ change the default text input for a checkbox<\/p>\n\n<pre><code>add_filter( 'tstm_add_field_html', 'custom_field_html', 10, 5 );\nadd_filter( 'tstm_edit_field_html', 'custom_field_html', 10, 5 );\nfunction custom_field_html( $field_html, $current_table, $column_name, $field_value, $key_value = true ) {\n  if( 'wppb_options' == $current_table ) {\n    if( 'option_value' == $column_name ) {\n      if( 7 == $key_value ) {\n        $checked = $field_value ? 'checked' : '';\n        $field_html = '&lt;input type=\"hidden\" name=\"'.$column_name.'\" value=\"0\"&gt;'.PHP_EOL;\n        $field_html .= '&lt;input type=\"checkbox\" name=\"'.$column_name.'\" value=\"1\" '.$checked.'&gt;'.PHP_EOL;\n      }\n    }\n  }\n  return $field_html;\n}\n<\/code><\/pre>\n\n<!--section=faq-->\n<dl>\n<dt id='how%20can%20i%20add%20a%20new%20table%20or%20field%20by%20using%20the%20plugin%3F'><h3>How can I add a new table or field by using the plugin?<\/h3><\/dt>\n<dd><p>You can't. Use 'full featured' plugins or phpMyAdmin if you need full access to the database.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>1.6.1 (2025-01-14)<\/h4>\n\n<ul>\n<li>Changes to meet wordpress.org plugin security guidelines<\/li>\n<li>Checked to work with WordPress 6.7<\/li>\n<\/ul>\n\n<h4>1.6.0 (2023-11-26)<\/h4>\n\n<ul>\n<li>Enhanced security and other changes to comply with wordpress.org plugin guidelines.<\/li>\n<li>Checked to work with WordPress 6.4<\/li>\n<\/ul>\n\n<h4>1.5.6 (2023-07-23)<\/h4>\n\n<ul>\n<li>WHERE clause construction refactored<\/li>\n<li>Checked to work with WordPress 6.2<\/li>\n<\/ul>\n\n<h4>Version 1.5.5 (2022-01-20)<\/h4>\n\n<ul>\n<li>Function \"stm_load_textdomain\" renamed to remove conflict with course-editor plugin.<\/li>\n<\/ul>\n\n<h4>Version 1.5.4 (2021-10-24)<\/h4>\n\n<ul>\n<li>New feature: Option in the settings tab to restrict plugin access to administrators (Defaults to \"Authors\" and better capabilities)<\/li>\n<\/ul>\n\n<h4>Version 1.5.3 (2021-10-19)<\/h4>\n\n<ul>\n<li>Tested with WP 5.8<\/li>\n<li>Translation file updated<\/li>\n<\/ul>\n\n<h4>Version 1.5.2 (2021-03-15)<\/h4>\n\n<ul>\n<li>Added a setting to pretty print any unserialized arrays on the Edit tab<\/li>\n<li>Added a filter example to show how to setup a checkbox input with the plugin<\/li>\n<li>Tested with WP v5.7 &amp; PHP v8.0.2<\/li>\n<\/ul>\n\n<h4>Version 1.5.1 (2021-03-04)<\/h4>\n\n<ul>\n<li>Version 1.5.0 upload was corrupted. Re-uploaded.<\/li>\n<\/ul>\n\n<h4>Version 1.5.0 (2021-03-04)<\/h4>\n\n<ul>\n<li>Changes by: lorro<\/li>\n<li>New feature - User can select a sub-set of fields to show. Enables wide tables to fit the screen.<\/li>\n<li>New feature - Filters for List table field display and for Edit and Add field html. See Installation section for use.<\/li>\n<li>Redesigned interface<\/li>\n<li>Tested with WordPress 5.6.2<\/li>\n<li>Updated readme.txt<\/li>\n<\/ul>\n\n<h4>Version 1.4 (2020-09-07)<\/h4>\n\n<ul>\n<li>Changes by: lorro<\/li>\n<li>Fixed errors if column names have spaces.<\/li>\n<li>Date fields have a date picker in the Edit and Add screens.<\/li>\n<li>Time fields have a time picker in the Edit and Add screens.<\/li>\n<li>Works if the primary column is not the first column<\/li>\n<li>Edit and Add screens show data types.<\/li>\n<li>Minor styling improvements.<\/li>\n<li>Tested with WordPress 5.5.1<\/li>\n<li>Updated readme.txt<\/li>\n<\/ul>\n\n<h4>Version 1.3 (2019-08-20)<\/h4>\n\n<ul>\n<li>Changes by: lorro<\/li>\n<li>Fix error on activation if database prefix is not \"wp_\"<\/li>\n<li>Fix CSV Export.<\/li>\n<li>Fix $order not found error.<\/li>\n<li>Make all strings translation-ready.<\/li>\n<li>Cosmetic changes<\/li>\n<\/ul>\n\n<h4>Version 1.2 (2016-01-15)<\/h4>\n\n<ul>\n<li>Author: Ryo Inoue<\/li>\n<li>Enabled handling of non-integer primary keys.<\/li>\n<\/ul>\n\n<h4>Version 1.1 (2015-05-02)<\/h4>\n\n<ul>\n<li>Author: Ryo Inoue<\/li>\n<li>Added feature to auto-adjust input text fields according to data type.<\/li>\n<li>Enabled insert and retrieval of data containing special chars.<\/li>\n<li>Rearranged files for a loosely MVC structure.<\/li>\n<li>Fixed a few minor bugs.<\/li>\n<\/ul>\n\n<h4>Version 1.0 (2015-03-03)<\/h4>\n\n<ul>\n<li>Author: Ryo Inoue<\/li>\n<li>First release<\/li>\n<\/ul>","raw_excerpt":"Enables viewing and editing table records and exporting them to CSV files through a minimal database interface from your dashboard.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/gd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/34859","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/gd.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/gd.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=34859"}],"author":[{"embeddable":true,"href":"https:\/\/gd.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/ryo0inoue"}],"wp:attachment":[{"href":"https:\/\/gd.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=34859"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/gd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=34859"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/gd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=34859"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/gd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=34859"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/gd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=34859"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/gd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=34859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}