<?php
$wxQuery = "SELECT * FROM wx_note ORDER BY id DESC LIMIT 25";//把wx_msg更改掉
$wxResult =$mysql->query($wxQuery);
while ($wxRow=mysql_fetch_row($wxResult)) {
$lastID or $lastID = $wxRow[0];//0代表数据库中的id,这个要和你自己数据库相对应
$content = $wxRow[4];//4也是一样的
echo "",$content,"\n";
}
$lastID = (int)$lastID;
?>
<script src="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.8.3.min.js"></script>
<script>
var lastID = <?php echo $lastID; ?>;
function getMessages() {
$.ajax({
url: "message.php?lastID=" + lastID + "&v=" + (new Date()/1),
dataType: "json",
error: function(){
alert("Error loading JSON document");
},
success: function(data){//如果调用php成功
$.each(data,function(i,n){
message = "" + n + "";
$(message).prependTo("#msgBox").hide().slideDown("slow");
lastID = i;
});
}
});
window.setTimeout(getMessages, 5000);
}
getMessages();
</script>