当前位置:Gxlcms > PHP教程 > 社区(php&&mysql)五

社区(php&&mysql)五

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

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($email)==0) {
    echo "
     
     ";
    return;
  }
  
  //$banner=AddSlashes($banner);
  //$body=AddSlashes($body);
  $rip=getenv('REMOTE_ADDR');

  $DROOT=getenv('DOCUMENT_ROOT');
  include("sql.php3");
  $db=MySQL_connect($sql['host'], $sql['user'] , $sql['passwd']); 
  $now=date('Y')."-".date('m')."-".date('d')." ".date('H').":".date('i').":".date('s');
  
  if($CHAR_GB==1) {
    include("CCharset.php3");
    $code=new CCharset;
    $banner=$code->Gb_Big5($banner);
    $body=$code->Gb_Big5($body);
    $poster=$code->Gb_Big5($poster);      
  }
  
  if($type==1) {
    $qsql="INSERT INTO bbs_docs (aid,sid,banner,body,poster,email,pip,wdate)
      values('$aid','$sid','$banner','$body','$poster','$email','$rip','$now')";
  } else {
    $qsql="INSERT INTO bbs_subj (aid,banner,body,poster,email,pip,wdate)
      values('$aid','$banner','$body','$poster','$email','$rip','$now')";
  }  
  $rs=mysql_db_query($sql['db'],$qsql);
  $id=mysql_insert_id();
  
  
  
  if($type==0) { //笆mail_list
    $qsql="INSERT INTO bbs_sml (sid,email) values('$id','$email')";
    $rs=mysql_db_query($sql['db'],$qsql);
  
  }
  if($type==0) Send_the_doc_to_mail_list($aid,$id,$id);
  else      Send_the_doc_to_mail_list($aid,$sid,$id);  
  //incdocs($aid);
  if($type==0) { $sid=$rid=$id;}
  else     { $rid=$id;}
  echo "
     
     "; 
     
}
//======================================================================
function search_docs($aid,$skey) {
  $DROOT=getenv('DOCUMENT_ROOT');
  include("sql.php3");
  $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']); 
  //$qsql="SELECT * from bbs_docs where sid='$id' and (banner like '$skey' or poster like '$skey' or body like '$skey') order by wdate DESC";
  if($aid) $qsql="SELECT * from bbs_docs where aid='$aid' and (banner like '$skey' or poster like '$skey' or body like '$skey') order by wdate DESC";
  else $qsql="SELECT * from bbs_docs where (banner like '$skey' or poster like '$skey' or body like '$skey') order by wdate DESC";  
  $rs=mysql_db_query($sql['db'],$qsql);
    while($row=mysql_fetch_array($rs)) {
    $id=$row['id'];
      $banner=$row['banner'];
      $poster=$row['poster'];
      $views=$row['views'];
      $wdate=sdatetime($row['wdate']);
      $aid=$row['aid'];
      $sid=$row['sid'];
      
      echo "";
        echo "";
          echo "";
          echo " $banner";
          echo "";
          
        echo "";
        echo "";
          echo $poster;
        echo "";
        echo "";
          echo " ";
        echo "";
        echo "";
          echo $views;
        echo "";
        echo "";
          echo $wdate;
        echo "";
      
      echo "";
  }
  
}
//======================================================================
function search() {
  global $PHP_SELF;
  global $key,$aid;
  if(!strlen($key)) {
  echo "
     
     ";
  }
  echo "";
  echo ""; 
  echo "
"; 
  
  
  $skey="%$key%";
  $DROOT=getenv('DOCUMENT_ROOT');
  include("sql.php3");
  $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']); 
  if($aid) $qsql="SELECT * from bbs_subj where aid='$aid' and (banner like '$skey' or poster like '$skey' or body like '$skey') order by wdate DESC";
  else $qsql="SELECT * from bbs_subj where (banner like '$skey' or poster like '$skey' or body like '$skey') order by wdate DESC";  
  //echo $qsql;
  $rs=mysql_db_query($sql['db'],$qsql);
  
  echo "";
   echo "
";
   echo "";
    echo "";
      echo "";
      echo "";
      echo "";
      echo "";
      echo "";
    echo "";
    while($row=mysql_fetch_array($rs)) {
      $id=$row['id'];
      $paid=$row['aid'];
      $banner=$row['banner'];
      $poster=$row['poster'];
      $views=$row['views'];
      $wdate=sdatetime($row['wdate']);
      $docs=reAnum($id);
      echo "";
        echo "";
        echo "";
        echo "";
        echo "";
        echo "";
      echo "";
       
    }
    search_docs($aid,$skey);
   echo "
夹肈祇癬莱ら戳
";
          echo "";
            echo $banner;
          echo "";
        echo "
";
          echo $poster;
        echo "
";
          echo $docs;
        echo "
";
          echo $views;
        echo "
";
          echo $wdate;
        echo "
";
  echo"
";   
  
  
  
  
}
//======================================================================

if($proc=="post2") {
  setcookie("c_poster",$poster,time()+ 31536000);
  setcookie("c_email",$email,time()+ 31536000);
}

//if($proc!="do_sel" && $proc!="post2" && $proc!="colloff" && $proc!="collon") include("frame_top.php3");
switch($proc) {
    case search:
       search();
       break;
    case mail_list:
       mail_list();
       break;
    case mail_friend:
       mail_friend();
       break;
    case post2:
       post2();
       break;
    case colloff:
       cook_cooloff();
       break;
    case collon:
       cook_coolon();
       break;
    case view;
       view();
       break;   
    default:
      area();
      break;
  }
//if($proc!="do_sel" && $proc!="post2" && $proc!="colloff" && $proc!="collon") include("frame_bottom.php3");  
?>

以上前五篇为一个页面

人气教程排行