The feature that seems interesting to me is the one on your premium plan. It is unfortunate that it is not possible to test this before I buy.
I want to display data from my mySQL database in realtime. I want it to be displayed both as a table and as a chart.
Is it possible to make wpdatatables fetch data from the mySQL database in realtime? And is this supported through the wordpress interface, or do i need to code it myself?
You can test the full features of wpDataTables on our sandbox site. You can even add your database as a Separate DB Connection and test it there. Just note that if you add your database there, it will be accessible to everyone logged into our sandbox site, so my advice would be to create a new database with some dummy data.
SQL query-based tables are live tables, but the changes are seen only when the page is refreshed. There's also an option to include an auto-refresh timer, so the table automatically refreshes itself after a certain period of time.
Creating tables from SQL queries requires some coding skills and at least basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare a SQL query that will return the data you need. If you do not know how to use MySQL, refer to the “Create a MySQL-query-based table by generating a query to MySQL database” section. It will explain how to create complete tables or MySQL queries without this basic knowledge.
Please be advised that preparing MySQL queries for you is not included in the plugin support, but it can be done as a paid customization service.
Thank you for getting back to me! I have followed your instructions and tried to make a separate DB Connection. However, I receive the following error:
wpDataTables could not connect to MySQL server. MySQL said: There was a problem with your SQL connection - Permission denied
I am sure the credentials are correct since I have copy-pasted them from a console application that uses the same credentials and works. I have attached a screenshot. How do I proceed from here?
Dear TMS.
The feature that seems interesting to me is the one on your premium plan. It is unfortunate that it is not possible to test this before I buy.
I want to display data from my mySQL database in realtime. I want it to be displayed both as a table and as a chart.
Is it possible to make wpdatatables fetch data from the mySQL database in realtime? And is this supported through the wordpress interface, or do i need to code it myself?
Hope to hear from you :-)
Kind regards, Kim.
Hello Kim
Thank you for your interest in our plugin.
You can test the full features of wpDataTables on our sandbox site. You can even add your database as a Separate DB Connection and test it there. Just note that if you add your database there, it will be accessible to everyone logged into our sandbox site, so my advice would be to create a new database with some dummy data.
SQL query-based tables are live tables, but the changes are seen only when the page is refreshed. There's also an option to include an auto-refresh timer, so the table automatically refreshes itself after a certain period of time.
Creating tables from SQL queries requires some coding skills and at least basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare a SQL query that will return the data you need. If you do not know how to use MySQL, refer to the “Create a MySQL-query-based table by generating a query to MySQL database” section. It will explain how to create complete tables or MySQL queries without this basic knowledge.
Please be advised that preparing MySQL queries for you is not included in the plugin support, but it can be done as a paid customization service.
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
Dear Aleksandar.
Thank you for getting back to me!
I have followed your instructions and tried to make a separate DB Connection. However, I receive the following error:
wpDataTables could not connect to MySQL server. MySQL said: There was a problem with your SQL connection - Permission denied
I am sure the credentials are correct since I have copy-pasted them from a console application that uses the same credentials and works. I have attached a screenshot. How do I proceed from here?
Kind regards, Kim
Hi again Kim
Does the server, on which this database resides, allow external connections?
Can you provide me the credentials for this separate connection, so I can try from my installation?
This is a public ticket, so please make sure to enable the PRIVATE response.
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