聊天室php&mysql四 -pc6资讯

您的位置：首页 → 网页设计 → PHP实例 → 聊天室php&mysql四

聊天室php&mysql四 时间：2004/11/7 3:26:00来源：本站整理作者：蓝点我要评论(0): 第四个页面 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}");

?>

charmain

    $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." 对".$user2." ".$row["action1"].": ".$message3."" ;

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

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

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

         else continue;

         }

    else {

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



         }

    }



?>

文章评论

查看所有0条评论>>

热门文章 没有查询到任何记录。