<form id="hz9zz"></form>
  • <form id="hz9zz"></form>

      <nobr id="hz9zz"></nobr>

      <form id="hz9zz"></form>

    1. 明輝手游網中心:是一個免費提供流行視頻軟件教程、在線學習分享的學習平臺!

      社區(php&&mysql)5

      [摘要]function post2() global sid,aid,PHP_SELF; global banner,body,poster,email,type,CHAR_GB; if(strlen(banner)==0 strlen(body)==...
      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 "&nbsp;&nbsp;<font color=#836FFF>$banner</font>";
                          echo "</a>";
                           
                      echo "</td>";
                      echo "<td>";
                          echo $poster;
                      echo "</td>";
                      echo "<td class='num'>";
                          echo "&nbsp;";
                      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");     
      ?>

      以上前五篇為一個頁面 


      日韩精品一区二区三区高清