Help with chart options

22 views
Skip to first unread message

Tuesday Duffer

unread,
Sep 24, 2018, 12:23:03 PM9/24/18
to Google Visualization API
Hello,

I'm using Forms Manager Gold on my Joomla server and I've edited their code for Google Charts. Below is the code I have working for a simple chart.

I'd like some help, please and thank you, on how I would add the Google Chart Options to this code.

$database=JFactory::getDBO();
$database->setQuery('select count(*) as `cnt`, `warehouse` as `title` from Inspection_Findings group by `warehouse`');
$a = $database->loadObjectList();


$url .= '&chl=';
foreach ($a as $value) $url .= urlencode($value->title).'|';
$url = substr($url, 0, strlen($url)-1);

$url .='&chd=t:';
foreach ($a as $value) $url .= $value->cnt.',';
$url = substr($url, 0, strlen($url)-1);

echo '<img src ="'.$url.'" />';

Thanks for any help you can give me.






Reply all
Reply to author
Forward
0 new messages