Hi all.
I'm trying to load data into a Google Chart Table but unfortunately, the
table is not being displayed. Any idea what I'm doing wrong? Thank you in
advance.
*ChartTable.html:*
*
*
<html>
<head>
<!--Load the AJAX API-->
<meta content="text/html;charset=utf-8" http-equiv="Content-Type" />
<meta content="utf-8" http-equiv="encoding" />
<script type="text/javascript"
src="https://www.google.com/jsapi";></script>
<script type="text/javascript"
src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js";></script>
<script type="text/javascript">
google.load('visualization', '1', {packages:['table']});
google.setOnLoadCallback(drawTable);
function drawTable() {
var jsonData = $.ajax({
url: "GetTableData1.php",
dataType:"json",
async: false
}).reponseText;
var data = new google.visualization.DataTable(jsonData);
var table = new
google.visualization.Table(document.getElementById('table_div'));
table.draw(data, {showRowNumber: true});
}
</script>
</head>
<body>
<div id="table_div"></div>
</body>
</html>
*GetTableData1.php:*
<?php
require("common.php");
$smt = $db->prepare('SELECT Concat(firstname ," " ,lastname) as Name,
count(buildercommunityid) as Count FROM Users INNER JOIN
FieldSuperAssignment ON Users.userid = FieldSuperAssignment.UserID Group by
Users.userid order by firstname');
$smt->execute();
$data = $smt->fetchAll();
$rows = array();
$table = array();
$table['cols'] = array(
array('id'=> 'name', 'label' => 'Name', 'type' => 'string'),
array('id' => 'count', 'label' => 'Count', 'type' => 'number')
);
foreach($data as $row) {
$temp = array();
$temp[] = array('v' => (string) $row['Name']);
$temp[] = array('v' => (int) $row['Count']);
$rows[] = array('c' => $temp);
}
$table['rows'] = $rows;
$jsonTable = json_encode($table);
echo $jsonTable;
?>
--
You received this message because you are subscribed to the Google Groups
"Google Chart 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-chart-api.
For more options, visit https://groups.google.com/groups/opt_out.
