当前位置:Gxlcms > PHP教程 > 聊天室php&mysql(四)

聊天室php&mysql(四)

时间:2021-07-01 10:21:17 帮助过:2人阅读

第四个页面 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."
";
   
     }
  }
  
?>


人气教程排行