手机
当前位置:查字典教程网 >编程开发 >php教程 >社区(php&&mysql)三
社区(php&&mysql)三
摘要:functionprev_subj($id){$DROOT=getenv('DOCUMENT_ROOT');include("sql.php...

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;

}

// 絞

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>";

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>[祇穝ゅ彻]</a>";

echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$nextid&rid=$nextid>[絞]</a>";

echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$previd&rid=$previd>[絞]</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>";

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 "<TDwidth='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' align='left'>";

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 "<FORMname=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 "籔狟ねだㄉ硂絞ゅ彻:";

echo "</TD>";

echo "<TD>";

echo "<INPUT TYPE='TEXT' NAME='frmail' 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 "<FORMname=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肈尿癚阶:";

echo "</TD>";

echo "<TD>";

if(strlen($c_email)) $addmail=$c_email;

else $addmail="E-mail";

echo "<INPUT TYPE='TEXT' NAME='email' size=25 value='$addmail'>";

echo "<INPUT TYPE='Submit' name='way1' value='璹?>";

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>硂肈ヘ玡璹兢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分别做为cgi和module来运行的配置

BBS(php & mysql)完整版(四)

社区(php&&mysql)一

BBS(php & mysql)完整版(二)

社区(php&&mysql)二

php函数重载的替代方法

BBS(php & mysql)完整版(一)

BBS(php & mysql)完整版(三)

聊天室php&mysql(六)

聊天室php&mysql(一)

精品推荐
分类导航