I'm trying to graph some data from my database on a Highchart, but I can't seem to get the data to show.
I have the following PHP (snippet) that gets the data from the database and json_encodes it:
<?php
$result = mysqli_query($cxn,"SELECT * FROM counter");
while($row = mysqli_fetch_array($result)) {
$value = $row['value'];
$timestamp = strtotime($row['datetime']);
$data[] = "[$value, $timestamp]";
}
json_encode($data);
?>
The json_encode prints the following (I'm using datetime):
["[500, 1384122794]","[600, 1384153203]"]
I then have the following to graph the data:
<html>
<body>
<div id="container" style="height: 500px; min-width: 500px"></div>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>
<script src="http://code.highcharts.com/stock/highstock.js"></script>
<script>
$(function() {
$.getJSON('http://www.website.com/graph.php', function(data) { // I put website.com on purpose
// Create the chart
$('#container').highcharts('StockChart', {
rangeSelector : {
selected : 1
},
title : {
text : 'Title'
},
series : [{
name : 'AAPL',
data : data,
tooltip: {
valueDecimals: 2
}
}]
});
});
});
</script>
</body>
</html>
The problem is that the graph doesn't actually show the points, it's just a blank graph.
What am I doing wrong?
