Rumah > php教程 > php手册 > 社区(php&&mysql)三

社区(php&&mysql)三

WBOY
Lepaskan: 2016-06-21 08:58:12
asal
2121 orang telah melayarinya
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 "";
             
    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 "";
            echo "";
            echo "";
            echo "";
            echo "";
        echo "
";
                viewbar();
            echo "
";
            //====ゅ彻==============
            echo "";
            echo "";
                echo "";
                echo "";
            echo "";
            echo "";
                echo "";
                echo "";
            echo "";
            echo "";
                echo "";
                echo "";
            echo "";
            echo "";
            echo "
";
                    echo ":";
                echo "
";
                    echo $poster;
                echo "
";
                    echo "ㄓ:";
                echo "
";
                    echo $pip;
                echo "
";
                    echo "ゅ彻ず甧:";
                echo "
";
                            echo $pbody;
                            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 "";
            echo "";     
            echo "";
            echo "";     
         
            echo "
";
                viewbar();
            echo "
";
         
         
待续........ 
         



Label berkaitan:
sumber:php.cn
Kenyataan Laman Web ini
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn
Cadangan popular
Tutorial Popular
Lagi>
Muat turun terkini
Lagi>
kesan web
Kod sumber laman web
Bahan laman web
Templat hujung hadapan