php+mysql分页代码示例

<?

$pagesize=30;

if (isset($_GET['page']))

{

  $page=intval($_GET['page']);

}

else

{

  $page=1;

}

$next_page = $page+1;

$pre_page = $page-1;

//计算总条数

$rs=mysql_query("select count(*) from fenye_table", $conn);

$myrow = mysql_fetch_array($rs);

$numrows=$myrow[0];

//计算总页数

$pages=intval($numrows/$pagesize);

if($numrows%$pagesize) $pages++;

//取出该页数据

$offset=$pagesize*($page - 1);

$elist_res = mysql_query("select * from fenye_table order by id desc limit $offset,$pagesize", $conn);

while($udetail=mysql_fetch_array($elist_res))

{?>

  //这里显示该页的数据

<?}?>

<DIV>

  <a href="fenye.php">第一页</a> 

  <?if($pre_page!=0){?><a href="fenye.php?page=<? echo $pre_page;?>">上一页</a><?}?> 

  <?if($next_page!=$pages){?><a href="fenye.php?page=<? echo $next_page;?>">下一页</a><?}?>

  <span>总共<? echo $pages;?>页，这是第<? echo $page; ?>页，每页<? echo $pagesize; ?>条</span>

</DIV>