<?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>
以上就是本文的全部內容，希望對大家的學習有所協助，更多相關內容請關注topic.alibabacloud.com！
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
