当前位置:Gxlcms > PHP教程 > 社区(php&&mysql)二

社区(php&&mysql)二

时间:2021-07-01 10:21:17 帮助过:25人阅读

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<$pages) {
    $pd=$pgno+1;
    echo "[]";    
  }  
  for($i=0;$i<=$pages;$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);
}
待续........

人气教程排行