How to make a Dynamic Line Graph in PHP - Mysql

Question

I want to make a dynamic line graph in php with mysql data. Please verify my Attached Image

How to get this type of graph ?

Possible duplicate of https://stackoverflow.com/questions/23443720/how-to-create-graph-from-php-mysql-data — Umashankar Das, Jun 05 '17 at 05:25

score 0 · Answer 1 · answered Jun 05 '17 at 05:31

Use this tutorial to plot graphs using Google visualisation.

https://developers.google.com/chart/interactive/docs/php_example

If you want to make it dynamic, you have to use AJAX to call a function in PHP which updates the graph every x seconds. To do that, update the function the following way

setInterval(function(){
$.ajax({url: "getData.php",
      dataType: "json",
      async: false


    }, dataType: "json"});
}, 1000);

This will repeat the call every 1 second. As the setIntervals second parameter is in Milliseconds.

Thanks for your reply . But I want a graph like my above image. — Nisanth, Jun 05 '17 at 06:02

How to make a Dynamic Line Graph in PHP - Mysql

1 Answers1