Forum Replies Created by kthilagarajan

Viewing 1 post (of 1 total)
  • in 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?

Viewing 1 post (of 1 total)