Using data from a an object/JSON

[mrleon83]

Hi all, I'm trying to use data from JSON (which I've put into an object as I need the key/value pair) to populate the chart.. so far I've been unsuccessful...

Any pointers at all? 

[Rit Man]

 loop through your JSON object and construct the string for each row by concatenating the variables together with the html and echo it so it will be treated as html. Based on the google charts table example this is how i did it in php:

 

(this is a pointer not a working example)

// (html code up until addRows...

data.addColumn('number', 'Column Name');
data.addRows([ <? // opening php - no longer in html

$posts = json_decode($output);
foreach($posts->data as $post) {
   // populate the variables - code omitted
   echo "['$message', {v: '$created_time', f: '$formatted_time'}, $shares, $reactions, $comments, $likes],";

// closing php - back to html ?> ]);

var table = new google.visualization.Table(document.getElementById('table_div'));