社区(php&&mysql)二

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 "  <font color=#836FFF>$banner</font>";                     echo "</a>";                     //echo "banner is $banner";                 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 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); } 待续........