I'm looking for a solution for connecting to a remote MySQL database from a WordPress instance. The database is fully designed and built. There is no need to create tables from the plugin. I'd like the plugin to be able to query and present the queried data in the WordPress site which this plugin seems to be capable of. However, I'd also like to be able to develop a back end CRUD interface in the wp-admin dashboard over the remote database accessing the pre-existing tables. I can't seem to be able to determine whether or not this plugin is capable of doing that. Could someone confirm whether or not this capability exists? If not, is it possible for the client to develop custom user interfaces using the data connections and other objects defined in this plugin once it's purchased, installed and configured?
You would be able to query the data, but it would come up in a table view. wpDataTables is a CRUD interface, but everything is done through tables - that's just how it was designed to work.
So, in short - you will be able to run queries and present the results on your website in tabular view using table shortcodes. All changes made in these tables would also be visible in the database tables and vice-versa.
Thanks again for answering my questions! I do have one last question.
If I purchased this plugin and used it to connect to the remote database and utilize the display functionality, would it be possible to leverage the plugin's database connection if I wrote my own add/update/delete interface (i.e. a plugin)? In this scenario, the interface would be calling procedures and passing parameters to those procedures.
I believe so, because it would simply store all those procedures in separate database tables, so you could probably use simple queries to retrieve the data defined by those procedures.
I'm looking for a solution for connecting to a remote MySQL database from a WordPress instance. The database is fully designed and built. There is no need to create tables from the plugin. I'd like the plugin to be able to query and present the queried data in the WordPress site which this plugin seems to be capable of. However, I'd also like to be able to develop a back end CRUD interface in the wp-admin dashboard over the remote database accessing the pre-existing tables. I can't seem to be able to determine whether or not this plugin is capable of doing that. Could someone confirm whether or not this capability exists? If not, is it possible for the client to develop custom user interfaces using the data connections and other objects defined in this plugin once it's purchased, installed and configured?
Thank you.
Hello John
Thank you for your interest in our plugin.
You would be able to query the data, but it would come up in a table view. wpDataTables is a CRUD interface, but everything is done through tables - that's just how it was designed to work.
So, in short - you will be able to run queries and present the results on your website in tabular view using table shortcodes. All changes made in these tables would also be visible in the database tables and vice-versa.
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
Aleksander,
Thank you for this information. It will help in choosing a data access plug in.
I have two more questions:
1. Views exist in the database to help with data presentation. Will it be possible to access these views instead of the underlying tables?
2. Procedures exist to add/update/delete data. Will it be possible to call these procedures and pass parameters in order to add/update/delete data?
Thanks again.
Hi again John
1. You can display the data from those views with simple queries like
So, the table will show only what the view shows.
2. Unfortunately, using variables ( @ ), stored procedures and nested queries is not supported.
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
Aleksandar,
Thanks again for answering my questions! I do have one last question.
If I purchased this plugin and used it to connect to the remote database and utilize the display functionality, would it be possible to leverage the plugin's database connection if I wrote my own add/update/delete interface (i.e. a plugin)? In this scenario, the interface would be calling procedures and passing parameters to those procedures.
Regards,
John Simmons
Hello again John
I believe so, because it would simply store all those procedures in separate database tables, so you could probably use simple queries to retrieve the data defined by those procedures.
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
Aleksandar,
Thanks again for the information. I will be looking at how to implement this plugin soon.
Regards,
John
You're welcome John
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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