//mysql php 分页显示
<?php
include "link_data.php";//数据连接文件
$sql=mysqli_query($link1,"SELECT * FROM 表名 where 条件");
$result=mysqli_fetch_array(mysqli_query($link1,"SELECT COUNT(*) AS count from 表名 where 条件"));
$count=$result['count']; //总记录数
$perpages=3;//每页显示的记录数
$n=ceil($count/$perpages);//总页数
$lastpages=$count%$perpages;//最后一页显示的记录数
if (isset($_GET['num'])){
if ($_GET['num']<2){
$pre=1;
$bac=2;
$start=$pre;
}else if ($_GET['num']>$n-1){
$pre=$n-1;
$bac=$n;
$start=($_GET['num']-1)*$perpages+1;
}else if ($_GET['num']==2){
$pre=$_GET['num']-1;
$bac=$_GET['num']+1;
$start=($_GET['num']-1)*$perpages+1;
}else {
$pre=$_GET['num']-1;
$bac=$_GET['num']+1;
$start=($_GET['num']-1)*$perpages+1;
}
}else {
$pre=1;
$bac=2;
$start=$pre;
}
$k=0;
while ($obj = mysqli_fetch_object($sql)) {
$arrs[] = $obj;
}
echo "<div>";
foreach($arrs as $key=>$values){
$k++;
$tname="{$values->knowledgename}";
if ($k>$start-1 and $k<$start+$perpages){
echo "<div class='zxcontent'>".$tname."</div>";
}
}
echo "</div>";
?>
<a href="?num=<?php echo $pre; ?>">上一个</a><br />
<a href="?num=<?php echo $bac; ?>">下一个</a><br />
</div>
<?php
?>