<?php header("content-type:text/html;charset=utf-8");$pdo = new pdo("mysql:host=127.0.0.1;dbname=demo;charset=utf8",'root','');$sql = "select * from cai";$db = $pdo->query($sql)->fetchall();$total = count($db);$num = 5;$cpage = isset($_get['page'])?$_get['page']:1;$pagenum = ceil($total/$num);$offset = ($cpage-1)*$num;$sql = "select * from cai limit {$offset},{$num}";$result = $pdo->query($sql)->fetchall();$start = $offset+1;$end=($cpage==$pagenum)?$total : ($cpage*$num);//结束记录页 $next=($cpage==$pagenum)? 0:($cpage+1);//下一页 $prev=($cpage==1)? 0:($cpage-1);//前一页 ?><!doctype html><html lang="en"><head><meta charset="utf-8"><title>展示</title></head><body><center><form action=""><table border="1"><tr><td>id</td><td>标题</td><td>作者</td><td>时间</td><td>分类</td><td>操作</td></tr><?php foreach ($result as $key => $value): ?><tr><td><?=$value['id']?></td><td><?=$value['title']?></td><td><?=$value['user']?></td><td><?=$value['time']?></td><td><?=$value['type']?></td><td><a href="javascript:viod(0)">编辑</a>|| <a href="javascript:viod(0)">删除</a></td></tr><?php endforeach ?></table></form><?php echo '<table align="center" width="800" border="1">'; echo "共<b>$total</b>条记录,本页显示<b>{$start}-{$end}</b> {$cpage}/{$pagenum}"; if($cpage==1) echo " 首页 "; else echo " <a href='?page=1'>首页</a> "; if($prev) echo " <a href='?page={$prev}'>上一页</a> "; else echo " 上一页 "; if($next) echo " <a href='?page={$next}'>下一页</a> "; else echo " 下一页 "; if($cpage==$pagenum) echo " 尾页 "; else echo " <a href='?page={$pagenum}'>尾页</a> "; echo '</td></tr>'; echo '</table>'; ?></center></body></html>
以上就是本文的全部内容,希望对大家的学习有所帮助,更多相关内容请关注!
相关推荐:
laravel手动创建数组分页
thinkphp3.2.3结合laypage实现分页功能
thinkphp中统计排行与分页显示的功能
以上就是php的原生分页代码的详细内容。
