Home forums Using CanvasJS How can I use PHP MySQL Dynamic data Reply To: How can I use PHP MySQL Dynamic data

#9355

Hi This is my code, I am using Ajax for Displaying Chart

Below is index.php (I am trying to display chart in this page)

$(document).ready(function() {
		var fromDate = document.getElementById('fromDate').value;
		var toDate =  document.getElementById('toDate').value;
		
		$("#rangeButton").click(function(){
			var clickBtnValue = $(this).val();
			//alert(clickBtnValue);
			//alert(fromDate + ' '+toDate);
			var ajaxurl = 'dbconnect.php',
			data =  {'action': clickBtnValue, 'from': fromDate, 'to' : toDate,  dataType: 'json'};
			
			$.post(ajaxurl, data,  function (response) {
				alert(response);			
				var chart = new CanvasJS.Chart("chartContainer", {
					animationEnabled: true,
                    data: [
                        {
							type: "spline",
                            dataPoints: response
                        }
                    ]
                });

                chart.render();
		}); 
	});

Below is dbconnect.php (Fetching Data from DB)

$data_points = array();
	while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
	{	
		$point = array('label' => $row['date'] , 'y' => $row['value']);
		array_push($data_points, $point); 
		
	} 
	echo json_encode($data_points, JSON_NUMERIC_CHECK);

The response which I received is

[{"label":"2015-09-13","y":"10"},{"label":"2015-09-14","y":"20"},{"label":"2015-09-10","y":"70"},{"label":"2015-09-11","y":"80"}]

Everything was correct, but chart was not displayed. When I give static values, it is working! How to solve this issue?