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.

takafu

Once you create a custom table in WordPress, don’t you need a screen to manipulate that data within the WordPress admin panel?
When you prepare other database tables (henceforth, custom tables) in WordPress, you usually need a screen to operate CRUD for that table data in the WordPress admin panel. (CRUD is an acronym for Create, Read, Update, Delete.)
Moreover, it would be great if the screen conforms to the familiar WordPress UI, preferably so that WordPress users can use it intuitively.
However, it requires a certain amount of program development to prepare it in the WordPress admin panel, and this is quite a hassle.
This “Crudiator” makes it possible in just a few steps!
With Crudiator, you can instantly create a screen in the WordPress admin panel that allows CRUD manipulation of custom tables.
If you need to create a screen for CRUD operations on custom tables in WordPress, you will save a whole lot of development man-hours

Crudiator


Worked flawlessly for me! Great plugin!


Works great!


I love that I don't need to go into the database to peek inside custom tables. I hope you keep developing this into the future. Maybe add a search box in the list view to begin with. Sending you a small donation...


Great first iteration!

Crudiator is a plugin that makes it easy to achieve CRUD operations on custom tables in the WordPress admin panel.

Simple Table Manager vs Crudiator