Edit Any Table

Description

This plugin can be integrated as a dashboard widget or use its own admin page to allow you to connect to any MySQL database of your choice (as long as your hosting allows) and search, edit, add and delete records in an easy to use interface. Ideal if you have built a site referencing another database and you want to allow other editors/administators of the site to alter, update, delete, add and correct entries.

Screenshots

  • Search for or add a record

  • Edit or delete a record

  • Administration screen

FAQ

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.

Changelog

2.1.1

  • UPDATE POT file for language translation.

2.1.0

  • FIX HTML not rendered correctly when stored in database.
  • NEW Debug mode.

2.0.3

  • FIX Escapes () fixed on output. See FAQ.
  • UPDATE FAQ updated to show example on how to remove escapes when outputting data.

2.0.2

  • FIX Translation bug.

2.0.1

  • FIX Due to a change in the wpdb class in WordPress 3.9 Edit Any Table was unable to identify primary keys on some MySQL/PHP platforms – this has now been rectified.

2.0.0

  • Localization Added.
  • Settings now allow you to choose which tables display in the widget/admin screen.
  • Display as a Dashboard Widget or in a separate Admin Screen.
  • Set permissions for Editor i.e. choose to allow Create, Edit and/or Delete.
  • When a table has no primary key Edit and Delete are disabled.

1.3.1

  • Fixed compatibility setting

1.3.0

  • Now shows columns for empty tables and allows the user to add new records.
  • Returns all records from a table if no search criteria is entered.

1.2.3

  • Fuzzy search added. You can now select to search string fields by part word or phrase.

1.1.3

  • Bug introduced by WordPress 3.5 (prepare statement now always requires 2 parameters) FIXED

1.1.2

  • Instructions link added to widget

1.1.1

  • Plugin homepage address changed

1.1.0

  • Simplified layout
  • Settings link added to main plugin page
  • Option to set a friendly database name in dashboard widget

1.0.0

  • First release

Contributors & Developers

This is open source software. The following people have contributed to this plugin.

Contributors

Browse the code