社区(php&&mysql)二-php手册-php.cn

Heim

php教程

php手册

社区(php&&mysql)二

Jun 13, 2016 pm 12:41 PM

amp function mysql php replace str zwei 社区

function sdatetime($str){
    $str=ereg_replace("-","/",$str);
    $str=substr($str,5,strlen($str)-8);
    return $str;
}

function reAnum($sid){ //羆莱絞计
    $DROOT=getenv('DOCUMENT_ROOT');
    include("sql.php3");
    $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);
    $qsql="SELECT id from bbs_docs where sid='$sid'";
    $rs=mysql_db_query($sql['db'],$qsql);
    return mysql_num_rows($rs);
}

function pagebar($pages) {
    global $pgno;
    //global $pages;
    global $PHP_SELF;
    global $aid;
    global $OPEN_LIST;
    echo "

";
    echo "";
    echo "";
    //echo "";
    echo "

";
    if($pgno!=0) {
        $pu=$pgno-1;
        echo "[]";
    }
    if($pgno        $pd=$pgno+1;
        echo "[]";
    }
    for($i=0;$i        if($pgno==$i) {
            echo "";
            echo "[".($i+1)."]";
            echo "";
        } else {
            echo "";
            echo "[".($i+1)."]";
            echo "";
        }
    }
    echo "

";
        echo "";
                echo "[祇ゅ彻]";
                echo "";
    //echo "

";
            if($OPEN_LIST) {
                echo "";
                echo "[ぃ甶秨杠肈]";
                echo "";
            }else {
                echo "";
                echo "[甶秨杠肈]";
                echo "";
            }
    echo "

";

}
//===============================================================================
function openlist($sid) {
    global $aid;
    global $PHP_SELF;

    $DROOT=getenv('DOCUMENT_ROOT');
    include("sql.php3");
    $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);
    $qsql="SELECT * from bbs_docs where sid='$sid' order by wdate";
    $rs=mysql_db_query($sql['db'],$qsql);
    //if(mysql_num_rows($rs)==0) return;
    //echo  mysql_num_rows($rs);
    while($row=mysql_fetch_array($rs)) {
        $id=$row['id'];
            $banner=$row['banner'];
            $poster=$row['poster'];
            $views=$row['views'];
            $wdate=sdatetime($row['wdate']);

            echo "";
                echo "";
                    echo "";
                    echo "  $banner";
                    echo "";
                    //echo "banner is $banner";
                echo "";
                echo "";
                    echo $poster;
                echo "";
                echo "";
                    echo " ";
                echo "";
                echo "";
                    echo $views;
                echo "";
                echo "";
                    echo $wdate;
                echo "";

            echo "";
    }

}

//========================================================================
function area() {
    global $PHP_SELF;
    global $aid,$sid,$pgno;
    global $OPEN_LIST;
    $showitems=20;
    $DROOT=getenv('DOCUMENT_ROOT');
    include("sql.php3");
    $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);
    //============================================================
    if(!$aid) {
          $qsql="SELECT id from bbs_area";
          $rs=mysql_db_query($sql['db'],$qsql);
          $row=mysql_fetch_array($rs);
          $aid=$row['id'];
        }
    if(!$sid) {
        $qsql="SELECT id from bbs_subj where aid=$aid order by wdate DESC";
        $rs=mysql_db_query($sql['db'],$qsql);
        $row=mysql_fetch_array($rs);
        $sid=$row['id'];
    }

    if(!$pgno) {//礚﹚计
        //$pgno=0;
        $items=0;
        $qsql="SELECT id from bbs_subj where aid=$aid order by wdate DESC";
        $rs=mysql_db_query($sql['db'],$qsql);
        while($row=mysql_fetch_array($rs)){
            $id=$row['id'];
            if($id==$sid) break;
            $items++;
        }
        $pgno=(INT)($items/$showitems);
    }

    //============================================================
    $qsql="SELECT * from bbs_area where id=$aid ";
    $rs=mysql_db_query($sql['db'],$qsql);
    $row=mysql_fetch_array($rs);
    $banner=$row['banner'];
    $body=$row['body'];
    $master=$row['master'];
    echo "$banner";

    echo "";

    $qsql="SELECT * from bbs_subj where aid=$aid order by wdate DESC";
    $rs=mysql_db_query($sql['db'],$qsql);
    $all=mysql_num_rows($rs);  //how rows
    $pages=(INT)($all/$showitems); // how pages
    $pgcount=$pgno*$showitems;
    if($pgcount > $all) {
        $pgno=$pages-1; // Page point over all pages
        $pgcount=$pgno*$showitems;
     }
    mysql_data_seek($rs, $pgcount);
    $cnt=0;
    pagebar($pages);
    echo "";
      echo "

";
      echo "";
        echo "";
            echo "";
            echo "";
            echo "";
            echo "";
            echo "";
        echo "";
        while($row=mysql_fetch_array($rs)) {
            if(++$cnt > $showitems) break;
            $id=$row['id'];
            $banner=$row['banner'];
            $poster=$row['poster'];
            $views=$row['views'];
            $wdate=sdatetime($row['wdate']);
            $docs=reAnum($id);
            echo "";
                echo "";
                echo "";
                echo "";
                echo "";
                echo "";
            echo "";
            if($OPEN_LIST) openlist($id);
        }
      echo "

夹肈	祇癬	莱		ら戳
"; echo ""; if($sid==$id) echo "〈$banner"; else echo $banner; echo ""; echo "	"; echo $poster; echo "	"; echo $docs; echo "	"; echo $views; echo "	"; echo $wdate; echo "

";
echo"

";

pagebar($pages);
}
待续........

Erklärung dieser Website

Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn