时时商务社区

标题: 社区(php&&mysql)三 [打印本页]

作者: qz234 时间: 2018-2-14 09:45

         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 "";
echo "";
      $nextid=next_subj($sid);
      $previd=prev_subj($sid);
      echo "[url=][夹肈跋][/url]";
      echo "[url=][莱セ絞][/url]";
      echo "[url=][祇穝ゅ彻][/url]";
      echo "[url=][絞][/url]";
      echo "[url=][絞][/url]";
      //echo "[url=][程絞][/url]";
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 *]/", '[url=]\1[/url]', $pbody );
$pbody =preg_replace( "/[www +([a-zA-Z0-9.:/_-]+)]([\x0-\xff]*?)[/www *]/", '[url=]\2[/url]', $pbody );
echo "";
echo "[$abanner]
";
echo "$banner";
echo "";
         echo "[TR][TD]";
            viewbar();
         echo "";
         echo "[TR][TD]";
         //====ゅ彻==============
         echo "";
         echo "[TR]";
            echo "[TD]";
                  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]";
                  echo "ゅ彻ず甧:";
            echo "[/TD]";
            echo "[TD]";
                        echo $pbody;
                        echo "";
            echo "[/TD]";
         echo "[/TR]";
         echo "[/TD][/TR]";
         echo "";
         echo "[TR][TD]";
            //=======籔狟ねだㄉ===============
            echo "

echo "";

echo "[TR]";

echo "[TD]";

echo "籔狟ねだㄉ硂絞ゅ彻:";

echo "[/TD]";

echo "[TD]";

echo "[I]";

echo "[/TD]";

echo "[/TR]";

echo "";

echo "

";
         echo "";
         echo "[TR][TD]";
            //=======mail List===============
         echo "

echo "";

echo "[TR]";

echo "[TD]";

echo "璹境o肈尿癚阶:";

echo "[/TD]";

echo "[TD]";

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

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

echo "[I]";

$qsql="SELECT id from bbs_sml where sid='$sid'";

$rs=mysql_db_query($sql['db'],$qsql);

$nums=mysql_num_rows($rs);

echo "

硂肈ヘ玡璹兢H计 $\"\"$ nums";

echo "[/TD]";

echo "[/TR]";

echo "";

echo "

";
         echo "";
         echo "[TR][TD]";
            viewbar();
         echo "";
      echo "";

待续........

欢迎光临时时商务社区 (http://bbs.4435.cn/)