Fail try, Google Charts

32 views

Skip to first unread message

Michel Muniagiseny

unread,

Aug 17, 2017, 8:00:32 AM8/17/17

to Google Visualization API

Good afternoon!

I use Google Chart to get the chart out, but I can not. I get the error in the console: Using //@ to indicate sourceMappingURL pragmas is deprecated. Use //# instead

And on the browser I see "Table has no columns".

SQL-query are successful, CSN-saved, but you can not get the schedule. I ask to help to solve this problem.

Thank you in advance.

I enclose the code

HTML:

<!DOCTYPE html>
<html>
<head>
<meta charset="utf8">
<title>Google Charts</title>
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script type="text/javascript" src="js/script.js"></script>
</head>
<body>
	<div id="chart_div"></div>
</body>
</html>

JS:

    google.charts.load('current', {'packages':['corechart']});
    google.charts.setOnLoadCallback(drawChart);


      function drawChart() {
		  var jsonData = $.ajax({
			  url: "data.php",
			  dataType: "json",
			  async: false
		  }).responseText;

		var data = new google.visualization.DataTable(jsonData);

        var options = {'title':'How Much Pizza I Ate Last Night',
                       'width':400,
                       'height':300};

        // Instantiate and draw our chart, passing in some options.
        var chart = new google.visualization.ColumnChart(document.getElementById('chart_div'));
        chart.draw(data, options);
      }

PHP:

<?php
	error_reporting(E_ALL);
	ini_set('display_errors', 1);
	
	$db = mysqli_connect('localhost','***','***', '***');
	mysqli_set_charset($db, 'utf8');

	function getDataString()
	{
		global $db;
		$query = "SELECT `interval_date`, `equivalent_balance` FROM `net_asset_value`";
		$res = mysqli_query($db, $query);
		$data = '{"cols": [';
		$data .= '{"label":"Interval","pattern":"","type":"date"},';
		$data .= '{"label":"Balance","pattern":"","type":"number"}';
		$data .= '],"rows": [';
		
		while($row = mysqli_fetch_assoc($res)){
			$data .= '{"c":[{"v":"' . $row['interval_date'] . '"},{"v":' . $row['equivalent_balance'] . '}]},';
		}
		
		$data = rtrim($data, ',');
		$data .= ']}';
		return $data;
	}
	echo getDataString();
?>

JSON:

{"cols": 
[{"label":"Интервал","pattern":"","type":"date"},{"label":"Баланс","pattern":"","type":"number"}],"rows":
 
[{"c":[{"v":"13.06.2017"},{"v":0}]},{"c":[{"v":"14.06.2017"},{"v":1500000}]},{"c":[{"v":"15.06.2017"},{"v":1499993}]},{"c":[{"v":"16.06.2017"},{"v":1500356}]},{"c":[{"v":"17.06.2017"},{"v":1500742}]},{"c":[{"v":"18.06.2017"},{"v":1501129}]},{"c":[{"v":"19.06.2017"},{"v":1501507}]},{"c":[{"v":"20.06.2017"},{"v":1501881}]},{"c":[{"v":"21.06.2017"},{"v":1502253}]},{"c":[{"v":"22.06.2017"},{"v":1502626}]},{"c":[{"v":"23.06.2017"},{"v":1502984}]},{"c":[{"v":"24.06.2017"},{"v":1503358}]},{"c":[{"v":"25.06.2017"},{"v":1503731}]},{"c":[{"v":"26.06.2017"},{"v":1504097}]},{"c":[{"v":"27.06.2017"},{"v":1504464}]},{"c":[{"v":"28.06.2017"},{"v":1504831}]},{"c":[{"v":"29.06.2017"},{"v":1505204}]},{"c":[{"v":"30.06.2017"},{"v":1505567}]},{"c":[{"v":"01.07.2017"},{"v":1505958}]},{"c":[{"v":"02.07.2017"},{"v":1506350}]},{"c":[{"v":"03.07.2017"},{"v":1506734}]},{"c":[{"v":"04.07.2017"},{"v":1507108}]},{"c":[{"v":"05.07.2017"},{"v":1507482}]},{"c":[{"v":"06.07.2017"},{"v":1507850}]},{"c":[{"v":"07.07.2017"},{"v":1508210}]},{"c":[{"v":"08.07.2017"},{"v":1508591}]},{"c":[{"v":"09.07.2017"},{"v":1508973}]},{"c":[{"v":"10.07.2017"},{"v":1509348}]},{"c":[{"v":"11.07.2017"},{"v":1509720}]},{"c":[{"v":"12.07.2017"},{"v":1510087}]},{"c":[{"v":"13.07.2017"},{"v":1510450}]},{"c":[{"v":"14.07.2017"},{"v":1509714}]},{"c":[{"v":"15.07.2017"},{"v":1510092}]},{"c":[{"v":"16.07.2017"},{"v":1510470}]},{"c":[{"v":"17.07.2017"},{"v":1510840}]},{"c":[{"v":"18.07.2017"},{"v":1511212}]},{"c":[{"v":"19.07.2017"},{"v":1511585}]},{"c":[{"v":"20.07.2017"},{"v":1511957}]},{"c":[{"v":"21.07.2017"},{"v":1512312}]},{"c":[{"v":"22.07.2017"},{"v":1512691}]},{"c":[{"v":"23.07.2017"},{"v":1513070}]},{"c":[{"v":"24.07.2017"},{"v":1513441}]},{"c":[{"v":"25.07.2017"},{"v":1513814}]},{"c":[{"v":"26.07.2017"},{"v":1514186}]},{"c":[{"v":"27.07.2017"},{"v":1514560}]},{"c":[{"v":"28.07.2017"},{"v":1514924}]},{"c":[{"v":"29.07.2017"},{"v":1515314}]},{"c":[{"v":"30.07.2017"},{"v":1515704}]},{"c":[{"v":"31.07.2017"},{"v":1516086}]}]}

Reply all

Reply to author

Forward

0 new messages