javascript - sql数据库状态改变时自动刷新页面

Question

$counter = "SELECT countnumber FROM onairsystem WHERE id='1'";
$counterresult = $connection->query($counter);
$rows = $counterresult->fetch_array();  
$number = $rows['countnumber'];

如果 countnumber 从 1 变为 2，则自动刷新网页而不闪烁。我怎么做？

我查看了不同的解决方案https://aiocollective.com/blog/ajax-auto-refresh-volume-ii/和这个How can I refresh a page when a database is updated? 但这和我想要的不一样。第二页解决方案更相似，但这并没有解决刷新页面的要求，它只检查数据库编号是否发生变化。

标签： javascriptphpajaxrefresh

Answer 1

.php 文件

     $id=$_POST['id'];
     if (is_numeric($id))
     {
         $counter = "SELECT count(*) as countnumber FROM onairsystem WHERE id={$id}";
         $counterresult = $connection->query($counter);
         $rows = $counterresult->fetch_array();
         echo $number = $rows['countnumber'];
     }

.html 文件

<input type="number" id="number" name="number">
<button onclick="getDate()">Get Data From Query</button>
<br>
<label class="data"></label>

<script>
function getDate()
{
    var number  = $('#number').val();
    $.ajax({
        type: "POST",
        url: 'ajax.php?id='+number,
        success: function(data)
        {
            $('.data').val(data);
        }
    });
}
</script>