社区(php&&mysql)二_php基础

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 "

";
    echo "";
      echo "";
    echo "

";

              echo "";     
              echo "穓碝ゅ彻:";
              echo "";
              echo "";

      echo "

";  
    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);
}
待续........