Reply To: How can I use PHP MySQL Dynamic data

[connect.javed001]

Hello sir, I am storing sensor data in mysql database ,now I want to use canvasJS to show realtime data from mysql database on web page.
Jquery code for updating chart data

function fData(){
    var lastid= $('#lastId').val(); 
   $.ajax({
                        url: httppath+"pages/fetchData",
                        type: "post",
                        data:{pId:$('#pid').val(),'lastId':lastid},
                        dataType:"json",
                        success: function (res) {
                             if(res['Pt']!=='' || res['Pt']!=" "){
                               $('#lastId').val(res["Pt"]['id']);
                                 updateChart(res['Pt']);
                             }
                        },
                        error: function(jqXHR, textStatus, errorThrown) {
//                           console.log(textStatus, errorThrown);
                        }
                    });
}   
   var dps = []; // dataPoints
   var xVal;
   var yVal;	
   var chart = new CanvasJS.Chart("chartContainer",{
      	title :{
      		text: "Live Data"
      	},
      	axisX: {						
      		title: "Axis X Title"
      	},
      	axisY: {						
      		title: "Pulse Rate"
      	},
      	data: [{
      		type: "line",
      		dataPoints : dps
      	}]
      });

      chart.render();
      
      var updateChart = function (data) {
      	yVal = data['sensor_value'];
      	dps.push({x: xVal,y: yVal});
      	console.log(dps);
        xVal++;
        if (dps.length >  10 )
      	{
      		dps.shift();				
      	}
      	chart.render();		
	// update chart after specified time. 
      };