采用行写方式的聊天程序（之四）_PHP

（接前面部分）










lt3.php
处理发言信息

session_start();
include("g_fun.php");
f_connectdb();

$query = "select max(lt_id) as rmaxid from lt_t_content";
$res = mysql_query($query, $dbh);
$row = mysql_fetch_array($res);
$maxid = $row["rmaxid"];
if (empty($maxid)) { $maxid = 0; }
$maxid = $maxid 1;
//增加聊天信息
$query = "insert into lt_t_content(lt_id,lt_speaker,lt_speaked,lt_secrecy,lt_content,lt_time,lt_face)";
$query .= " values(".$maxid.",'".$username."','".$towho."','1','".$oldsays."',now(),'1')";
$res = mysql_query($query, $dbh);

//修改最后聊天时间,判断用户是否存在，防止超时被删除
$query = "select count(*) as rcount from lt_t_online where lt_username = '".$username."'";
$res = mysql_query($query, $dbh);
$row = mysql_fetch_array($res);
$lcount = $row["rcount"];
if ($lcount == 0) {
$query = "insert into lt_t_online(lt_username,lt_lasttime) values(";
$query .= "'".$username."',now())";
$res = mysql_query($query, $dbh);
}
$query = "update lt_t_online set lt_lasttime = now(),lt_state = '0' where lt_username = '".$username."'";
$res = mysql_query($query, $dbh);


//显示聊天记录
$query = "select lt_id,lt_speaker,lt_face,lt_speaked,lt_time,lt_content from lt_t_content";
$query .= " where lt_id > ".$chat_hh. " order by lt_time desc";
$res = mysql_query($query, $dbh);
$chat_hh = $maxid;
$tempi = $maxid;
while ($row = mysql_fetch_array($res)) {
?>

$tempi=$row['lt_id'];
}
if ($tempi > $chat_hh) {
$chat_hh = $tempi;
}

?>

【本文版权归作者与奥索网共同拥有，如需转载，请注明作者及出处】