聊天室php&mysql(二)

6年以前  |  阅读数:979 次  |  编程语言:PHP 

//第二页面 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="<a href='".$PHP_SELF."?userid=".$userid."' onCLick=parent.bottom.user('".$row["id"]."')>".$row["id"];   
  echo $user."</a>(".$row["sex"].")<br>";   

}
?>

</font></i></p>   

(人)

Copyright© 2013-2020

All Rights Reserved 京ICP备2023019179号-8