电脑技术学习

社区(php&&mysql)三

dn001
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 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>[祇穝ゅ彻]</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 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 >"
;;;;;
//=======籔狟ねだㄉ===============
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 "籔狟ねだㄉ硂絞ゅ彻:"
;;;;;;;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 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肈尿癚阶:"
;;;;;;;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>"
;
;
待续........
;

标签: