leetsombrero

<p>Jot allows non-technical WordPress administrators to modify MySQL<br />
tables with a lightweight, user-friendly interface.  This plugin currently supports MySQL only.</p>
<h3>Features</h3>
<ul>
<li>Create menus directly in the WordPress administration page to view and interact with tables</li>
<li>Quickly add and edit single entries to the data table</li>
<li>Associate table entries with images, which are uploaded and managed using the Jot interface</li>
<li>Rearrange table entries or split entries into multiple tables</li>
</ul>
<h3>Usage</h3>
<h4>Creating a menu</h4>
<ul>
<li>To create a menu, navigate to the “Settings”>”Jot Settings”</li>
<li>Ensure “Create New” is selected under “Menu Selection”</li>
<li>Fill in your database information and click Update</li>
<li>Choose the table that you want to create a menu for</li>
<li>Fill in the remaining form and click “Add New”</li>
</ul>
<h4>Modifying a menu</h4>
<ul>
<li>To edit a menu, navigate to the “Settings”>”Jot Settings”</li>
<li>Choose a menu to edit under “Menu Selection”</li>
<li>Modify the settings to your liking and click “Save Changes” at the bottom of the page</li>
</ul>
<h4>Deleting a menu</h4>
<ul>
<li>To delete a menu, navigate to the “Settings”>”Jot Settings”</li>
<li>Choose a menu to edit under “Menu Selection”</li>
<li>Click “Delete Menu” at the bottom of the page</li>
</ul>
<h4>Regarding image association</h4>
<ul>
<li>Tables you wish to associate with images must have a dedicated image source column (ex. <code>imgsrc</code>)
<ul>
<li>The image source column will contain the image FILENAME</li>
<li>The image directory will be defined during setup</li>
</ul>
</li>
<li>To use your own default image (used when no association is made),<br />
   simply add a “blank-profile-picture.jpg” to your image directory</li>
</ul>


Jot Data Manager

Jot allows non-technical WordPress administrators to modify MySQL

Peter Lawrenson

ryo0inoue

<p>Simple Table Manager enables editing table records and exporting them to CSV files through a minimal database interface from your dashboard.</p>
<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>
<p>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.</p>
<p>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.</p>


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.

Jot Data Manager vs Simple Table Manager