WordPress.org

Plugin Directory

Edit Any Table

A WordPress plugin/Dashboard Widget that allows you to connect to any database and edit the contents.

If I save a text field with an apostrophe (') a backslash (\) is inserted prior to it in the database

WordPress assumes, for backwards capability, that Magic Quotes is switched on. Magic Quotes is used in earlier versions of PHP to prevent SQL injection. If you are outputting the data from the database yourself into a post then use the function stripslashes_deep() i.e. $records = stripslashes_deep($wpdb->get_results($sql,'ARRAY_A'));. See the codex.

Help! I've upgraded to version 2 and I can't see anything

Version 2 is a significant update with a number of new settings. Check all the settings and ensure you have selected a display mode and the tables to display.

Can Edit any Table be translated into my language?

Yes! Instructions can be found via the settings page.

Why can't I see the widget in the dashboard?

Probably because you have not selected 'Editor' or 'Administrator' in the settings. Go to Settings->Edit Any Table and correct this.

There are no tables in the drop down list, why?

You have entered invalid database information. Check the settings.

Requires: 3.0.0 or higher
Compatible up to: 4.2.3
Last Updated: 2015-5-6
Active Installs: 1,000+

Ratings

4.6 out of 5 stars

Support

Got something to say? Need help?

Compatibility

+
=
Not enough data

0 people say it works.
0 people say it's broken.

50,2,1 100,1,1 100,1,1
100,1,1 100,1,1
100,1,1 100,1,1
100,1,1
100,1,1
100,1,1
100,1,1
100,1,1
100,1,1 100,1,1 100,2,2
100,1,1
100,1,1 100,1,1
100,1,1
100,1,1
100,1,1
50,2,1 100,1,1
100,1,1
100,1,1 100,1,1 100,1,1 100,1,1
100,1,1
67,3,2
100,1,1
100,1,1
100,1,1