当前位置:Gxlcms > PHP教程 > 聊天室php&mysql(二)_php基础

聊天室php&mysql(二)_php基础

时间:2021-07-01 10:21:17 帮助过:3人阅读

//第二页面 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);
?>



user list








在线人数





$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="".$row["id"];
echo $user."(".$row["sex"].")
";
}
?>





(人)




人气教程排行