JSON output for highcharts

Question

So I have finally managed to get a chart generated, but the problem is that for some reason the data from JSON is not displayed - ie I get a blank chart.

In the chart options I simply have:

series : [{
    name: '2000',
    data: [],
}]

The AJAX call looks like this:

$.ajax({
    url : 'data.php',
    datatype : 'json',
    success : function (json) {
        options.series[0].data = json['data'];
        chart = new Highcharts.Chart(options);
    },
});
}

And the data.php output looks like this:

{"data":[-1.4,-1.4,-1.3,-1.3,-1.3,-1.3,-1.3,-1.2,-1.3,-1.2,-1.2,-1.2]}

Im becoming desperate as I tried everything and still get just a blank chart with no data.

are any errors showing up in your javascript console? What is your ajax call returning, is it resulting in 200 with the expected response from your php? — dm03514
– dm03514, Commented Oct 21, 2013 at 21:18
no there are no errors, I am just not sure wheather it is ok, if the final line of data.php is: echo json_encode($rows, JSON_NUMERIC_CHECK); and before that I have while($r = mysqli_fetch_array($x)){ $rows['data'][] = $r['Temp']; } Which loads the data, the actual "echo" produces: {"data":[-1.4,-1.4,-1.3,-1.3,-1.3,-1.3,-1.3,-1.2,-1.3,-1.2,-1.2,-1.2]} — Jachym
– Jachym, Commented Oct 21, 2013 at 21:20
why dont you just hardcode some of the data to series.data and see if you are getting a chart with some data — s_curry_s
– s_curry_s, Commented Oct 21, 2013 at 21:20
also try printing json, before you call options.series[0].data = json['data'] — s_curry_s
– s_curry_s, Commented Oct 21, 2013 at 21:22
I tried to delete the options.series..... line and instead I put some data into the data in the series and then I get a normal chart with the data points. — Jachym
– Jachym, Commented Oct 21, 2013 at 21:23

Billy · Accepted Answer · 2013-10-21 21:20:18Z

1

If you're using Internet Explorer, those extra commas will cause you problems.

series : [{
    name: '2000',
    data: []
}]

$.ajax({
    url : 'data.php',
    datatype : 'json',
    success : function (json) {
        options.series[0].data = json['data'];
        chart = new Highcharts.Chart(options);
    }
});
}

answered Oct 21, 2013 at 21:20

Billy

1656 bronze badges

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

Comments

SheetJS · Accepted Answer · 2013-11-04 07:24:21Z

0

Its likely that your json values are coming back as strings but highcharts is expecting numbers.

In your data.php try typing your variables before json_encoding them:

array_push($myArray, (float)$value);
return json_encode(myArray);

If your highcharts data looks like:

["-1.4","-1.4","-1.3","-1.3","-1.3","-1.3","-1.3","-1.2","-1.3","-1.2","-1.2","-1.2"]

It wont render, it needs to be straight number:

[-1.4,-1.4,-1.3,-1.3,-1.3,-1.3,-1.3,-1.2,-1.3,-1.2,-1.2,-1.2]

edited Nov 4, 2013 at 7:24

SheetJS

23k12 gold badges68 silver badges76 bronze badges

answered Oct 21, 2013 at 21:23

Chase

9,3625 gold badges55 silver badges80 bronze badges

Collectives™ on Stack Overflow

JSON output for highcharts

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related