I create a manual table with wpDataables. I would like to be able to access that table using a raw MySQL call. c where is the data stored. I do not see it when I go to phpmyadmin I do not see any table that looks like the table I create?
Manual tables are being stored in the database where your WordPress is installed in this format: "wp_wpdatatable_#". The prefix may change, though, depending on your database, so in your case it's something like "yourprefix_wpdatatable_#" and where # is the auto-increment ID of the table.
To pull the data from the database, this query would suffice:
SELECT * FROM wp_wpdatatable_1
And you can also use our query constructor, where you're able to see all the tables in the database and create them in wpDataTables.
I create a manual table with wpDataables. I would like to be able to access that table using a raw MySQL call. c where is the data stored. I do not see it when I go to phpmyadmin I do not see any table that looks like the table I create?
Hello Charles.
Thank you for your purchase.
Manual tables are being stored in the database where your WordPress is installed in this format: "wp_wpdatatable_#". The prefix may change, though, depending on your database, so in your case it's something like "yourprefix_wpdatatable_#" and where # is the auto-increment ID of the table.
To pull the data from the database, this query would suffice:
And you can also use our query constructor, where you're able to see all the tables in the database and create them in wpDataTables.
Best regards.
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