如何用高图表改变实时图表上的xasis时间？

Question

如何根据数据库中的时间设置轴和工具提示上的时间？

这是我的dataPLLive.php

<?php

header("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);  
?>

这是输出印古尔，如果有人能解决这个问题，非常感谢，谢谢

Answer 1

你可能想试试：

xAxis: {
    type: 'datetime',
    labels: {
        format: '{value:%H:%M:%S}'
    }
}

和

tooltip: {
    headerFormat: '<b>{series.name}</b><br/>',
    pointFormat: '{point.x:%Y-%m-%d %H:%M:%S}<br/>{point.y:.2f}'
}

示例

关于数据库时间和图表时间之间的差异，这可能与您DB中的时区设置有关。这些高图集选项可能会有所帮助：

time: {
    timezoneOffset: 5 * 60, // Positive value moves time back
    useUTC : false
}