您好,欢迎访问一九零五行业门户网

社区(php&&mysql)三_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
;
    echo ;
        $nextid=next_subj($sid);
        $previd=prev_subj($sid);
        echo [夹肈跋];
        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 ;
            echo ;
                viewbar();
            echo
;
            echo ;
            //====ゅ彻==============
            echo ;
            echo ;
                echo ;
                    echo :;
                echo ;
                echo ;
                    echo $poster;
                echo ;
            echo
;
            echo ;
                echo ;
                    echo ㄓ:;
                echo ;
                echo ;
                    echo $pip;
                echo ;
            echo
;
            echo ;
                echo ;
                    echo ゅ彻ず甧:;
                echo ;
                echo ;
                            echo $pbody;
                            echo ;
                echo ;
            echo
;
            echo ;
            echo
;
            echo
;
//=======籔狟ねだㄉ===============
                echo ;     
                echo ;
                echo ;
                echo ;
                echo ;
                echo ;
                echo ;
                    echo ;
                       echo ;
                        echo 籔狟ねだㄉ硂絞ゅ彻:;
                       echo ;
                       echo ;
                        echo ;
echo ;
                       echo ;
                    echo
;
                echo ;     
                echo
;                 
            echo
;
            echo ;
                //=======mail list===============
            echo ;     
            echo ;
                echo ;
                echo ;
                echo ;
                echo ;
                echo ;
echo ;
               echo ;
                echo 璹境o肈尿癚阶:;
               echo ;
               echo ;
                if(strlen($c_email)) $addmail=$c_email;
                else $addmail=e-mail;
                echo ;
                echo ;
                echo                 $rs=mysql_db_query($sql['db'],$qsql);
                $nums=mysql_num_rows($rs);
                echo
硂肈ヘ玡璹兢h计:$nums;
               echo ;
            echo
;     
            echo ;
            echo
;
echo
;
            echo ;
                viewbar();
            echo
;
        echo
;
待续........
http://www.bkjia.com/phpjc/315609.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/315609.htmltecharticlefunction 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 i...
其它类似信息

推荐信息