聊天室php&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> 
            
<title>charmain</title> 
            
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"> 
            
<meta http-equiv="Refresh" 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["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>&nbsp;对".$user2."&nbsp;<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>