我在 am4charts 中顯示了我的數據。最初我是用 id 字段創建 x 軸,但現在我想要時間字段。但是當我使用時間字段時它不起作用,當我使用 id 字段時它工作正常。這是我用于顯示圖表的 java 腳本編碼。var chart2 = am4core.create("chartdiv1", am4charts.XYChart);var data=[];var open = 0;var close = 0;<?$sql=mysqli_query($conn, "select tyme as date, rx as rx, tx as tx from log_vps_bw"); while($rs=mysqli_fetch_assoc($sql)){ ?>open = <?echo $rs['rx'];?>;close = <?echo $rs['tx'];?>;date = <?echo $rs['date'];?>;data.push({ date: date, open: open, close: close });<? } ?>chart2.data = data;var dateAxis = chart2.xAxes.push(new am4charts.DateAxis());dateAxis.renderer.grid.template.location = 0;dateAxis.renderer.minGridDistance = 50;var valueAxis = chart2.yAxes.push(new am4charts.ValueAxis());valueAxis.tooltip.disabled = true;var series = chart2.series.push(new am4charts.LineSeries());series.dataFields.dateX = "date";series.dataFields.openValueY = "open";series.dataFields.valueY = "close";series.tooltipText = "rx: {openValueY.value} tx: {valueY.value}";series.sequencedInterpolation = true;series.fillOpacity = 0.3;series.strokeWidth = 3;series.defaultState.transitionDuration = 1000;series.tensionX = 0.8;var series2 = chart2.series.push(new am4charts.LineSeries());series2.dataFields.dateX = "date";series2.dataFields.valueY = "open";series2.sequencedInterpolation = true;series2.defaultState.transitionDuration = 1500;series.strokeWidth = 3;series2.stroke = chart2.colors.getIndex(6);series2.tensionX = 0.8;// Add vertical scrollbarchart2.scrollbarY = new am4core.Scrollbar();chart2.scrollbarY.marginLeft = 0;chart2.cursor = new am4charts.XYCursor();chart2.cursor.xAxis = dateAxis;chart2.scrollbarX = new am4core.Scrollbar();chart.cursor.behavior = "zoomX";然后我的時間格式就像 11:36:52。在查詢時間字段中是有時間值的
1 回答

慕姐4208626
TA貢獻1852條經驗 獲得超7個贊
首先來自數據庫的爆炸時間變量。假設我的變量和值是
$rs['date'] = "10:30:45";
$time = explode(":",$rs['dt']);
在我的編碼更改中
date = <?php $rs['date']; ?>;
進入
date = new Date(0,0,0,<?= $time[0]; ?>,<?= $time[1]; ?>,<?= $time[2]; ?>,);
然后在 var dateaxis 行之后設置標簽的間隔,例如
dateAxis.baseInterval = {
"timeUnit": "second",
"count": 1
};
這些更改使我的圖表成為基于時間的圖表。它對我來說很好,謝謝。
- 1 回答
- 0 關注
- 147 瀏覽
添加回答
舉報
0/150
提交
取消