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.

faina09

Use the jqGrid plugin of jquery to manage MySql db tables.
Works with PHP 5.4.0 or higher: please report any issue you find, and any feature you want. I’ll try to fix the firsts and to implement the seconds!
Try it out on your <a href="http://tastewp.com/new?pre-installed-plugin-slug=wp-fjqgrid&redirect=options-general.php%3Fpage%3Dwpf-jqgrid&ni=true" rel="nofollow ugc">free dummy site</a>. 
The link spins up a new TasteWP instance with the WPF-jqGrid plugin already installed.
This is a very first release with many limitations; jqGrid offers a lot of features but only few are actually supported by this plugin.
I planned to develop many other features, but this depends by the interest of the users, and eventually from the support. If you want to contribute with a translation or writing code ask me, if you want to make a donation here’s the link.
thanks to:
<ul>
<li>
Tobias for German de_DE translation
</li>
<li>
Andrijana Nikolic <a href="mailto:andrijanan@webhostinggeeks.com" rel="nofollow ugc">andrijanan@webhostinggeeks.com</a> by WebHostingGeeks Support (http://webhostinggeeks.com/) for Serbo-Croatian sr_RS translation
</li>
</ul>
If any bug found please ask me for support!
Info and samples at <a href="http://faina09.it/category/wp-plugins/wp-fjqgrid/" rel="nofollow ugc">WPF-jqGrid developer’s site</a>
WARNING: do to a plugin rename, the current plugin directory is wp-content\plugins\wp-fjqgrid while the plugin name and the shortcode has the ‘-‘ in a different position: wpf-jqgrid.

WPF-jqGrid

Use jqGrid (a jQuery plugin) to manage database tables. Use shortcode like [wpf-jqgrid table='wpf_jqgrid_sample' idtable=1 caption='nam …

Simple Table Manager vs WPF-jqGrid