Re: cakePHP Data into Google Charts

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 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" <pa...@webbedit.co.uk> wrote:

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 Offer

            [4] => Declined Offer

        )

    [16] => Array

        (

            [0] => 16

            [1] => 10

            [2] => 7

            [3] => 5

            [4] => 0

        )

    [17] => Array

        (

            [0] => 17

            [1] => 27

            [2] => 22

            [3] => 13

            [4] => 4

        )

    [18] => Array

        (

            [0] => 18

            [1] => 13

            [2] => 8

            [3] => 7

            [4] => 2

        )

    [19] => Array

        (

            [0] => 19

            [1] => 12

            [2] => 6

            [3] => 6

            [4] => 1

        )

    [20] => Array

        (

            [0] => 20

            [1] => 8

            [2] => 2

            [3] => 6

            [4] => 0

        )

    [21] => Array

        (

            [0] => 21

            [1] => 7

            [2] => 4

            [3] => 3

            [4] => 0

        )

)

I then ran this through the following

foreach($arrayFromModel AS $row) {

  $chartData[] = json_encode($row);

}

and ended up with:

Array

(

    [0] => ["Age","Clients","Not Offered","Accepted Offer","Declined Offer"]

    [1] => ["16",10,7,5,0]

    [2] => ["17",27,22,13,4]

    [3] => ["18",13,8,7,2]

    [4] => ["19",12,6,6,1]

    [5] => ["20",8,2,6,0]

    [6] => ["21",7,4,3,0]

)

With an array of this type you use the following google function to get your data table:

var data = google.visualization.arrayToDataTable([".join(',', $chartData)."]);

Hope this is of some help, phpMagpie

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
 
 
To unsubscribe from this group, send email to
cake-php+u...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.