聊天室php&mysql(四)

2016-01-29 14:32 2 1 收藏

聊天室php&mysql(四),聊天室php&mysql(四)

【 tulaoshi.com - PHP 】

  第四个页面 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
<titlecharmain</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());
  &nb

来源:https://www.tulaoshi.com/n/20160129/1493599.html

延伸阅读
标签: PHP
  第三个页面 name="frame3.php" <? include "../signup/mysql.php"; //echo $userid; //echo $private; if($p)$p=1; else $p=0; if(($action="ok")and($p)){ $sql="select userid,id from chat_user_list where userid='$userid'"; $result=mysql_query($sql); $roww=mysql_fe...
标签: PHP
  echo "<br";     echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center bgcolor='#6CA6CD'";       echo "<tr<td";       echo "<TABLE width=100% cellPadding=1 cellS...
标签: PHP
  大家好!好久没有看到大家了,上次写了用PHP的通过文件操作的聊天室,当然是漏洞百出的,而且每一次刷新屏幕都很糟糕的!我想了好久,是不是能有一种方法不要刷新,就能取得发言的信息了?多用一个框架就能实现这个效果了,即多用一个框架我们称为getmsg,我们让getmeg去取得信息而且保证每一次取得的信息是最新的,就是上次取得的发言...
标签: PHP
  function cook_cooloff(){     global $PHP_SELF,$aid,$pgno;     setcookie("OPEN_LIST",0,time()+ 31536000);     Header("Location:$PHP_SELF?aid=$aid&pgno=$pgno");     exit; } //=============================...
标签: PHP
  function post2() {     global $sid,$aid,$PHP_SELF;     global $banner,$body,$poster,$email,$type,$CHAR_GB;                 if(strlen($banner)==0 || strlen($body)==0 || strlen($poster)==0 || strlen($e...

经验教程

834

收藏

13
微博分享 QQ分享 QQ空间 手机页面 收藏网站 回到头部