This plugin hasn’t been tested with the latest 3 major releases of WordPress. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.

Simple Table Manager

Description

Simple Table Manager enables editing table records and exporting them to CSV files through minimal database interface from your wp-admin page menu.

  • Simply CRUD table contents on your wp-admin screen
  • Search and sort table records
  • No knowledge on MySQL or PHP required
  • Export table records to a CSV file
  • Not allow users to change the structure of the table

Unlike ‘full featured’ database management plugins, it does not allow users to alter the structure of the table but requires no knowledge on MySQL or PHP.

Similar to CakePHP’s scaffold feature, Simple Table Manager is an auxiliary tool suited for the initial development phase of a website. It is also ideal when you want to ask someone else with no database expertise to keep track of table records on your website (that was my motivation for developing this plugin at least).

Screenshots

  • View of all the records on a table
  • Detailed view to edit records

Installation

  1. Upload the entire simple-table-manager folder to the /wp-content/plugins/ directory
  2. Activate the plugin through the ‘Plugins’ menu in WordPress
  3. On Settings of the plugin’s sub-menu, select the table you want to manage

FAQ

How can I add a new table by using the plugin?

You cannot. Please use ‘full featured’ plugins if you need full access to the database.

Reviews

Great for non-techy admin to maintain data.

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.
Read all 2 reviews

Contributors & Developers

“Simple Table Manager” is open source software. The following people have contributed to this plugin.

Contributors

Translate “Simple Table Manager” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

Version 1.0 (2015-03-03)

First release

Version 1.1 (2015-05-02)

  • Added feature to auto-adjust input text fields according to data type
  • Enabled insert and retrieval of data containing special chars
  • Rearranged files for a loosely MVC structure
  • Fixed a few minor bugs.

Version 1.2 (2016-01-15)

  • Enabled handling of non-integer primary keys