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.

samwilson

<a href="http://tabulate.readthedocs.org/en/latest/?badge=latest" rel="nofollow ugc"></a> 
<a href="https://travis-ci.org/tabulate/tabulate" rel="nofollow ugc"></a> 
<a href="" rel="nofollow ugc"></a> 
<a href="" rel="nofollow ugc"></a> 
<a href="https://wordpress.org/plugins/tabulate" rel="ugc"></a> 
<a href="" rel="nofollow ugc"></a> 
<a href="https://github.com/tabulate/tabulate/blob/master/LICENSE.txt" rel="nofollow ugc"></a> 
<a href="https://scrutinizer-ci.com/g/tabulate/tabulate/?branch=master" rel="nofollow ugc"></a>
This plugin provides a simple user-friendly interface to tables in your database. 
Somewhat akin to phpMyAdmin, but easier to use and more focused on end users.
The documentation can be found at <a href="https://tabulate.readthedocs.org/" rel="nofollow ugc">tabulate.readthedocs.org</a>.
Features (in no particular order):
<ol>
<li>Tables can be filtered by any column or columns, and with a range of 
operators (‘contains’, ‘is’, ’empty’, ‘one of’, ‘greater than’, ‘less than’, 
and the negations of all of these). Multiple filters are conjunctive 
(i.e. with a logical and).</li>
<li>Access can be granted to read, create, update, delete, and import 
records in any or all tables. (This can be done by anyone with the 
promote_users capability.) Access can also be granted to anonymous users.</li>
<li>CSV data can be imported, with the UI supporting column mapping, data 
validation, and previewing prior to final import. If an imported row has a 
value for the Primary Key, the existing row will be overwritten.</li>
<li>Data can be exported to CSV, including after filters have been applied. </li>
<li>A quick-jump navigation box is located top right of every page, 
and can also be added as a Dashboard widget.</li>
<li>Records in tables with date columns can be viewed in a calendar.</li>
<li>Entity Relationship Diagrams (drawn with <a href="http://graphviz.org/" rel="nofollow ugc">GraphViz</a>) 
can be automatically generated, with any specified subset of tables. Foreign 
keys are displayed as directed edges. This feature is only available if the 
<a href="https://wordpress.org/plugins/tfo-graphviz/" rel="ugc">TFO Graphviz plugin</a> is installed.</li>
<li>All data modifications are recorded, along with optional comments that users 
can provide when updating data.</li>
<li>The <code>[tabulate]</code> shortcode can be used to embed tables, lists, row-counts, 
and data-entry forms into WordPress content. For more details, 
<a href="https://tabulate.readthedocs.org/en/latest/shortcode.html" rel="nofollow ugc">read the documentation</a>.</li>
<li>Tables with point columns can be exported to KML and OpenStreetMap XML. 
Also, data entry for these columns is done with a small slippy map, on which 
a marker can be placed.</li>
</ol>
Development is managed on GitHub 
at <a href="https://github.com/tabulate/tabulate" rel="nofollow ugc">github.com/tabulate/tabulate</a>

Tabulate

Manage relational tabular data using the full power of your MySQL database. CSV import/export; access-control; foreign-keys; and lots more.

Simple Table Manager vs Tabulate