Title: WP-DB-Table-Editor Author: bobbysmith007 Published: March 26, 2014 Last modified: March 11, 2020 --- Search plugins ![](https://s.w.org/plugins/geopattern-icon/wp-db-table-editor.svg) # wp-db-table-editor By [bobbysmith007](https://profiles.wordpress.org/bobbysmith007/) * [Details](https://wordpress.org/plugins/wp-db-table-editor/#description) * [Reviews](https://wordpress.org/plugins/wp-db-table-editor/#reviews) * [Development](https://wordpress.org/plugins/wp-db-table-editor/#developers) [Support](https://wordpress.org/support/plugin/wp-db-table-editor/) ## Description This plugin has been closed as of May 31, 2024 and is not available for download. Reason: Security Issue. ## Reviews ![](https://secure.gravatar.com/avatar/96fe7beedf94e5d1413a690c2cf4ef6391e380c3fb59e290209936b860ac2d46? s=60&d=retro&r=g) ### 󠀁[Good plug-in, poor Documentation; Joins and grouped EAV-Tables not editable?](https://wordpress.org/support/topic/good-plug-in-poor-documentation-joins-and-grouped-eav-tables-not-editable/)󠁿 [phil](https://profiles.wordpress.org/philippezumofen/) April 19, 2020 Plug in is pretty good, but Documentation is poor. But once I gathered all the necessary informations from the ratings and Support Topics to get this plugin to work and understand the limitations of it, it works fine. One thing i’m still not sure about: Is it somehow possible to edit EAV based tables that have been grouped by a value? If yes, how? Or is another approach necessary or is it impossible? And if using joins it seems only possible to edit the ‘basic table’, or am I missing something? Would be nice if joined views would be fully editable, but of course I don’t understand the compelexity of the implementation of these functionalities. Clear statements about these things in the documentation would be helpful, also the example given could use more parameters, so every functionality (edit values, export, etc.) is possible. I just insert a working example here, maybe it helps someone in the future: if(function_exists(‘add_db_table_editor’)){ add_db_table_editor(array( ‘id’=>”custom_table_interface_1″,‘ title’=>’Mitglieder: Bezahlstatus, Handynummer und Telefonnummer ändern’, ‘table’ =>’wp_users_zusaetze’, ‘cap’ => ‘edit_pages’, ‘edit_cap’ => ‘edit_pages’, ‘id_column’ => “ID”, “export_id_field”=>”z.ID”, ‘noedit_columns’ => ‘user_email, display_name’,‘ sql’=>”SELECT z.ID, u.user_email, u.display_name, z.user_bezahlstatus, z.Handynummer, z.Telefonnummer FROM wp_users_zusaetze z INNER JOIN wp_usermeta m ON m.user_id = z.user_id INNER JOIN wp_users u ON u.ID = m.user_id WHERE m.meta_key = ‘wp_capabilities’ AND m.meta_value LIKE ‘%mitglied%'” )); } like I said, only the values of the table‘ wp_users_zusaetze’ are editable, joined tables can’t be edited, but maybe I am doing something wrong. ![](https://secure.gravatar.com/avatar/d64d8a80d0b5430acec0f735204abe7410ff47fc9a7d893a8eeb63317862ef25? s=60&d=retro&r=g) ### 󠀁[Willing to manage the github wiki](https://wordpress.org/support/topic/willing-to-manage-the-github-wiki/)󠁿 [heyscotg](https://profiles.wordpress.org/heyscotg/) October 24, 2018 1 reply Russ, I sent you an email: 007. For help actually. If you can assist, I will assume the task of creating and maintaining the wp-db-table-editor wiki, which I noticed is patiently awaiting a good document manager such as myself. 😉 Thanks either way. ![](https://secure.gravatar.com/avatar/97e2e89f0c1a880085e140a22389ef63f59ccdc1e23591a9a830d77206931d19? s=60&d=retro&r=g) ### 󠀁[Nice: Working excellent, MUST read the docs first!](https://wordpress.org/support/topic/nice-2564/)󠁿 [dingdang](https://profiles.wordpress.org/dingdang/) July 26, 2018 6 replies That’s an interesting plugin and it definitely deserves either 5 stars (if you are a programmer with high IQ) or 1 star (if you are not). LOL The author made a nice tool but it’s a nice only if you know what to do and have time to look trough his code if needed. One question – is there any way to add pagination, let say if I have a table with 20K records to prevent it loading as a whole in the admin panel? If not is there an easy way to accomplish this (being able to perform a search on the whole table if needed), thanks. EDIT (for those that don’t like to read docs):– to enable the plugin capabilities (to appear in the Admin menu) you must have the table defined already in the database and in functions.php (or elsewhere) to add at least a single line of code (example at the end); – to be able to add new lines, there should be a column “ID” or if it is different, to use the specific config rule; – the pagination is not needed at all – it’s super fast with large tables ( >20K lines). Example code to enable the plugin in theme’s functions.php: if(function_exists(' add_db_table_editor')){ add_db_table_editor('title=THE_TITLE_FOR_ADMIN_AREA&table =the_table_name'); } ![](https://secure.gravatar.com/avatar/69b952708dd7ad54270fb3db738dff76aa80cf2c5fed5a6f1dbf9f3cc64f9655? s=60&d=retro&r=g) ### 󠀁[Works great](https://wordpress.org/support/topic/works-great-3944/)󠁿 [ovann86](https://profiles.wordpress.org/ovann86/) April 25, 2017 Quick easy access to custom database tables from the wp-admin. ![](https://secure.gravatar.com/avatar/076c3f94c01ffed6c695ec3d7d9cb2f52f205e9c87ea61d05886a7a0bc202d19? s=60&d=retro&r=g) ### 󠀁[No interface and poor instructions (no FAQ)](https://wordpress.org/support/topic/no-interface-and-poor-instructions-no-faq/)󠁿 [chasingpavements](https://profiles.wordpress.org/chasingpavements/) March 23, 2017 2 replies Lost like 5-10 minutes to even search for the interface or where to find a menu item for this plugin. When heading to the description site, again nothing described where menu item should be found etc. Not thought through/documented well. ![](https://secure.gravatar.com/avatar/0a87a076497ccb5ee7bd4ec6c18e31abc92c57f51b63f31091c007bffb02be70? s=60&d=retro&r=g) ### 󠀁[Resize width/height Table defined in functions.php and its cells on admin panel](https://wordpress.org/support/topic/resize-widthheight-table-defined-in-functions-php-and-its-cells-on-admin-panel/)󠁿 [wpleao](https://profiles.wordpress.org/wpleao/) March 7, 2017 2 replies Hello! Fine? I want resize the table that we define in functions.php and its cells( width and height) by default, not manually. Like change the css plugin. It is possible? Because my table have long texts. I know is possible resize manually, i want the table and its cells (columns and rows) more bigger, enlarge the width and height for all cells of the table. Best Regards [ Read all 19 reviews ](https://wordpress.org/support/plugin/wp-db-table-editor/reviews/) ## Contributors & Developers “WP-DB-Table-Editor” is open source software. The following people have contributed to this plugin. Contributors * [ bobbysmith007 ](https://profiles.wordpress.org/bobbysmith007/) “WP-DB-Table-Editor” has been translated into 1 locale. Thank you to [the translators](https://translate.wordpress.org/projects/wp-plugins/wp-db-table-editor/contributors) for their contributions. [Translate “WP-DB-Table-Editor” into your language.](https://translate.wordpress.org/projects/wp-plugins/wp-db-table-editor) ### Interested in development? [Browse the code](https://plugins.trac.wordpress.org/browser/wp-db-table-editor/), check out the [SVN repository](https://plugins.svn.wordpress.org/wp-db-table-editor/), or subscribe to the [development log](https://plugins.trac.wordpress.org/log/wp-db-table-editor/) by [RSS](https://plugins.trac.wordpress.org/log/wp-db-table-editor/?limit=100&mode=stop_on_copy&format=rss). ## Meta * Version **1.8.4** * Last updated **6 years ago** * Active installations **N/A** * WordPress version ** 3.0.0 or higher ** * Tested up to **5.3.21** * Languages * [English (US)](https://wordpress.org/plugins/wp-db-table-editor/) and [Russian](https://ru.wordpress.org/plugins/wp-db-table-editor/). * [Translate into your language](https://translate.wordpress.org/projects/wp-plugins/wp-db-table-editor) * [Advanced View](https://wordpress.org/plugins/wp-db-table-editor/advanced/)