分頁是 Web 開發最基礎也最常見的需求。本文從核心原理、簡單程式碼、到物件導向封裝類別,完整解析 PHP 分頁實作。
$pageSize:每頁筆數(如 10)$currentPage:目前頁碼(從 $_GET 取得,預設 1)$totalRows:總資料筆數(SELECT COUNT(*) 取得)衍生參數:
$totalPages = ceil($totalRows / $pageSize)($currentPage - 1) * $pageSizeSELECT * FROM table LIMIT $offset, $pageSize<?php
// 1. 取得目前頁碼
$page = isset($_GET['page']) ? max(1, intval($_GET['page'])) : 1;
$pageSize = 10;
// 2. 取得總筆數
$link = mysqli_connect("localhost", "user", "pass", "db");
$sql = "SELECT COUNT(*) AS total FROM articles";
$totalRows = mysqli_fetch_assoc(mysqli_query($link, $sql))['total'];
// 3. 計算總頁數
$totalPages = $totalRows ? ceil($totalRows / $pageSize) : 0;
// 4. 產生分頁連結
$pageLinks = '';
if ($page > 1) {
$pageLinks .= '首頁 | 上一頁 | ';
} else {
$pageLinks .= '首頁 | 上一頁 | ';
}
if ($page < $totalPages) {
$pageLinks .= '下一頁 | 末頁';
} else {
$pageLinks .= '下一頁 | 末頁';
}
// 5. 查詢當頁資料
$offset = ($page - 1) * $pageSize;
$sql = "SELECT * FROM articles ORDER BY id DESC LIMIT $offset, $pageSize";
$result = mysqli_query($link, $sql);
$rows = mysqli_fetch_all($result, MYSQLI_ASSOC);
// 6. 顯示資料與分頁列
foreach ($rows as $row) { /* 輸出內容 */ }
echo $pageLinks;
?>
<?php
class Pager {
public $pageSize = 10;
public $currentPage = 1;
public $totalRows = 0;
public $totalPages = 0;
public $prevPage = 0;
public $nextPage = 0;
public $isFirstPage = false;
public $isLastPage = false;
public $sql = '';
public function __construct($options = []) {
foreach ($options as $k => $v) if (property_exists($this, $k)) $this->$k = $v;
$this->calculate();
}
private function calculate() {
global $db; // 假設使用 PDO 或其他 DB 抽象層
if ($this->totalRows === 0) {
$res = $db->query("SELECT COUNT(*) FROM ({$this->sql}) AS t");
$this->totalRows = $res->fetchColumn();
}
$this->totalPages = $this->totalRows ? ceil($this->totalRows / $this->pageSize) : 0;
$this->currentPage = max(1, min($this->currentPage, $this->totalPages));
$this->isFirstPage = ($this->currentPage == 1);
$this->isLastPage = ($this->currentPage == $this->totalPages);
$this->prevPage = $this->isFirstPage ? 0 : $this->currentPage - 1;
$this->nextPage = $this->isLastPage ? 0 : $this->currentPage + 1;
}
// 取得當頁資料(二維陣列)
public function getPageData() {
if (!$this->totalRows) return [];
$offset = ($this->currentPage - 1) * $this->pageSize;
$sql = $this->sql . " LIMIT $offset, $this->pageSize";
return $db->query($sql)->fetchAll(PDO::FETCH_ASSOC);
}
// 取得分頁導航 HTML
public function getLinks($baseUrl = '?') {
if ($this->totalPages <= 1) return '';
$html = '';
if (!$this->isFirstPage) {
$html .= '首頁 | 上一頁 | ';
}
if (!$this->isLastPage) {
$html .= '下一頁 | 末頁';
}
return $html;
}
}
// 使用範例
$pager = new Pager([
'sql' => 'SELECT * FROM articles ORDER BY id DESC',
'currentPage' => $_GET['page'] ?? 1,
'pageSize' => 10
]);
$articles = $pager->getPageData();
echo $pager->getLinks();
?>
COUNT(*) 全表掃描,改用觸發器維護計數表或近似值(EXPLAIN rows)。WHERE id > $lastId ORDER BY id LIMIT $pageSize 替代 OFFSET,避免深分頁效能劣化。intval(),防止 SQL 注入;LIMIT 參數用預處理或強制整數。