//第二页面 name="frame2.php" <? include "signup/MySQL.php"; header("Expires: Sun, 28 Dec 1997 09:32:45 GMT"); header("Cache-Control: no-cache, must-revalidate"); header("PRagma: no-cache"); header("Content-Type: text/html; charset=${Charset}"); $current_time=time(); $delete_time=$current_time-40; $sql="delete from chat_user where last_time<".$delete_time; mysql_query($sql)or die(" false again"); $sql="update chat_user set last_time='$current_time' where userid='$userid'"; mysql_query($sql) or die("false"); $sql="select userid from chat_user"; $result=mysql_query($sql)or die("fallse"); $online=mysql_num_rows($result); ?> <html> <head> <title>user list</title> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <meta http-equiv="Refresh" content="30; url=<? echo $PHP_SELF; ?>?userid=<?echo $userid?>"> </head> <body bgcolor="#6699FF" text="#000000"> <div id="Layer1" style="position:absolute; left:9px; top:37px; width:94px; height:21px; z-index:1"> <div align="center"><font color="#FF9999"><b>在线人数</b></font></div> </div> <div id="Layer2" style="position:absolute; left:14px; top:96px; width:105px; height:276px; z-index:2"> <p><i><font size="2" color="#FF9999"> <? $sql="select userid,id,sex from chat_user"; $result=mysql_query($sql)or die("fallse"); while($row=mysql_fetch_array($result)){ $user=$row['userid']; $user="<a href='".$PHP_SELF."?userid=".$userid."' onCLick=parent.bottom.user('".$row["id"]."')>".$row["id"]; echo $user."</a>(".$row["sex"].")<br>"; } ?> </font></i></p> <p> </p> </div> <div id="Layer3" style="position:absolute; left:20px; top:62px; width:74px; height:11px; z-index:3"> <div align="center"><font size="2" color="#FF9999">(<?echo $online ;?>人)</font></div> </div> <p> </p> <p> </p> </body> </html>
查看更多关于聊天室php&mysql(二)-PHP实例的详细内容...