我有一个页面，用于显示限于20条记录的数据库项其他记录应该显示在下一页，每页20项，依此类推下面是显示最后20项的代码。
<?php
require_once '../Model/Connexion.php';
$c = new Connexion();
$results = $c->query("select * from annonce limit 20 ");
$rows = $c->resultset(); ?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Ads display</title>
</head>
<body>
<div id="Wraper">
<div id="Middle">
<div class="Left">
<div class="Content FCKeditor">
<div class="Pagination">
<span class="Fright">Page 1
<a href="page.php?page=<?php echo $number?>"> | Next </a></span>
<span class="Fleft">Showing 1 to 20 jobs of <?php echo $c->rowCount()?></span>
</div>
<div class="Joblist">
<?php foreach($rows as $r) { ?>
<p class="Title">
<span class="Ref"></span>
<a href="details.php?id=<?php echo($r['id_annonce']) ?>">
<?php echo($r['poste']); ?></a></p>
<p class="Date"><span class="Fright"><?php echo($r['type_contrat']); ?></span>
<span><a href="client.php" class="Sectorbtn"><?php echo($r['client']); ?></a></span></p>
<p style="text-align:justify;"><?php echo($r['desc_annonce']); ?></p>
<p class="More">
<a href="details.php?id=<?php echo($r['id_annonce']) ?>">View more</a>
</p>
<?php }?>
</div>
<div class="Pagination">
<span class="Fright">Page 1<a href="page.php?page=<?php echo $number?>"> | Next </a></span>
<span class="Fleft">Showing 1 to 20 jobs of <?php echo $c->rowCount()?></span>
</div>
</div>
</div>
</div>
</div>
</body>
</html>
我想在一个有序的页面上显示其他项目，你能帮我吗?
基本上，您需要2个请求:
计算作业总数的请求:
SELECT COUNT(*) FROM annonce
请求在第n页中包含从(n-1)*X开始的X个作业。第4页示例:
SELECT * FROM annonce LIMIT 60, 20