欢迎来到福编程网,本站提供各种互联网专业知识!

聊天室php&mysql(二)

发布时间:2006-10-09 作者: 来源:转载
//第二页面name="frame2.php"userlist
//第二页面 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"].")

";

}

?>

(人)

相关推荐