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>[W@禲</a>"; } if($pgno<$pages) { $pd=$pgno+1; echo "<a href=$PHP_SELF?aid=$aid&pgno=$pd>[U@禲</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>祇癬H</th>"; echo "<th width=30>^莱</th>"; echo "<th width=30>H</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); } 待续........
查看更多关于社区(php&&mysql)二-PHP实例的详细内容...