Peter Lawrenson

ryo0inoue

Simple Table Manager enables editing table records and exporting them to CSV files through a minimal database interface from your dashboard.
<ul>
<li>Simply CRUD table contents on your wp-admin screen</li>
<li>Search and sort table records</li>
<li>No knowledge of MySQL or PHP required</li>
<li>Export table records to a CSV file</li>
<li>Does not allow users to create tables or change the structure of the table</li>
</ul>
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.
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.

Simple Table Manager

As advertised, this plugin is great for a non-techy admin to create and edit data, and I recommended the plugin for this purpose.
I used phpMyAdmin to setup the table and then used the plugin to create the initial set of records. There are no display facilities with the plugin so I a used a bit of custom code. Only 2 lines are needed to fetch the data into a php function:
global $wpdb;
$results = $wpdb->get_results( 'SELECT * FROM wp_mytable', ARRAY_N );
The plugin will allow access to only one table at a time, but its easy to switch between tables.
Thanks for sharing.



Great for non-techy admin to maintain data.

Enables viewing and editing table records and exporting them to CSV files through a minimal database interface from your dashboard.

zerotop

This plugins lets you define forms in the admin area for existing tables in your WordPress database.
The creation of forms to Create, Update and Delete records is a lot of work. This plugin lets you define the tables and its fields and generates the form for you. The definition of your tables and fields is done in the ‘Your Tables’ and ‘Your Table Fields’ items in the ‘Your Tables’ menu. This functionality is created using the Table definition functionality of this plugin itself. Drink your own Champagne!
These are its features:
<ul>
<li>Manage all tables in your WordPress database in the admin area</li>
<li>Create, Update and optionaly Delete records</li>
<li>Textbox, Dropdown, List, Radiobox, Checkbox, Date and Textarea support</li>
<li>Dropdown, List and Radioboxes can be filled with predefined values or with an SQL query that results in 2 columns (value,label)</li>
<li>Use one or more primary keys to select the correct record in your tables</li>
<li>Define what roles can use the tables</li>
<li>Optionaly change the functionality of the Table and Field definition forms</li>
<li>Language support (Currently English and Dutch language is available. We’re looking for translators!)</li>
</ul>
Request: Currently English and Dutch language is available. If you want to translate for us we will add your name here:
<ul>
<li>English translation: Benjamin de Jong</li>
<li>Dutch translation: Benjamin de Jong</li>
</ul>

Your Tables

This plugins lets you define forms in the admin area for existing tables in your WordPress database.

Simple Table Manager vs Your Tables