聊天室php&amp;mysql(四)

第四个页面 name="index.php"
 1<html>
 2<head>
 3<title>charmain</title>
 4<meta content="text/html; charset=utf-8" http-equiv="Content-Type"/>
 5<meta content="4; url=&lt;? echo $PHP_SELF; ?&gt;?userid=&lt;?echo $userid?&gt;" http-equiv="Refresh"/>
 6</head>
 7<body bgcolor="#99CCFF" text="#000000">
 8<?   
 9$max_row_length=30;   
10  
11$select="select row from user_message order by row DESC";   
12$result=mysql_query($select)or die(" false fgfg");   
13$rowlist=mysql_fetch_array($result)or die("false");   
14$max_row=$rowlist["row"];   
15  
16  
17if($max_row>$max_row_length){   
18  
19  
20$delete_row=$max_row-$max_row_length+1;   
21  
22// echo $max_row."<br/>".$delete_row;   
23$select="select row from user_message where row&lt;".$delete_row;   
24$result=mysql_query($select)or die(" false");   
25while($row=mysql_fetch_array($result))   
26{   
27$sql="delete from user_message where row &lt;".$delete_row;   
28  
29mysql_query($sql)or die ("del false1");   
30}   
31  
32  
33$left=$delete_row;   
34}   
35  
36else {$left=1;   
37  
38}   
39  
40for($i=$max_row; $i&gt;=$left ;$i--)   
41{   
42$sql="SELECT message,userid,object,status,color,action1,time1 FROM user_message where row='$i'";   
43$result=mysql_query($sql)or die(mysql_error());   
44$row=mysql_fetch_array($result);   
45$time1=$row["time1"];   
46  
47$usert1=$row["userid"];   
48$objectt1=$row["object"];   
49$sql="select id from chat_user_list where userid='$usert1'";   
50$result=mysql_query($sql)or die(mysql_error());   
51$rowt1=mysql_fetch_array($result);   
52$usert5=$rowt1["id"];   
53  
54$sql="select id from chat_user_list where userid='$objectt1'";   
55$result=mysql_query($sql)or die(mysql_error());   
56if($rowt2=mysql_fetch_array($result))   
57$bojectt5=$rowt2["id"];   
58else $bojectt5="大家";   
59  
60  
61  
62if($row["userid"]!=$userid){   
63  
64$user1="<a href='".$PHP_SELF."?userid=$userid' onclick="parent.bottom.user('&quot;.$usert5.&quot;')">".$usert5."</a>";   
65}   
66else $user1=$usert5;   
67if($row["object"]!=$userid){   
68  
69$user2="<a href='".$PHP_SELF."?userid=$userid' onclick="parent.bottom.user('&quot;.$bojectt5.&quot;')">".$bojectt5."</a>"; }   
70else $user2=$bojectt5;   
71$message2=$row["message"];   
72$message3=htmlspecialchars($message2);   
73  
74$message1="<font color=".$row[" color"]."="" size="3"><i>".$user1."</i> 对".$user2." <i>".$row["action1"].": </i>".$message3."</font>" ;   
75  
76if($row["status"]==1){   
77if($row["object"]==$userid||$row["userid"]==$userid)   
78echo "<font color="ff0000" size="2">私聊</font>".$time1." ".$message1."<br/>";   
79else continue;   
80}   
81else {   
82echo $time1." ".$message1."<br/>";   
83  
84}   
85}   
86  
87?&gt;   
88</body>
89</html>
聊天室php&amp;mysql(四)

聊天室php&mysql(四)
