社区(phpmysql)三
发布时间：2020-03-21 13:22:42 所属栏目：PHP教程 来源：互联网
导读：社区(phpmysql)三
|
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"; $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"; $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>"; echo "<tr><td align=center>"; $nextid=next_subj($sid); $previd=prev_subj($sid); echo "<a href=http://www.jb51.net/article/$PHP_SELF?aid=$aid&sid=$sid>[?夹肈跋]</a>"; echo "<a href=#re>[?莱セ絞]</a>"; echo "<a href=http://www.jb51.net/article/$PHP_SELF?proc=view&aid=$aid>[祇?穝ゅ彻]</a>"; echo "<a href=http://www.jb51.net/article/$PHP_SELF?proc=view&aid=$aid&sid=$nextid&rid=$nextid>[??絞]</a>"; echo "<a href=http://www.jb51.net/article/$PHP_SELF?proc=view&aid=$aid&sid=$previd&rid=$previd>[??絞]</a>"; //echo "<a href=http://www.jb51.net/article/$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"; $rs=mysql_db_query($sql['db'],$qstr); echo mysql_error(); $row=mysql_fetch_array($rs); $abanner=$row['banner']; $qsql="SELECT * from $db_table where "; $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=http://www.jb51.net/article/"1" target="_blank">1</a>', $pbody ); $pbody =preg_replace( "/[www +([a-zA-Z0-9.:/_-]+)]([x0-xff]*?)[/www *]/", '<a href=http://www.jb51.net/article/"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>"; echo "<TR><TD >"; viewbar(); echo "</td></tr>"; echo "<TR><TD>"; //====ゅ彻============== echo "<TABLE BORDER=0 width=100% align=center cellPadding=1 cellSpacing=0>"; echo "<TR>"; echo "<TD width='120'>"; echo "??:"; echo "</TD>"; echo "<TD>"; echo $poster; echo "</TD>"; echo "</TR>"; echo "<TR>"; echo "<TD>"; echo "ㄓ??:"; echo "</TD>"; echo "<TD>"; echo $pip; echo "</TD>"; echo "</TR>"; echo "<TR>"; echo "<TD valign='top'>"; echo "ゅ彻ず甧:"; echo "</TD>"; echo "<TD valign='top'>"; 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>"; 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 width=250>"; echo "籔?狟ねだㄉ硂絞ゅ彻:"; echo "</TD>"; echo "<TD>"; echo "<INPUT TYPE='TEXT' 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>"; 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 width=250>"; echo "璹境o??肈??尿癚阶:"; echo "</TD>"; echo "<TD>"; if(strlen($c_email)) $addmail=$c_email; else $addmail="??E-mail"; echo "<INPUT TYPE='TEXT' size=25 value='$addmail'>"; echo "<INPUT TYPE='Submit' value='??璹?>"; echo "<INPUT TYPE='Submit' 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>"; 待续........ （编辑：焦作站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
