社区(php&&mysql)三
2015-01-24信息快讯网
$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@g
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>[^夹D跋]</a>";
echo "<a href=#re>[^莱セg]</a>";
echo "<a href=$PHP_SELF?proc=view&aid=$aid>[o矸sゅ彻]</a>";
echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$nextid&rid=$nextid>[U@g]</a>";
echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$previd&rid=$previd>[W@g]</a>";
//echo "<a href=$PHP_SELF?proc=view&pgno=$pgno&aid=$aid&sid=$previd&rid=$previd>[程瘠@g]</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; //}s杠D
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 "ゅ彻ずe:";
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 >";
//=======PnBねだㄉ===============
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 "PnBねだㄉogゅ彻:";
echo "</TD>";
echo "<TD>";
echo "<INPUT TYPE='TEXT' NAME='frmail' size=25 value='nねE-mail'>";
echo "<INPUT TYPE='Submit'value='eX'>";
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 "q境o鹰DD韩崮虬Q阶:";
echo "</TD>";
echo "<TD>";
if(strlen($c_email)) $addmail=$c_email;
else $addmail="AE-mail";
echo "<INPUT TYPE='TEXT' NAME='email' size=25 value='$addmail'>";
echo "<INPUT TYPE='Submit' name='way1' value='[Jq?>";
echo "<INPUT TYPE='Submit' name='way2' value='q?>";
$qsql="SELECT id from bbs_sml where sid='$sid'";
$rs=mysql_db_query($sql['db'],$qsql);
$nums=mysql_num_rows($rs);
echo "<br>o鹰DDヘeq兢H计:$nums";
echo "</TD>";
echo "</TR>";
echo "</FORM>";
echo "</TABLE>";
echo "</td></tr>";
echo "<TR><TD >";
viewbar();
echo "</td></tr>";
echo "</TABLE>";
待续........
php中文字符截取防乱码
php5中类的学习
php一些公用函数的集合
PHP之变量、常量学习笔记
php日历[测试通过]
PHP与MySQL开发中页面乱码的产生与解决
一家之言的经验之谈php＋mysql扎实个人基本功
php+mysql分页代码详解
Mysql和网页显示乱码解决方法集锦
mysql时区问题
社区(php&&mysql)四
利用php来自动调用不同服务器上的flash
社区(php&&mysql)二
社区(php&&mysql)一
如何在PHP中使用Oracle数据库(6)
如何在PHP中使用Oracle数据库(5)
BBS(php & mysql)完整版(八)
BBS(php & mysql)完整版(六)
PHP怎样调用MSSQL的存储过程
BBS(php & mysql)完整版(五)