highcharts ajax后台数据,Highcharts实时数据，json ajax

livedata.php在页面打开时加载json。 live.php添加点到图。

从livedata.php我得到这样的输出：

[["Date.UTC(2016, 07-1, 28, 15, 08)",37],["Date.UTC(2016, 07-1, 28, 15, 08)",37],["Date.UTC(2016, 07-1, 28, 15, 08)",37],["Date.UTC(2016, 07-1, 28, 15, 08)",37],["Date.UTC(2016, 07-1, 28, 15, 08)",37],["Date.UTC(2016, 07-1, 28, 15, 08)",37]]

live.php输出 - 只有最后一排，看起来像

["Date.UTC('.2016, 07-1, 29, 15, 40.')", 44]

我有图表，活addPoint工作，但在x轴上没有日期。我做错了什么？

JS

var chart;

function requestData() {

$.ajax({

url: 'live.php',

success: function(point) {

var series = chart.series[0],

shift = series.data.length > 120; // shift if the series is

chart.series[0].addPoint(eval(point));

setTimeout(requestData, 10000);

},

cache: false

});

}

$(function() {

$.ajax({

url: 'livedata.php',

success: function(point) {

chart = new Highcharts.Chart({

chart: {

renderTo: 'container',

type: 'areaspline',

events: {

load: requestData

}

},

title: {

text: 'Revenue vs. Overhead',

},

subtitle: {

text: '',

},

xAxis: {

type: 'datetime'

},

yAxis: {

title: {

text: 'Amount'

},

plotLines: [{

value: 0,

width: 1,

color: '#808080'

}]

},

series: [{

name: 'Random data',

data: eval(point)

}]

});

},

});

});

live.php

global $dbConnection;

$stmt = $dbConnection->query('SELECT DATE_FORMAT(data,"%Y-%m-%d %H:%i") as dataa, humidity FROM sensorsdata order by id desc limit 1');

$row = $stmt->fetch(PDO::FETCH_ASSOC);

$date_raw = strftime('%Y, %m-1, %d, %H, %M', strtotime($row[dataa]));

$date_complete = "Date.UTC('.$date_raw.')";

$ar = array($date_complete, $row[humidity]);

echo json_encode($ar, JSON_NUMERIC_CHECK);

livedata.php

global $dbConnection;

$stmt = $dbConnection->query('SELECT DATE_FORMAT(data,"%Y-%m-%d %H:%i") as dataa, humidity FROM sensorsdata');

$result = $stmt->fetchAll();

foreach ($result as $row) {

$date_raw = strftime('%Y, %m-1, %d, %H, %M', strtotime($row[dataa]));

$date_complete = 'Date.UTC('.$date_raw.')';

$hum_for_chart[] = [$date_complete, $row[humidity]];

}

echo json_encode($hum_for_chart, JSON_NUMERIC_CHECK);