php分页程序及简单实例说明

<script>ec(2);</script>

$sql="select * from my_note where note_url='4'";
 $result=mysql_query($sql) or die('Error'.mysql_error());
 $allrecord=mysql_num_rows($result);
 $page=isset($_GET['page'])?$_GET['page']:1;
 $pagesize=10;
 $pagecount=($allrecord % $pagesize)?(int)($allrecord / $pagesize) +1:$allrecord / $pagesize;
 $page=($page>$pagecount || $page  $start=$pagesize*($page-1);
 $sqllist="select * from my_note where note_url='4'  order by id desc limit $start,$pagesize ";
 $resulte=mysql_query($sqllist) or die('Error '.mysql_error());
 $num=mysql_num_rows($resulte);
 if($num){
  while($rs=mysql_fetch_object($resulte)){
   if($rs->note_url=='1'){
   echo("

".$rs->note_title." [".$rs->note_date."]

n");
   }else{
   echo("

".$rs->note_title." [".$rs->note_date."]

n");
   }
  }
 echo("

共".$pagecount."页 每页".$pagesize."条记录 共".$allrecord."个作品

");
 for($i=$pagecount;$i>=1;$i--){
  echo("

".($i)."

");
 }
  echo("

");
 }else{
  echo('No Infomation');
 }
}