javascript - 如何自动刷新包含php变量的div内容？

Question

我创建了一个名为 queries.php 的页面

<?php
require("connection.inc.php");
$query = "SELECT SUM(john), SUM(robert), COUNT(school) FROM election";
$result = mysql_db_query($db, $query, $connection) or
die("query error!");

$data = mysql_fetch_array($result);
$john = number_format($data[0], 0,',','.');     
$robert = number_format($data[1], 0,',','.');
$school = $data[2];
$total = $john + $robert;
$remaining_school = 524 - $school;
$percentage_john = round(($john*100/$total),2);
$percentage_robert = round(($robert*100/$total),2);
?>

然后我在 display.php 中显示数据数据显示良好，没有错误，我尝试了一些技巧来使用 jquery 自动刷新容器但失败了。这是我的 display.php 页面:

<?php
include("queries.php");
?>

<div id="totaljohn"> // <--- the div id taken from css layout
<h9>John: <?php echo $john; ?> <br> (<?php echo $percentage_john; ?> %)</h9>
</div>

<div id="totalrobert">
<h9>Robert: <?php echo $robert; ?><br> (<?php echo $percentage_robert; ?> %)</h9>
</div>

<div id="totalboth">
<h4>Total : <?php echo $total; ?> Suara</h4>
</div>

<div id="totalschool">
<h4>Total School attending : <?php echo $school; ?> Schools</h4>
</div>

<div id="remaining_schools">
<h4>Remaining Schools: <?php echo $remaining_school; ?> of 524 schools</h4>
</div> 

Answer 1

一切看起来都很好。你的数据库连接了吗？你的 SQL 正确吗？数据库中是否有为您的查询返回的记录？