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

      

      <nobr id="hz9zz"></nobr>
      <form id="hz9zz"></form>
      3.   
          
      明輝手游網中心：是一個免費提供流行視頻軟件教程、在線學習分享的學習平臺！
                   
        
                           
        
                        		  
        
                 
              
                
      社區(php&&mysql)二
                
                  發表時間：2024-01-20             來源：明輝站整理相關軟件相關文章人氣：          
              
      [摘要]function sdatetime(str)     str=ereg_replace("-","/",str);     str=substr(str,5,strlen(str)-8);     return str;  function reAnum(...
      function sdatetime($str){ 
          $str=ereg_replace("-","/",$str); 
          $str=substr($str,5,strlen($str)-8); 
          return $str; 
      } 

      function reAnum($sid){ //羆萊絞計 
          $DROOT=getenv('DOCUMENT_ROOT'); 
          include("sql.php3"); 
          $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);  
          $qsql="SELECT id from bbs_docs where sid='$sid'"; 
          $rs=mysql_db_query($sql['db'],$qsql); 
          return mysql_num_rows($rs); 
      } 

      function pagebar($pages) { 
          global $pgno; 
          //global $pages; 
          global $PHP_SELF; 
          global $aid; 
          global $OPEN_LIST; 
          echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center bgcolor='#6CA6CD' class='num'>"; 
          echo "<tr><td>"; 
          if($pgno!=0) { 
              $pu=$pgno-1; 
              echo "<a href=$PHP_SELF?aid=$aid&pgno=$pu>[]</a>";         
          }     
          if($pgno<$pages) { 
              $pd=$pgno+1; 
              echo "<a href=$PHP_SELF?aid=$aid&pgno=$pd>[]</a>";         
          }     
          for($i=0;$i<=$pages;$i++) { 
              if($pgno==$i) { 
                  echo "<b>"; 
                  echo "[".($i+1)."]"; 
                  echo "</b>";     
              } else { 
                  echo "<a href=$PHP_SELF?aid=$aid&pgno=$i>"; 
                  echo "[".($i+1)."]"; 
                  echo "</a>";     
              } 
          } 
          echo "</td>"; 
          echo "<TD align=right>"; 
              echo "<a href=$PHP_SELF?proc=view&aid=$aid>"; 
                      echo "[祇ゅ徹]"; 
                      echo "</a>"; 
          //echo "</TD>"; 
          //echo "<TD align=right>"; 
                  if($OPEN_LIST) { 
                      echo "<a href=$PHP_SELF?proc=colloff&aid=$aid&pgno=$pgno>"; 
                      echo "[ぃ甶秨杠肈]"; 
                      echo "</a>"; 
                  }else { 
                      echo "<a href=$PHP_SELF?proc=collon&aid=$aid&&pgno=$pgno>"; 
                      echo "[甶秨杠肈]"; 
                      echo "</a>"; 
                  } 
          echo "</TD>";         
          echo "</tr></table>";     
           
      } 
      //=============================================================================== 
      function openlist($sid) { 
          global $aid; 
          global $PHP_SELF; 
           
          $DROOT=getenv('DOCUMENT_ROOT'); 
          include("sql.php3"); 
          $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);  
          $qsql="SELECT * from bbs_docs where sid='$sid' order by wdate"; 
          $rs=mysql_db_query($sql['db'],$qsql); 
          //if(mysql_num_rows($rs)==0) return; 
          //echo  mysql_num_rows($rs); 
          while($row=mysql_fetch_array($rs)) { 
              $id=$row['id']; 
                  $banner=$row['banner']; 
                  $poster=$row['poster']; 
                  $views=$row['views']; 
                  $wdate=sdatetime($row['wdate']); 
                   
                  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 "banner is $banner"; 
                      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 area() { 
          global $PHP_SELF; 
          global $aid,$sid,$pgno; 
          global $OPEN_LIST; 
          $showitems=20; 
          $DROOT=getenv('DOCUMENT_ROOT'); 
          include("sql.php3"); 
          $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);  
          //============================================================ 
          if(!$aid) { 
                $qsql="SELECT id from bbs_area"; 
                $rs=mysql_db_query($sql['db'],$qsql); 
                $row=mysql_fetch_array($rs); 
                $aid=$row['id'];               
              } 
          if(!$sid) { 
              $qsql="SELECT id from bbs_subj where aid=$aid order by wdate DESC"; 
              $rs=mysql_db_query($sql['db'],$qsql); 
              $row=mysql_fetch_array($rs); 
              $sid=$row['id'];     
          }     
           
          if(!$pgno) {//礚﹚計 
              //$pgno=0;  
              $items=0; 
              $qsql="SELECT id from bbs_subj where aid=$aid order by wdate DESC"; 
              $rs=mysql_db_query($sql['db'],$qsql); 
              while($row=mysql_fetch_array($rs)){ 
                  $id=$row['id'];     
                  if($id==$sid) break; 
                  $items++; 
              } 
              $pgno=(INT)($items/$showitems);         
          } 
           
          //============================================================ 
          $qsql="SELECT * from bbs_area where id=$aid "; 
          $rs=mysql_db_query($sql['db'],$qsql); 
          $row=mysql_fetch_array($rs); 
          $banner=$row['banner']; 
          $body=$row['body']; 
          $master=$row['master']; 
          echo "<center><font color=GREEN size=5><b>$banner</b></font></center>"; 
           
          echo "<FORM  name=mtab  ENCTYPE=multipart/form-data METHOD=POST ACTION=$PHP_SELF?proc=search>"; 
          echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center class='tablefont'>"; 
            echo "<tr><td>"; 
                 
                    echo "<input type='hidden' name=aid value='$aid'>";     
                    echo "穓碝ゅ徹:"; 
                    echo "<INPUT TYPE='TEXT' NAME='key' size=25 class='tablefont'>"; 
                    echo "<INPUT TYPE='Submit'value='琩高' class='tablefont'>"; 
                 
            echo "</td></tr>"; 
          echo "</table>";  
          echo "</FORM>";  
           
          $qsql="SELECT * from bbs_subj where aid=$aid order by wdate DESC"; 
          $rs=mysql_db_query($sql['db'],$qsql); 
          $all=mysql_num_rows($rs);  //how rows 
          $pages=(INT)($all/$showitems); // how pages 
          $pgcount=$pgno*$showitems; 
          if($pgcount > $all) {  
              $pgno=$pages-1; // Page point over all pages 
              $pgcount=$pgno*$showitems; 
           } 
          mysql_data_seek($rs, $pgcount); 
          $cnt=0; 
          pagebar($pages); 
          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)) { 
                  if(++$cnt > $showitems) break; 
                  $id=$row['id']; 
                  $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=$aid&sid=$id&rid=$id>"; 
                              if($sid==$id) echo "<font color=red>〈$banner</font>"; 
                              else 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>"; 
                  if($OPEN_LIST) openlist($id); 
              } 
            echo "</td></tr></table>"; 
          echo"</td></tr></table>";       
           
          pagebar($pages); 
      } 
      待續........ 


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