I want to manage tables (create tables, records, delete, etc.) in WP. When I create a table with WPDataTables, I found that in the phpMyAdmin I can see the table but nested in a generic wpdatatable. So I can't access the table from an script.
So, is it possible to create "independent" tables that appear at the first level in phpMyAdmin tree?
Only manual tables exist as independent tables in the database. The tables you were able to create using the Lite version of the plugin are tables that are linked to existing sources, and wpDataTables doesn't create them in the database, so they only contain the structure within wp_wpdatatables and wp_wpdatatables_columns tables.
Manual and imported tables exist as wp_wpdatatable_# where # is the ID of the manual table.
Hello,
I want to manage tables (create tables, records, delete, etc.) in WP. When I create a table with WPDataTables, I found that in the phpMyAdmin I can see the table but nested in a generic wpdatatable. So I can't access the table from an script.
So, is it possible to create "independent" tables that appear at the first level in phpMyAdmin tree?
Thanks!
Hello Ricard
Thank you for your interest in our plugin.
Only manual tables exist as independent tables in the database. The tables you were able to create using the Lite version of the plugin are tables that are linked to existing sources, and wpDataTables doesn't create them in the database, so they only contain the structure within wp_wpdatatables and wp_wpdatatables_columns tables.
Manual and imported tables exist as wp_wpdatatable_# where # is the ID of the manual table.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables