社区（php&&mysql）五

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 "
          <script language=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=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 "
          <script language=javascript>
          document.location="$PHP_SELF？proc=view&aid=$aid&sid=$sid&rid=$rid"
          </script>
         ";

}
//======================================================================
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 "<tr bgcolor="#F0F0F0">";
                echo "<td>";
                    echo "<a href=$PHP_SELF？proc=view&aid=$aid&sid=$sid&rid=$id>";
                    echo "  <font color=#836FFF>$banner</font>";
                    echo "</a>";

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

            echo "</tr>";
    }

}
//======================================================================
function search（） {
    global $PHP_SELF;
    global $key,$aid;
    if（！strlen（$key）） {
    echo "
          <script language=javascript>
            history.back（）;
          </script>
         ";
    }
    echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center class="tablefont">";
    echo "<FORM  name=mtab  ENCTYPE=multipart/form-data METHOD=POST ACTION=$PHP_SELF？proc=search>";

      echo "<tr><td>";

              echo "<input type="hidden" name=aid value="$aid">";
              echo "穓碝ゅ彻:";
              echo "<INPUT TYPE="TEXT" NAME="key" value="$key" size=25 class="tablefont">";
              echo "<INPUT TYPE="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 * 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 "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center bgcolor="#6CA6CD">";
      echo "<tr><td>";
      echo "<TABLE width=100% cellPadding=1 cellSpacing=1 bgcolor=white class="tablefont">";
        echo "<tr bgcolor=#F1E1FF>";
            echo "<th >夹肈</th>";
            echo "<th>祇癬</th>";
            echo "<th width=30>莱</th>";
            echo "<th width=30></th>";
            echo "<th width=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 "<tr bgcolor="#F0F8FF">";
                echo "<td>";
                    echo "<a href=$PHP_SELF？proc=view&aid=$paid&sid=$id&rid=$id>";
                        echo $banner;
                    echo "</a>";
                echo "</td>";
                echo "<td>";
                    echo $poster;
                echo "</td>";
                echo "<td class="num">";
                    echo $docs;
                echo "</td>";
                echo "<td class="num">";
                    echo $views;
                echo "</td>";
                echo "<td class="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） {
        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"）;
？>

以上前五篇为一个页面