Hi asgallant, I've been trying to get this chart working for a couple of
days.
This is the result of my getdata2.php
{ "cols": [{"label": "name","type": "string"},{"label": "up","type":
"number"}],"rows" : [{"c":[{"v": "Google"},]},{"c":[{"v":
"1"},]},{"c":[{"v": "mercury"},]},{"c":[{"v": "2"},]}]}
When I run chart.html on goolge code playground, the output says "table has
no colums". See chart.html below. Any help would be greatly appreciated.
<html>
<head>
<!--Load the AJAX API-->
<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: "localhost/servermonitor/getdata2.php",
dataType:"json",
async: false
}).responseText;
// Create our data table out of JSON data loaded from server.
var data = new google.visualization.DataTable(jsonData);
// Instantiate and draw our chart, passing in some options.
var chart = new google.visualization.PieChart(document.getElementById(
'chart_div'));
chart.draw(data, {width: 400, height: 240});
}
</script>
</head>
<body>
<!--Div that will hold the pie chart-->
<div id="chart_div"></div>
</body>
</html>
On Tuesday, 26 July 2011 21:07:35 UTC+1, asgallant wrote:
>
> There's a simple example here:
> http://code.google.com/apis/chart/interactive/docs/php_example.html and
> the documentation for creating a data source is here:
> http://code.google.com/apis/chart/interactive/docs/dev/implementing_data_source.html
>
> I tend to use a middle road, where I pull my data from mySQL and/or Oracle
> and encode it in JSON. I use jQuery's AJAX to make requests to my source
> and pass the data to the chart drawing functions.
>
--
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/d/optout.
