I am looking to buy wpDataTables and I was wondering if it would fit my needs.
I have a mySQL database that changes every 5 seconds, with live data from sensors. I need something that will constantly pull from mySQL database into a graph. Is this something that WpDataTables can accomplish? pulling live data from database consistently and plotting? Or will I need to write lots of PHP code?
Thank I am looking forward to hearing from you guys!
You need to create table based on your MySQL data with MySQL query and turn on Server-side processing - Documentation. When you turn it on you will see Auto-refresh interval which, If set to a value different from 0, will auto-refresh the table after each XX seconds interval.
Next you need to create a chart based on that table with chart wizard and in it turn on Follow table filtering feature. - Documentation
After you create table and a chart based on it you need to place both table and the chart on page/post where you need them and table will update it self after set amount of seconds which will update the chart as well
For testing purpose we have sandbox website where you can see and test all plugin functionalities
Hello,
I am looking to buy wpDataTables and I was wondering if it would fit my needs.
I have a mySQL database that changes every 5 seconds, with live data from sensors. I need something that will constantly pull from mySQL database into a graph. Is this something that WpDataTables can accomplish? pulling live data from database consistently and plotting? Or will I need to write lots of PHP code?
Thank I am looking forward to hearing from you guys!
Hi Sammy,
Thank you for your inquire.
You need to create table based on your MySQL data with MySQL query and turn on Server-side processing - Documentation. When you turn it on you will see Auto-refresh interval which, If set to a value different from 0, will auto-refresh the table after each XX seconds interval.
Next you need to create a chart based on that table with chart wizard and in it turn on Follow table filtering feature. - Documentation
After you create table and a chart based on it you need to place both table and the chart on page/post where you need them and table will update it self after set amount of seconds which will update the chart as well
For testing purpose we have sandbox website where you can see and test all plugin functionalities
sandbox.wpdatatables.com
username: demo
password: demo
Thank you I have purchased this product, thanks for your help :)