结果页面:
NAME |
---|
Register Time
$query = mysql_query("SELECT * FROM `register`");
$lastId = 0;
while ($row = mysql_fetch_array($query)) {
$lastId = $row['id'];
echo '
';echo '
'.$row['name'].'';echo '
'.$row['reg_time'].'';echo '
';}
echo '
';echo ''; // remember the last id
?>
的JavaScript在同一页面加载:
$(document).ready(function() {
var usersTable = $(".users");
setInterval(function() {
$.ajax({
url: 'get_users.php?id='+lastId,
dataType: 'json',
success: function(json) {
if (json.length > 0) {
$.each(json, function(key, user) {
usersTable.append('
'+user.name+''+user.reg_time+'');lastId = user.id;
});
}
}
});
}, 10000);
});
get_users.php:
$lastId = (int)$_GET['id'];
$query = mysql_query('SELECT * FROM `register` WHERE `id` >' . $lastId);
$result = array();
while ($row = mysql_fetch_array($query)) {
$result[] = $row;
}
echo json_encode($result);
重点是每隔X秒调用ajax,并附加在当前页面上最后一个用户之后注册的所有用户。
阅读: