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

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

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

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

      社區(php&&mysql)3

      [摘要]function prev_subj(id) DROOT=getenv('DOCUMENT_ROOT'); include("sql.php3"); db=mysql_connect(sql['host'], sql[&#...
      function prev_subj($id){
          $DROOT=getenv('DOCUMENT_ROOT');
          include("sql.php3");
          $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);  
          $qstr="select id,aid from bbs_subj where id='$id'";
          $rs=mysql_db_query($sql['db'],$qstr);     
          $row=mysql_fetch_array($rs);
          $aid=$row['aid'];
           
          $qstr="select id from bbs_subj where aid='$aid' order by wdate DESC";
          $rs=mysql_db_query($sql['db'],$qstr);
          $pid=$id;     
          while($row=mysql_fetch_array($rs)){
              $tid=$row['id'];     
              if($id==$tid) break;
              $pid=$tid;
          }
           
          return $pid;
      }
      // 絞
      function next_subj($id){
          $DROOT=getenv('DOCUMENT_ROOT');
          include("sql.php3");
          $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);  
          $qstr="select id,aid from bbs_subj where id='$id'";
          $rs=mysql_db_query($sql['db'],$qstr);     
          $row=mysql_fetch_array($rs);
          $aid=$row['aid'];
           
          $qstr="select id from bbs_subj where aid='$aid' order by wdate DESC";
          $rs=mysql_db_query($sql['db'],$qstr);
          $pid=$id;     
          while($row=mysql_fetch_array($rs)){
              $pid=$row['id'];     
              if($id==$pid) break;
          }
          if($row=mysql_fetch_array($rs)) {
              $pid=$row['id'];
          }
          return $pid;
      }

      //======================================================================
      function viewbar() {
          global $pgno;
          global $PHP_SELF;
          global $aid,$sid;
          //global $OPEN_LIST;
          echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center align=center class='num'>";
          echo "<tr><td align=center>";
              $nextid=next_subj($sid);
              $previd=prev_subj($sid);
              echo "<a href=$PHP_SELF?aid=$aid&sid=$sid>[夾肈跋]</a>";
              echo "<a href=#re>[萊セ絞]</a>";
              echo "<a href=$PHP_SELF?proc=view&aid=$aid>[祇穝ゅ徹]</a>";
              echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$nextid&rid=$nextid>[絞]</a>";
              echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$previd&rid=$previd>[絞]</a>";
              //echo "<a href=$PHP_SELF?proc=view&pgno=$pgno&aid=$aid&sid=$previd&rid=$previd>[程絞]</a>";
               
          echo "</td>";
                   
          echo "</tr></table>";     
           
      }
      //======================================================================
      function view() {
          global $PHP_SELF,$aid,$sid,$rid;
          global $c_poster,$c_email;
          //echo "$PHP_SELF,$aid,$sid,$rid,$pgno";
          $type=0; //秨穝杠肈
        if($sid && $rid) {
            addhitviews($sid,$rid);
          $type=1; //萊
          $db_table="bbs_subj";
          if($sid!=$rid)    $db_table="bbs_docs";
          $DROOT=getenv('DOCUMENT_ROOT');
          include("sql.php3");
          $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);  
          $qstr="select banner from bbs_area where id='$aid'";
          $rs=mysql_db_query($sql['db'],$qstr);
          echo mysql_error();
          $row=mysql_fetch_array($rs);
          $abanner=$row['banner'];
           
          $qsql="SELECT * from $db_table where id='$rid' ";
          $rs=mysql_db_query($sql['db'],$qsql);
          $row=mysql_fetch_array($rs);
          $poster=$row['poster'];
          $pip=$row['pip'];
          $wdate=$row['wdate'];
          $rebanner=$banner=$row['banner'];
          $body=$row['body'];
          $body=htmlspecialchars($body);
          $pbody=ereg_replace("n","<br>",$body);
          $pbody =preg_replace( "/[www *]([\x0-\xff]*?)[/www *]/", '<a href="\1"  target="_blank">\1</a>', $pbody );  
          $pbody =preg_replace( "/[www +([a-zA-Z0-9.:/_-]+)]([\x0-\xff]*?)[/www *]/", '<a href="\1"  target="_blank">\2</a>', $pbody );  
           
          echo "<center>";
          echo "<font color=GREEN size=5><b>[$abanner]<br>";
          echo "$banner</b></font></center>";
          echo "<TABLE BORDER=0 width=95%  align=center cellPadding=1 cellSpacing=0 class='tablefont'>";
                  echo "<TR><TD >";
                      viewbar();
                  echo "</td></tr>";
                  echo "<TR><TD>";
                  //====ゅ徹==============
                  echo "<TABLE BORDER=0 width=100%  align=center cellPadding=1 cellSpacing=0 class='tablefont'>";
                  echo "<TR>";
                      echo "<TD  width='120' align='right'>";
                          echo ":";
                      echo "</TD>";
                      echo "<TD align='left'>";
                          echo $poster;
                      echo "</TD>";
                  echo "</TR>";
                  echo "<TR>";
                      echo "<TD width='120' align='right'>";
                          echo "ㄓ:";
                      echo "</TD>";
                      echo "<TD align='left'>";
                          echo $pip;
                      echo "</TD>";
                  echo "</TR>";
                  echo "<TR>";
                      echo "<TD width='120' align='right' valign='top'>";
                          echo "ゅ徹ず甧:";
                      echo "</TD>";
                      echo "<TD valign='top' class='bodycolor' align='left'>";
                                  echo $pbody;
                                  echo "<hr size=1>";
                      echo "</TD>";
                  echo "</TR>";
                  echo "</TD></TR>";
                  echo "</TABLE>";
                  echo "<TR><TD >";
                   
                      //=======籔狟ねだㄉ===============
                      echo "<TABLE BORDER=0 width=100%   align=center cellPadding=3 cellSpacing=0 class='menufont'>";     
                      echo "<FORM  name=mtab ENCTYPE=multipart/form-data METHOD=POST ACTION=$PHP_SELF?proc=mail_friend>";
                      echo "<input type='hidden' name=sid value='$sid'>";
                      echo "<input type='hidden' name=aid value='$aid'>";
                      echo "<input type='hidden' name=rid value='$rid'>";
                      echo "<input type='hidden' name=poster value='$c_poster'>";
                      echo "<input type='hidden' name=email value='$c_email'>";
                          echo "<TR>";
                             echo "<TD align='right' width=250>";
                              echo "籔狟ねだㄉ硂絞ゅ徹:";
                             echo "</TD>";
                             echo "<TD>";
                              echo "<INPUT TYPE='TEXT' NAME='frmail' size=25 value='ねE-mail'>";
                      
                              echo "<INPUT TYPE='Submit'value='癳'>";
                             echo "</TD>";
                          echo "</TR>";
                      echo "</FORM>";     
                      echo "</TABLE>";                 
                  echo "</td></tr>";
                  echo "<TR><TD >";
                      //=======mail List===============
                  echo "<TABLE BORDER=0 width=100%   align=center cellPadding=3 cellSpacing=0 class='menufont'>";     
                  echo "<FORM  name=mtab ENCTYPE=multipart/form-data METHOD=POST ACTION=$PHP_SELF?proc=mail_list>";
                      echo "<input type='hidden' name=sid value='$sid'>";
                      echo "<input type='hidden' name=aid value='$aid'>";
                      echo "<input type='hidden' name=rid value='$rid'>";
                      echo "<input type='hidden' name=poster value='$c_poster'>";
                      echo "<input type='hidden' name=email value='$c_email'>";

                  echo "<TR >";
                     echo "<TD align='right' width=250>";
                      echo "璹境o肈尿癚階:";
                     echo "</TD>";
                     echo "<TD>";
                      if(strlen($c_email)) $addmail=$c_email;
                      else $addmail="E-mail";
                      echo "<INPUT TYPE='TEXT' NAME='email' size=25 value='$addmail'>";
                      echo "<INPUT TYPE='Submit' name='way1' value='璹?>";
                      echo "<INPUT TYPE='Submit' name='way2' value='璹?>";
                      $qsql="SELECT id from bbs_sml where sid='$sid'";
                      $rs=mysql_db_query($sql['db'],$qsql);
                      $nums=mysql_num_rows($rs);
                      echo "<br>硂肈ヘ玡璹兢H計:$nums";
                     echo "</TD>";
                  echo "</TR>";     
                  echo "</FORM>";
                  echo "</TABLE>";     
               
                  echo "</td></tr>";
                  echo "<TR><TD >";
                      viewbar();
                  echo "</td></tr>";
              echo "</TABLE>";
               
               
      待續........
               


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