Re: cakePHP Data into Google Charts

2013-08-09 Thread Sumit Rai
Hi Guys, Am building a dynamic dashboard using cakephp, mysql and google charts api. Any sample code or demo which can help me will be appreciated. Best, Sumit On Tuesday, May 29, 2012 9:21:46 AM UTC+5:30, Nikhil Agrawal wrote: > > Try making a google chart API helper which will make js code fo

Re: cakePHP Data into Google Charts

2012-05-29 Thread Nikhil Agrawal
Try making a google chart API helper which will make js code for chart on-fly using js helper of cake PHP. I have a one written by me but works only for pie charts with some restrictions . If you want e-mail me for it. Will be happy to help you. On Mar 30, 2012 8:28 PM, "phpMagpie" wrote: > I'v

Re: cakePHP Data into Google Charts

2012-05-19 Thread Paul Gardner
Sorry for delay in reply, > But chart doesn't graph at all...Is there something I'm doing wrong? Without seeing your array structure and javascript code I can't really say. Are you sure if you debug your final array it echoes as follows? > Array > ( > [0] => ["Age","Clients","Not Offered","

Re: cakePHP Data into Google Charts

2012-05-15 Thread Steven Scaffidi
Hi phpMagpie - I followed your directions and I have my array formatted correctly as you described above in array named $chartData. I tried doing this: var data = google.visualization.arrayToDataTable([".join(',', $chartData)."]); But chart doesn't graph at all...Is there something I'm doing

Re: cakePHP Data into Google Charts

2012-03-30 Thread phpMagpie
I've outputted some charts (combocharts - near identical to column chart) using the visualization api and got the model to output an array like: Array ( [labels] => Array ( [0] => Age [1] => Clients [2] => Not Offered [3] => Accepted Off

Re: cakePHP Data into Google Charts

2012-03-27 Thread elogic
For example, the first column would use something as follows to get the names out: $staffmembers = $this->User->find('all', array( 'fields' => array('User.id', 'User.first_name', 'User.last_name'), 'conditions' => array('User.group_id' => 3),

cakePHP Data into Google Charts

2012-03-27 Thread elogic
I need to build some reports for a cakePHP system I have been building and google charts seems to be the easiest way to get some charts happening. How do I go about getting the cakePHP data into the chart records? I have only just started by using the sample code on google charts info pages. e.