This doesn't work?
$.ajax({
url: "getData-roombars.php",
dataType: "json",
success: function (jsonData) {
var data = google.visualization.arrayToDataTable(jsonData);
// draw chart(s) with data
}
});
Note there is no "new" keyword in front of the arrayToDataTable call.
On Tuesday, February 25, 2014 3:01:39 PM UTC-5, [email protected] wrote:
>
> The forum will no longer display the old thread for some reason, which
> probably means I am getting close to figureing out the issue...
>
> using your php (which outputs exactly the same thing as mine):
>
> $myArray = array(
> array('Sensor', 'Temp', array('role' => 'style')),
> array('Baby', 71.15, 'green'),
> array('Main', 71.2616, 'green'),
> array('A', 75.425, 'green'),
> array('C', 69.575, 'blue'),
> array('D', 60.6866, 'blue')
> );
> echo json_encode($myArray);
>
>
>
> and then :
>
> var jsonData = $.ajax({
> url: "getData-roombars2.php",
> dataType:"json",
> }) ;
>
> var data = new google.visualization.arrayToDataTable( JSON.parse(jsonData)
> );
>
> it just crashes.
>
> var parsed=JSON.parse(jsonData); also crashes. So there is still a basic
> issue with getting the array passed. Im guessing the little extraneous
> assoc array 'role=>style' bit is forcing json_encode to output an object
> instead of an array... seems like I'll have to leave that cell in the array
> blank in php, then have the javascript code manually define just that one
> cell with the special formatting for arrayToDataTable.
>
> Also, both your and my php is outputting:
>
>
> [["Sensor","Temp",{"role":"style"}],["Baby",71.15,"green"],["Main",71.2616,"green"],["A",75.425,"green"],["C",69.575,"blue"],["D",60.6866,"blue"]]
>
> which doesnt work even plugged in directly. The double quotes around the
> color names have to be manually changed to single quotes and then it works
> as :
>
> var data = new
> google.visualization.arrayToDataTable([["Sensor","Temp",{"role":"style"}],["Baby",71.15,'green'],["Main",71.2616,'green'],["A",75.425,'green'],["C",69.575,'blue'],["D",60.6866,'blue']]);
>
> Not sure what special dance I need to do to make both JSON happy with
> double quotes and arrayToDataTable happy with single quotes. It just seems
> like Im reinventing the wheel just to pass an array.
>
>
>
>
>
>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.
