Has anybody any examples of php code required for google charts? Or could point me in the right direction. I am after using the data from nuRunQuery("SELECT veh_status COUNT(*) FROM vehicle GROUP BY veh_status"); and showing this on a pie chart. I have looked at the example;
http://forums.nubuilder.cloud/viewtopic.php?f=13&t=8401 ,
This works great, but I want to use 'live' data for the pie chart. Thanks in Advance.
Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
Google Charts
Re: Google Charts
ricklinks.
If you used this table..
You could create PHP Code like this..
And you would get this (straight from the database)..
Steven
If you used this table..
Code: Select all
CREATE TABLE IF NOT EXISTS driver (
driver_id varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
dri_name varchar(200) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (driver_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO driver (driver_id, dri_name) VALUES
('53b5099282a8df6', 'Darryl'),
('53b5099282a8df61', 'Darryl'),
('53b509bf71d0f63', 'Kerry'),
('53b509bf71d0f6312', 'Kerry'),
('53b509bf71d0f632', 'Kerry'),
('53b509e72660832', 'Tom'),
('53b509e726608321', 'Tom'),
('53b509e726608322', 'Tom'),
('53b50a077f54e042', 'Clayton'),
('53b50bcf443c1c8', 'Butch'),
('53b50bcf443c1c81', 'Butch'),
('53b50bcf443c1c812', 'Butch'),
('53b50bcf443c1c82', 'Butch');
Code: Select all
ob_start();
print 'hi';
$chart_data = array();
$s = "
SELECT
count(*) as c,
dri_name as d
FROM driver
GROUP BY dri_name;
";
$t = nuRunQuery($s);
$chart_data[] = "['Driver', 'Trips']";
while($r = db_fetch_object($t)){
$chart_data[] = "['$r->d', $r->c]";
}
$js_string = implode(',', $chart_data);
$gg = "
<html>
<head>
<script type='text/javascript' src='https://www.google.com/jsapi'></script>
<script type='text/javascript'>
google.load('visualization', '1', {packages:['corechart']});
google.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([
$js_string
// -- replaced with js_string
// ['Task', 'Hours per Day'],
// ['Work', 11],
// ['Eat', 2],
// ['Commute', 2],
// ['Watch TV', 2],
// ['Sleep', 7]
]);
var options = {
title: 'My Daily Activities'
};
var chart = new google.visualization.PieChart(document.getElementById('piechart'));
chart.draw(data, options);
}
</script>
</head>
<body>
<div id='piechart' style='width: 400px; height: 400px;'></div>
</body>
</html>
";
ob_end_clean();
echo $gg;
Steven
You do not have the required permissions to view the files attached to this post.