我正在尝试绘制一个来自我的sql数据库的highcharts,我正在用getdata.php?id=allTemp查询这个数据库。我对JSON了解不多,但到目前为止,我已经组装了下面的代码,图表甚至没有绘制出来。当我得到一个像weather.wesleyweisenberger.com/getdata.php?id=humidity,这样的变量时,$.getJSON函数可以工作,但是当我尝试获取getdata.php?id=allTemp时,它就不工作了,请帮助我…
while($data = $result->fetch_assoc()){
echo json_encode($data, JSON_FORCE_OBJECT);
}
并且返回的格式为
{"timestamp":"2018-05-30 00:33:05","temperature":"67.39","humidity":"66.57","pressure":"99.21"}{"timestamp":"2018-05-30 00:47:39","temperature":"65.52","humidity":"70.41","pressure":"99.2"}{...
我的index.php文件为:
<script>
$(function(){
$.getJSON('getdata.php?id=allTemp', function(json){
$('#container').highcharts({
series: [{
data: json
}],
title: {
text: 'Title'
}
})
})
})
</script>
<div id="container" style="width:100%; height:400px;"></div>
https://stackoverflow.com/questions/50730065
复制相似问题