Hi mate. Just saw your reply and I've got it semi-working. Thanks for your
help! :)
On Friday, 24 January 2014 15:31:53 UTC, Stelios Voskos wrote:
>
> I have to visualize some url json data on a pie chart with google
> visualization. My code seems to be as it has to be for the purpose, but I
> am getting an 'Invalid row type for row 0' error in the console. Is there
> any problem with the format of the data? If there is anyone that could
> help, that would be much appreciated. Here is my code:
>
> PHP:
>
> <?php
> $json =
> file_get_contents('http://data.police.uk/api/crimes-street/all-crime?lat=52.629729&lng=-1.131592&date=2013-01');
>
> $json = str_replace("\xe2\x80\xa8", '\\u2028', $json);
> $json = str_replace("\xe2\x80\xa9", '\\u2029', $json);
> echo $json;?>
>
> JavaScript:
>
> <script type="text/javascript"
> src="https://www.google.com/jsapi";></script><script type="text/javascript"
> src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script><script
> type="text/javascript">
> // Load the Visualization API and the piechart package.
> google.load('visualization', '1', {'packages':['corechart']});
> // Set a callback to run when the Google Visualization API is loaded.
> google.setOnLoadCallback(drawChart);
> function drawChart() {
> var jsonData = $.ajax({
> url: "getData.php",
> dataType:"json",
> async: false
> }).responseText;
>
> //Create an array of the JSON data and then create our data table out of
> JSON data loaded from server.
> var array = JSON.parse(jsonData);
> var dataTableData = new google.visualization.arrayToDataTable(array);
> var table = google.visualization.DataTable(dataTableData);
>
> var chart = new
> google.visualization.PieChart(document.getElementById('chart_div'));
> chart.draw(data, {width: 400, height: 240});}
> </script></head>
> <body><div id="chart_div"></div></body>
>
> Thank you.
>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.
