聊天室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}");



?>
























    $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."
".$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="".$usert5."";

     }

     else $user1=$usert5;

     if($row["object"]!=$userid){



     $user2="".$bojectt5.""; }

     else $user2=$bojectt5;

     $message2=$row["message"];

     $message3=htmlspecialchars($message2);



$message1="".$user1."&nbsp;对".$user2."&nbsp;".$row["action1"].": ".$message3."" ;



    if($row["status"]==1){

         if($row["object"]==$userid||$row["userid"]==$userid)

        echo "私聊".$time1." ".$message1."
";

         else continue;

         }

    else {  

        echo $time1." ".$message1."
";

      

         }

    }

     

?>