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; } // U@絞 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>[祇矸sゅ彻]</a>"; echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$nextid&rid=$nextid>[U@絞]</a>"; echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$previd&rid=$previd>[W@絞]</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 >"; //=======籔n狟ねだㄉ=============== 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 "籔n狟ねだㄉ硂絞ゅ彻:"; echo "</TD>"; echo "<TD>"; echo "<INPUT TYPE='TEXT' NAME='frmail' size=25 value='nね篍-mail'>"; echo "<INPUT TYPE='Submit'value='癳X'>"; echo "</TD>"; echo "</TR>"; echo "</FORM>"; echo "</TABLE>"; echo "</td></tr>"; echo "<TR><TD >"; //=======[Jmail 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鹰D肈韩崮虬Q阶:"; echo "</TD>"; echo "<TD>"; if(strlen($c_email)) $addmail=$c_email; else $addmail="A篍-mail"; echo "<INPUT TYPE='TEXT' NAME='email' size=25 value='$addmail'>"; echo "<INPUT TYPE='Submit' name='way1' value='[J璹?>"; 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>硂鹰D肈ヘ玡璹兢H计:$nums"; echo "</TD>"; echo "</TR>"; echo "</FORM>"; echo "</TABLE>"; echo "</td></tr>"; echo "<TR><TD >"; viewbar(); echo "</td></tr>"; echo "</TABLE>"; 待续........
查看更多关于社区(php&&mysql)三-PHP实例的详细内容...