这里我以10个数据进行分页操作。
<?php
//总记录数
$result = $conn -> query("select id from sea_info where categoryid=11");
$count = $conn -> numrows($result); #记录数
//每页显示
$size = 10;
//总页数
$pagecount = ceil($count/$size);
//获取浏览器传来的PAGE值 去除两边空格 转成整数 无则赋值1
$page = isset($_GET['page']) ? intval(trim($_GET['page'])) : 1;
//如果小于1或大于总页数则等于1
if($page < 1 || $page > $pagecount) $page = 1;
//从第几条记录开始显示
$begin = ($page - 1) * $size;
$res = $conn->query("SELECT * FROM sea_info where categoryid=11 ORDER BY id DESC LIMIT $begin,$size");
while($os=$conn->fetcharray($res)){
echo '<a href="news_content.php?id='.$os['id'].'" title="'.$os['title'].'" class="s-babg">
<dl class="prolistbgfff">
<dt class="pic"><img src="../attachments/'.$os['img'].'" alt="'.$os['title'].'" height="100"/></dt>
<h3 class="s-wc">'.$os['title'].'</h3>
<p class="content">'.$os['note'].'</p>
<span></span>
<div class="clear"></div>
</dl>
</a>';
}
//翻页
$last = $page - 1;//前页
$next = $page + 1;//后页
echo <<<HTML
<form method="get">
<div class="g-page f-tc">
<a id="btnPageUp" class="u-pup" href="?page={$last}">‹前页</a>
第{$page}/{$pagecount}页
<a id="btnPageDown" class="u-pne" href="?page={$next}">后页›</a>
<input type="text" name="page" size="3" title="跳转到第几页?"/>
<input type="submit" value="GO"/>
<div>
</form>
HTML;
?>