Hi I am newbiee to google Graph.I am generating arrays from php
andpassing it to google graph using json_encode method of php but
getting an error ie Uncaught Error: Invalid type: int. format
+en,default, annotated timeline +en_US.I.js:53 my code is as follow
<?php
$yP1data = array();
$yP2data = array();
$yP3data = array();
$yP4data = array();
$xdata = array();
$Timedata = array();
$Result=mysql_query("Select P1,P2,P3,P4,RecordTime from
readings");
//$countt=mysql_num_rows($Result);
$count=0;
while($data= mysql_fetch_array($Result))
{
array_push($yP1data,$data["P1"]);
array_push($yP2data,$data["P2"]);
array_push($yP3data,$data["P3"]);
array_push($yP4data,$data["P4"]);
array_push($Timedata,$data["RecordTime"]);
//echo "<p>";
$time= (explode(" ",$Timedata[$count]));
array_push($xdata,$time[1]);
//print_r($xdata);
$count++;
}
?>
<script type="text/javascript">
var encoded_P1data = <?php echo json_encode($yP1data) ?>;
var encoded_P2data = <?php echo json_encode($yP2data) ?>;
var encoded_P3data = <?php echo json_encode($yP3data) ?>;
var encoded_P4data = <?php echo json_encode($yP4data) ?>;
var encoded_xdata = <?php echo json_encode($xdata) ?>;
</script>
<script type="text/javascript" src="jsapi.js"></script>
<script type="text/javascript">
google.load('visualization', '1', {'packages':['annotatedtimeline']});
google.setOnLoadCallback(drawChart);
var P1data = new Array; // This would be the first array passed from
PHP
var P2data = new Array; // This would be the second array passed from
PHP
var P3data= new Array; // This would be the third array passed from
PHP
var P4data = new Array; // This would be the second array passed from
PHP
var P5data= new Array;
P1data = encoded_P1data;
P2data = encoded_P2data;
P3data= encoded_P3data;
P4data = encoded_P4data;
RecordTime= encoded_xdata ;
function drawChart() { var data = new
google.visualization.DataTable();
data.addColumn('datetime', 'RecordTime');
data.addColumn('int', 'P1');
data.addColumn('int', 'P2');
data.addColumn('int', 'P3');
data.addColumn('int', 'P4');
/* create for loops to add as many columns as necessary */
var len = jsonarray.length;
data.addRows(len);
for(i=0; i<len; i++) {
data.setValue(i, 0, RecordTime[i]); /* x-axis */
data.setValue(i, 1, P1data[i]); /* Y-axis category #1*/
data.setValue(i, 2, P2data[i]); /* Y-axis category #2*/
data.setValue(i, 3, P3data[i]); /* Y-axis category #1*/
data.setValue(i, 4, P4data[i]); /* Y-axis category #2*/
}
/*********************************end of
loops***************************************/
var chart = new
google.visualization.columnchart(document.getElementById('chart_div'));
chart.allowRedraw = true;
chart.draw(data, {displayAnnotations: false });
}
</script>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
