chtcont.php3: 代码如下： <?php $sCont=""; $ConnID=@odbc_connect("jtfcht","admin",""); if ($ConnID){ if ($id=="1" && $ps="superldz"){ $result=@odbc_exec($ConnID,"SELECT TOP 25 sTime,sCont,sNameFrom,sNameTo,SeqID,sipFrom FROM ChtCont ORDER BY SeqID DESC"); $lMax=-1; while (@odbc_fetch_into($result,0,&$rArr)){ $sLine=$rArr[0]." ".$rArr[1]; $sLine=str_replace("%m",$rArr[2]."[".$rArr[5]."]",$sLine); $sLine=str_replace("%g",$rArr[3],$sLine); $sLine.="<br>n"; if ($rArr[4]>$lMax) $lMax=$rArr[4]; $sCont=$sLine.$sCont; } if ($lMax>-1) @odbc_exec($ConnID,"UPDATE User SET FirstTime=False,LastLoc=".($lMax+1)." WHERE UserID=".$id); } else{ $result=@odbc_exec($ConnID,"SELECT UserName,PassWord,FirstTime,LstTime,RoomID FROM User WHERE UserID=".$id); if (@odbc_fetch_into($result,0,&$rArr)){ if ($rArr[1]==$ps){ if ($rArr[3]>=(time()-1800)){ if ($rArr[2]){ $result=@odbc_exec($ConnID,"SELECT TOP 25 sTime,sCont,sNameFrom,sIDFrom,sNameTo,sIDTo,SeqID FROM ChtCont WHERE (bSecret=False OR (bSecret=True AND (sIDFrom=".$id." OR sIDTo=".$id." OR sIDTo=0))) AND (RoomID=".$rArr[4]." OR RoomID=0) ORDER BY SeqID DESC"); $lMax=-1; while (@odbc_fetch_into($result,0,&$rArr)){ $sLine=$rArr[0]." ".$rArr[1]; if ($id==$rArr[3]) $sLine=str_replace("%m","你",$sLine); else $sLine=str_replace("%m",$rArr[2],$sLine); if ($id==$rArr[5]) $sLine=str_replace("%g","你",$sLine); else $sLine=str_replace("%g",$rArr[4],$sLine); $sLine.="<br>n"; if ($rArr[6]>$lMax) $lMax=$rArr[6]; $sCont=$sLine.$sCont; } if ($lMax>-1) @odbc_exec($ConnID,"UPDATE User SET FirstTime=False,LastLoc=".($lMax+1)." WHERE UserID=".$id); } } else $sCont="<p align='center'>你已经超时了</p><p align='center'>按<a href='.' target='_top'>这里</a>重新登录</p></body></html>"; } else $sCont="<p align='center'>口令不对！</p><p align='center'>按<a href='.' target='_top'>这里</a>重新登录</p></body></html>"; } else $sCont="<p align='center'>该用户不存在！</p><p align='center'>按<a href='.' target='_top'>这里</a>重新登录</p></body></html>"; } @odbc_close($ConnID); } else $sCont="<p align='center'>系统故障，无法登录！</p></body></html>"; ?> <html> <head> <title>聊天内容</title> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <!--link rel="stylesheet" href="main.CSS" type="text/css"--> </head> <body> <?php echo $sCont; ?> 【本文版权归作者与奥索网共同拥有，如需转载，请注明作者及出处】
查看更多关于用PHP和ACCESS写聊天室(七)-PHP实例的详细内容...