社区(php&&mysql)五

functionpost2(){
    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"
          <scriptlanguage=javascript>
            alert("恶?ぃЧ俱");
            history.back();
          </script>
         ";
        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=newCCharset;
        $banner=$code->Gb_Big5($banner);
        $body=$code->Gb_Big5($body);
        $poster=$code->Gb_Big5($poster);             
    }

    if($type==1){
        $qsql="INSERTINTObbs_docs(aid,sid,banner,body,poster,email,pip,wdate)
           values("$aid","$sid","$banner","$body","$poster","$email","$rip","$now")";
    }else{
        $qsql="INSERTINTObbs_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="INSERTINTO  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"
          <scriptlanguage=javascript>
          document.location="$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$rid"
          </script>
         ";  

}
//======================================================================
functionsearch_docs($aid,$skey){
    $DROOT=getenv("DOCUMENT_ROOT");
    include("sql.php3");
    $db=mysql_connect($sql["host"],$sql["user"],$sql["passwd"]);  
    //$qsql="SELECT*frombbs_docswheresid="$id"and(bannerlike"$skey"orposterlike"$skey"orbodylike"$skey")orderbywdateDESC";
    if($aid)$qsql="SELECT*frombbs_docswhereaid="$aid"and(bannerlike"$skey"orposterlike"$skey"orbodylike"$skey")orderbywdateDESC";
    else$qsql="SELECT*frombbs_docswhere  (bannerlike"$skey"orposterlike"$skey"orbodylike"$skey")orderbywdateDESC";     
    $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"<trbgcolor="#F0F0F0">";
                echo"<td>";
                    echo"<ahref=$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$id>";
                    echo"  <fontcolor=#836FFF>$banner</font>";
                    echo"</a>";

                echo"</td>";
                echo"<td>";
                    echo$poster;
                echo"</td>";
                echo"<tdclass="num">";
                    echo" ";
                echo"</td>";
                echo"<tdclass="num">";
                    echo$views;
                echo"</td>";
                echo"<tdclass="num">";
                    echo$wdate;
                echo"</td>";

            echo"</tr>";
    }

}
//======================================================================
functionsearch(){
    global$PHP_SELF;
    global$key,$aid;
    if(!strlen($key)){
    echo"
          <scriptlanguage=javascript>
            history.back();
          </script>
         ";
    }
    echo"<TABLEwidth=85%border=0cellPadding=0cellSpacing=1align=centerclass="tablefont">";
    echo"<FORM  name=mtab  ENCTYPE=multipart/form-dataMETHOD=POSTACTION=$PHP_SELF?proc=search>";

      echo"<tr><td>";

              echo"<inputtype="hidden"name=aidvalue="$aid">";     
              echo"??ゅ彻:";
              echo"<INPUTTYPE="TEXT"NAME="key"value="$key"size=25class="tablefont">";
              echo"<INPUTTYPE="Submit"value="?高"class="tablefont">";

      echo"</td></tr>";
      echo"</FORM>";  
    echo"</table>";  

     
    $skey="%$key%";
    $DROOT=getenv("DOCUMENT_ROOT");
    include("sql.php3");
    $db=mysql_connect($sql["host"],$sql["user"],$sql["passwd"]);  
    if($aid)$qsql="SELECT*frombbs_subjwhereaid="$aid"and(bannerlike"$skey"orposterlike"$skey"orbodylike"$skey")orderbywdateDESC";
    else$qsql="SELECT*frombbs_subjwhere  (bannerlike"$skey"orposterlike"$skey"orbodylike"$skey")orderbywdateDESC";     
    //echo$qsql;
    $rs=mysql_db_query($sql["db"],$qsql);

    echo"<TABLEwidth=85%border=0cellPadding=0cellSpacing=1align=centerbgcolor="#6CA6CD">";
      echo"<tr><td>";
      echo"<TABLEwidth=100%cellPadding=1cellSpacing=1bgcolor=whiteclass="tablefont">";
        echo"<trbgcolor=#F1E1FF>";
            echo"<th>夹?</th>";
            echo"<th>???</th>";
            echo"<thwidth=30>?莱</th>";
            echo"<thwidth=30>??</th>";
            echo"<thwidth=70>ら戳</th>";
        echo"</tr>";
        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"<trbgcolor="#F0F8FF">";
                echo"<td>";
                    echo"<ahref=$PHP_SELF?proc=view&aid=$paid&sid=$id&rid=$id>";
                        echo$banner;
                    echo"</a>";
                echo"</td>";
                echo"<td>";
                    echo$poster;
                echo"</td>";
                echo"<tdclass="num">";
                    echo$docs;
                echo"</td>";
                echo"<tdclass="num">";
                    echo$views;
                echo"</td>";
                echo"<tdclass="num">";
                    echo$wdate;
                echo"</td>";
            echo"</tr>";

        }
        search_docs($aid,$skey);
      echo"</td></tr></table>";
    echo"</td></tr></table>";       

     

     
}
//======================================================================

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){
        casesearch:
             search();
             break;
        casemail_list:
             mail_list();
             break;
        casemail_friend:
             mail_friend();
             break;
        casepost2:
             post2();
             break;
        casecolloff:
             cook_cooloff();
             break;
        casecollon:
             cook_coolon();
             break;
        caseview;
             view();
             break;      
        default:
            area();
            break;
    }
//if($proc!="do_sel"&&$proc!="post2"&&$proc!="colloff"&&$proc!="collon")include("frame_bottom.php3");     
?>

以上前五篇为一个页面