提供了编程的基础技术教程

zl程序教程

您现在的位置是：首页 >  数据库

当前栏目

聊天室php&mysql(四)

mysqlampPHP 聊天室
2023-06-13 09:14:17 时间
第四个页面name="index.php"

<?
include"../signup/mysql.php";
header("Expires:Sun,28Dec199709:32:45GMT");
header("Cache-Control:no-cache,must-revalidate");
header("Pragma:no-cache");
header("Content-Type:text/html;charset=${Charset}");

?>

<html>
<head>
<title>charmain</title>
<metahttp-equiv="Content-Type"content="text/html;charset=gb2312">
<metahttp-equiv="Refresh"content="4;url=<?echo$PHP_SELF;?>?userid=<?echo$userid?>">


</head>

<bodybgcolor="#99CCFF"text="#000000">
<?    
    $max_row_length=30;   

    $select="selectrowfromuser_messageorderbyrowDESC";
        $result=mysql_query($select)ordie("falsefgfg");
        $rowlist=mysql_fetch_array($result)ordie("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="selectrowfromuser_messagewhererow<".$delete_row;
        $result=mysql_query($select)ordie("false");
        while($row=mysql_fetch_array($result))
            {
                  $sql="deletefromuser_messagewhererow<".$delete_row;

                  mysql_query($sql)ordie("delfalse1");
             }


            $left=$delete_row;
                 }

    else{$left=1;  

         }

   for($i=$max_row;$i>=$left;$i--)
    {
     $sql="SELECTmessage,userid,object,status,color,action1,time1FROMuser_messagewhererow="$i"";
     $result=mysql_query($sql)ordie(mysql_error());
     $row=mysql_fetch_array($result);
     $time1=$row["time1"];

     $usert1=$row["userid"];
     $objectt1=$row["object"];
     $sql="selectidfromchat_user_listwhereuserid="$usert1"";
     $result=mysql_query($sql)ordie(mysql_error());
     $rowt1=mysql_fetch_array($result);
     $usert5=$rowt1["id"];

     $sql="selectidfromchat_user_listwhereuserid="$objectt1"";
     $result=mysql_query($sql)ordie(mysql_error());
     if($rowt2=mysql_fetch_array($result))
     $bojectt5=$rowt2["id"];
     else$bojectt5="大家";



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

     $user1="<ahref="".$PHP_SELF."?userid=$userid"  onClick=parent.bottom.user("".$usert5."")>".$usert5."</a>";
     }
     else$user1=$usert5;
     if($row["object"]!=$userid){

     $user2="<ahref="".$PHP_SELF."?userid=$userid"  onClick=parent.bottom.user("".$bojectt5."")>".$bojectt5."</a>";}
     else$user2=$bojectt5;
     $message2=$row["message"];
     $message3=htmlspecialchars($message2);

$message1="<fontsize=3color=".$row["color"]."><i>".$user1."</i> 对".$user2." <i>".$row["action1"].":</i>".$message3."</font>";

    if($row["status"]==1){
         if($row["object"]==$userid||$row["userid"]==$userid)
        echo"<fontsize=2color=ff0000>私聊</font>".$time1."".$message1."<br>";
         elsecontinue;
         }
    else{  
        echo$time1."".$message1."<br>";

         }
    }

?>
</body>
</html>

相关文章