我想更新我的图表而不刷新页面。我将数据添加到数据库,图表将自动更新,而无需重新加载页面。每次我将数据添加到数据库时,我都不需要刷新页面以便我获得更新的图表。
$mysqli = new mysqli($host,$user,$pass,$db) or die($mysqli->error);
$time = '';
$s01 = '';
$s02 = '';
$s03 = '';
//query to get data from the table
$sql = "SELECT * FROM `temperature` ";
$result = mysqli_query($mysqli, $sql);
//loop through the returned data
while ($row = mysqli_fetch_array($result)) {
$time = $time . '"'. $row['time'].'",';
$sensor01 = $sensor01 . '"'. $row['s01'].'",';
$sensor02 = $sensor02 . '"'. $row['s2'] .'",';
$sensor03 = $sensor03 . '"'. $row['s03'] .'",';
}
$time = trim($time.",");
$s01 = trim($s01,",");
$s02 = trim($s02,",");
$s03 = trim($s03,",");
var ctx = document.getElementById("chart").getContext('2d');
var myChart = new Chart(ctx, {
type: 'line',
data:
{
labels: [<?php echo $time; ?>],
datasets:
[{
label: 'Sensor01',
data: [<?php echo $s01; ?>]
},
{
label: 'Sensor02',
data: [<?php echo $s02; ?>]
},
{
label: 'Sensor03',
data: [<?php echo $s03; ?>]
}]
},
options:
{
responsive: true,
scales:{
yAxes: [{beginAtZero: false, setinterval: 3000}],
xAxes: [{autoskip: true, maxTicketsLimit: 20}]
},
});
发布于 2019-05-21 15:01:59
目前,您的前端无法找到数据库已更新的方法。要实现这一目标,有很多方法:
https://stackoverflow.com/questions/-100006767
复制相似问题