基于AJAX服务器推Comet实现

最新推荐文章于 2021-02-16 06:47:41 发布

TCM-caleng

最新推荐文章于 2021-02-16 06:47:41 发布

阅读量1k

点赞数

分类专栏： AJAX PHP 文章标签： comet ajax 服务器 function mysql parameters

本文链接：https://blog.csdn.net/caleng/article/details/5275672

版权

PHP 同时被 2 个专栏收录

36 篇文章 0 订阅

订阅专栏

AJAX

2 篇文章 0 订阅

订阅专栏

数据表words结构

CREATE TABLE `words` (

`id` int(6) unsigned NOT NULL auto_increment,

`content` varchar(120) NOT NULL default '',

`publish` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

ibox.html

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Comet demo</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <mce:script type="text/javascript" src="prototype.js" mce_src="prototype.js"></mce:script> <mce:script type="text/javascript"></mce:script> </head> <body> <p> <form action="" method="get" οnsubmit="comet.doRequest($('word').value);$('word').value='';return false;"> <input type="text" name="word" id="word" value="" /> <input type="submit" name="submit" value="Send" /> </form> </p> <div id="content"></div> </body> </html>

ibox.php

<?php $words = $_REQUEST['msg']; $conn = mysql_connect('localhost', 'root', '123456'); mysql_select_db('test', $conn); if (!empty($words)) { mysql_query('insert into words set content="'.$words.'"'); mysql_close($conn); exit(); } $arr = array(); $result = mysql_query("select content,publish from words order by id DESC limit 5"); while($row = mysql_fetch_assoc($result)) $arr[] = $row; mysql_free_result($result); $lastmodif = isset($_GET['timestamp']) ? $_GET['timestamp'] : 0; $currentmodif = $arr[0]['publish']; while ($currentmodif <= $lastmodif) { usleep(10000); $arr = array(); $result = mysql_query("select content,publish from words order by id DESC limit 1"); while($row = mysql_fetch_assoc($result)) $arr[] = $row; mysql_free_result($result); $currentmodif = $arr[0]['publish']; } $response = array(); $response['msg'] = $arr; $response['timestamp'] = $currentmodif; echo json_encode($response); flush(); ?>