Structuring php array to pass to google pie charts arrayToDataTable

Question

Could someone please tell me how to structure my php array so that i can plug it straight into the Google pie chart API? Here is my current code:

PHP:

// class containing sql

$browser_data = browser_data();

// array to populate titles
$data_array['titles'] = array('title', 'amount');



 //array to populate data
    foreach($browser_data as $k=>$val) {
        $data_array[$k] = array($k, $val['examples']);
    }

JS:

data_array = <?=json_encode($data_array)?>;
   var data = google.visualization.arrayToDataTable(data_array);

asgallant · Accepted Answer · 2014-01-14 15:30:26Z

1

You need to remove 'titles' and '$k' from the array keys, as json_encode will create an object from an associative array instead of an array. This is what you need:

// array to populate titles
$data_array[] = array('title', 'amount');

// array to populate data
foreach($browser_data as $k=>$val) {
    $data_array[] = array($k, $val['examples']);
}

If your data source outputs numbers as strings (some databases, including MySQL, do this), you need to add JSON_NUMERIC_CHECK to the json_encode call:

data_array = <?=json_encode($data_array, JSON_NUMERIC_CHECK)?>;

answered Jan 14, 2014 at 15:30

asgallant

26.4k6 gold badges75 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Structuring php array to pass to google pie charts arrayToDataTable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related