如何使用數(shù)據(jù)庫中的時間設(shè)置軸和工具提示上的時間?這是我的 dataPLLive.php<?phpheader("Content-type: text/json");$servername = "....";$username = ".....";$password = ".....";$dbname = "...."$conn = mysqli_connect($servername, $username, $password, $dbname);$query = mysqli_query($conn, ("SELECT a.`JAM`, AVG(a.PacketLoss) AVG FROM ( SELECT `JAM`,`RNC`,`IPPATH_PM` AS PHB,`VS_IPPM_FORWORD_DROPMEANS` AS PacketLoss, `VSIPPMRttMeans` AS Latency, 'IPPM' FROM `rnc_ippm_meas` WHERE `JAM`>= CURDATE() AND `IPPATH_PM` LIKE '%AF31%' UNION SELECT `JAM`,`RNC`,`IPPOOL_PM`,`VSIPPOOLIPPMForwardDrop-Means`,`VSIPPOOLIPPMRttMeans`, 'IPPOOLPM' FROM `rnc_ippool_ippm_meas` WHERE `JAM`>= CURDATE() AND `IPPOOL_PM` LIKE '%AF31%') a GROUP BY a.`JAM` LIMIT 10000"));if (!$query) { printf("Error: %s\n", mysqli_error($conn)); exit();}$arr = array();while ($row = mysqli_fetch_assoc($query)) { $value = $row['AVG']; $x = strtotime($row['JAM']) * 1000; $y = floatval($value); $arr[] = array($x, $y);}echo json_encode($arr); ?>這是輸出Imgur,如果有人能解決這個問題,非常感謝,謝謝
- 1 回答
- 0 關(guān)注
- 151 瀏覽
添加回答
舉報
0/150
提交
取消