聊天室phpamp;amp;amp;mysql(四)

第四个页面 name=index.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}); ? html head titlecharmain/title meta
content=text/html; charset=gb2312 meta content=4; url=? echo $PHP_SELF;
??userid=?echo $userid? /head body bgcolor=#99CCFF text=#000000
?$max_row_length=30;$select=select row from user_message order by row
DESC; $result=mysql_query($select)or die( false fgfg);
$rowlist=mysql_fetch_array($result)or die(false);
$max_row=$rowlist[row]; if($max_row$max_row_length){
$delete_row=$max_row-$max_row_length+1; // echo
$max_row.br.$delete_row; $select=select row from user_message where
row.$delete_row; $result=mysql_query($select)or die( false);
while($row=mysql_fetch_array($result)) { $sql=delete from
user_message where row .$delete_row; mysql_query($sql)or die (del
false1); } $left=$delete_row; } else {$left=1;} for($i=$max_row;
$i=$left ;$i–) { $sql=SELECT
message,userid,object,status,color,action1,time1 FROM user_message
where row=’$i’; $result=mysql_query($sql)or die(mysql_error());
$row=mysql_fetch_array($result); $time1=$row[time1];
$usert1=$row[userid]; $objectt1=$row[object]; $sql=select id from
chat_user_list where userid=’$usert1′; $result=mysql_query($sql)or
die(mysql_error()); $rowt1=mysql_fetch_array($result);
$usert5=$rowt1[澳门新浦京8455com,id]; $sql=select id from chat_user_list where
userid=’$objectt1′; $result=mysql_query($sql)or die(mysql_error());
if($rowt2=mysql_fetch_array($result)) $bojectt5=$rowt2[id]; else
$bojectt5=大家; if($row[userid]!=$userid){ $user1=a
href=’.$PHP_SELF.?userid=$userid’onClick=parent.bottom.user(‘.$usert5.’).$usert5./a;
} else $user1=$usert5; if($row[object]!=$userid){ $user2=a
href=’.$PHP_SELF.?userid=$userid’onClick=parent.bottom.user(‘.$bojectt5.’).$bojectt5./a;
} else $user2=$bojectt5; $message2=$row[message];
$message3=htmlspecialchars($message2); $message1=font size=3
color=.$row[color].i.$user1./i对.$user2.i.$row[action1].:
/i.$message3./font ; if($row[status]==1){
if($row[object]==$userid||$row[userid]==$userid) echo font size=2
color=ff0000 私聊/font.$time1. .$message1.br; else continue; } else
{echo $time1. .$message1.br; } } ? /body /html

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

You can leave a response, or trackback from your own site.

Leave a Reply

网站地图xml地图