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

社区(php&&mysql)三

WBOY
Release: 2016-06-21 08:58:12
Original
2123 people have browsed it
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 "
";
         
         
待续........ 
         



Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Recommendations
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template