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!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
Google Charts
-
admin
- Site Admin
- Posts: 2784
- Joined: Mon Jun 15, 2009 2:23 am
- nuBuilder Version: 4.5
- Been thanked: 3 times
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;
- Capture.PNG (10.06 KiB) Viewed 2634 times
-
ricklincs
- Posts: 78
- Joined: Mon Aug 01, 2011 5:39 pm