社区(php&&mysql)三_php基础
程序员文章站
2022-05-24 14:18:36
...
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 "";
";
}
//======================================================================
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","
",$body);
$pbody =preg_replace( "/[www *]([\x0-\xff]*?)[/www *]/", '\1', $pbody );
$pbody =preg_replace( "/[www +([a-zA-Z0-9.:/_-]+)]([\x0-\xff]*?)[/www *]/", '\2', $pbody );
echo "";
echo "[$abanner]
";
echo "$banner ";
echo "";
";
待续........
$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 "
"; $nextid=next_subj($sid); $previd=prev_subj($sid); echo "[夹肈跋]"; echo "[莱セ絞]"; echo "[祇穝ゅ彻]"; echo "[絞]"; echo "[絞]"; //echo "[程絞]"; echo " | ";
}
//======================================================================
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","
",$body);
$pbody =preg_replace( "/[www *]([\x0-\xff]*?)[/www *]/", '\1', $pbody );
$pbody =preg_replace( "/[www +([a-zA-Z0-9.:/_-]+)]([\x0-\xff]*?)[/www *]/", '\2', $pbody );
echo "
echo "[$abanner]
";
echo "$banner
echo "
"; viewbar(); echo " | ||||||
"; //====ゅ彻============== echo "
echo " | ||||||
"; //=======籔狟ねだㄉ=============== echo " echo " | ||||||
"; //=======mail List=============== echo " echo " | ||||||
"; viewbar(); echo " |
待续........