postgres分页查询实例（PHP）

$dbconn = pg_connect("host=10.0.0.17 port=5432 dbname=zw user=postgres password=zwgc305");
 
 if( isset($_GET['page']) ){
    $page = intval( $_GET['page'] );
    }
    else{
    $page = 1;
    }
 $page_size=15;
 
 $result = pg_Exec($dbconn, "SELECT * FROM ds_beinfo");
    $amount = pg_num_rows($result);
 
 if( $amount ){
       if( $amount < $page_size ){ $page_count = 1; }
        if( $amount % $page_size ){                                 
           $page_count = (int)($amount / $page_size) + 1;
         }
        else{
            $page_count = $amount / $page_size;
            }
                 }
    else{
    $page_count = 0;
    }
 

 
 $pp=($page-1)*$page_size;
 if( $amount ){
    //$sql = "select * from ds_beinfo order by host desc limit $pp offset $page_size";
    $result = pg_Exec($dbconn, "SELECT * FROM ds_beinfo order by host desc limit $page_size offset $pp");
 $color = "lighter";
 echo"<table>";
 while ($row = pg_fetch_row($result)) {
        if($color == "darker") {
      $color = "lighter";
     }
     else {
      $color = "darker";
     }
 echo "<tr class=/"$color/">";
 echo "<td width=/"20%/">$row[0]</td>";
    echo "<td width=/"20%/">$row[1]</td>";
 echo "<td width=/"60%/">$row[2]</td>";
 echo "</tr>";
 }
   }

 echo "</table>";
 echo"<a href=behavior.php?page=1>第一页</a>|";
 if( $page<$page_count ){
 $pa=$page+1;
    echo"<a href=behavior.php?page=$pa>下一页</a>|";
    }
 if(($page<11) && ($page<$page_count || $page == $page_count) ){
  if(1<$page_count || 1 == $page_count){
  echo"<a href=behavior.php?page=1>1</a>|";}
  if(2<$page_count || 2 == $page_count){
  echo"<a href=behavior.php?page=2>2</a>|";}
  if(3<$page_count || 3 == $page_count){
  echo"<a href=behavior.php?page=3>3</a>|";}
  if(4<$page_count || 4 == $page_count){
  echo"<a href=behavior.php?page=4>4</a>|";}
  if(5<$page_count || 5 == $page_count){
  echo"<a href=behavior.php?page=5>5</a>|";}
  if(6<$page_count || 6 == $page_count){
  echo"<a href=behavior.php?page=6>6</a>|";}
  if(7<$page_count || 7 == $page_count){
  echo"<a href=behavior.php?page=7>7</a>|";}
  if(8<$page_count || 8 == $page_count){
  echo"<a href=behavior.php?page=8>8</a>|";}
  if(9<$page_count || 9 == $page_count){
  echo"<a href=behavior.php?page=9>9</a>|";}
  if(10<$page_count || 10 == $page_count){
  echo"<a href=behavior.php?page=10>10</a>|";}
  if(11<$page_count || 11 == $page_count){
  echo"<a href=behavior.php?page=11>11</a>|";}
  }
  if(($page>11||$page==11) && ($page<$page_count || $page == $page_count) ){
  $qf=$page-4;
  echo"<a href=behavior.php?page=$qf>$qf</a>|";
  $qe=$page-3;
  echo"<a href=behavior.php?page=$qe>$qe</a>|";
  $qd=$page-2;
  echo"<a href=behavior.php?page=$qd>$qd</a>|";
  $qc=$page-1;
  echo"<a href=behavior.php?page=$qc>$qc</a>|";
  echo"<a href=behavior.php?page=$page>$page</a>|";
  $pc=$page+1;
  if($pc<$page_count || $pc == $page_count ){
     echo"<a href=behavior.php?page=$pc>$pc</a>|";}
  $pd=$page+2;
  if($pd<$page_count || $pd == $page_count ){
     echo"<a href=behavior.php?page=$pd>$pd</a>|";}
  $pe=$page+3;
  if($pe<$page_count || $pe == $page_count ){
     echo"<a href=behavior.php?page=$pe>$pe</a>|";}
  $pf=$page+4;
  if($pf<$page_count || $pf == $page_count ){
     echo"<a href=behavior.php?page=$pf>$pf</a>|";}
  $pd=$page+5;
  if($pd<$page_count || $pd == $page_count ){
     echo"<a href=behavior.php?page=$pd>$pd</a>|";}
    }
        if(($page > 1)&&($page<$page_count || $page == $page_count)){
     $pb=$page-1;
        echo"<a href=behavior.php?page=$pb>上一页</a>|";
        }
  echo"<a href=behavior.php?page=$page_count>尾页</a>";