在 Zend Framework 1(以下簡稱 ZF1)中,結合 Zend_Db_Select 查詢建構器與手動分頁邏輯,可快速實現資料分頁顯示。本文提供完整可執行範例,涵資料庫連線、統計總筆數、建構查詢、分頁導航生成等關鍵步驟。
<?php
isset($_GET['page']) ? $page = $_GET['page'] : $page = 1;
require_once("Zend/Loader.php");
Zend_Loader::loadClass("Zend_Db");
Zend_Loader::loadClass("Zend_Db_Statement_Pdo");
$config = array(
'host' => '127.0.0.1',
'username' => 'root',
'password' => '111',
'dbname' => 'test',
'profiler' => "true"
);
$db = Zend_Db::factory('PDO_Mysql', $config);
$db->query("SET NAMES utf8");
?>
<?php
// 取得總筆數
$total = $db->fetchOne("SELECT COUNT(*) FROM gongsi");
$perPage = 50;
$totalPages = ceil($total / $perPage);
?>
使用 Zend_Db_Select 鏈式語法建構含 GROUP BY、HAVING、ORDER BY 的複雜查詢:
<?php
$select = $db->select();
$select->from('sanguo', array(
's_sheng as 省份',
'sum(s_gongzi) as 總工資',
'min(s_gongzi) as 最低工資',
'max(s_gongzi) as 最高工資',
'avg(s_gongzi) as 平均工資'
));
$select->group('s_sheng');
$select->having('最高工資 > 10000');
$select->order('最高工資 DESC');
$select->limitPage($page, $perPage); // 核心分頁方法
$result = $db->fetchAll($select);
?>
<?php
echo "<table border='1' align='center' width='960' style='text-align:center'>";
echo "<tr><th>省份</th><th>總工資</th><th>最低工資</th><th>最高工資</th><th>平均工資</th></tr>";
foreach ($result as $row) {
echo "<tr>";
foreach ($row as $val) {
echo "<td>$val</td>";
}
echo "</tr>";
}
// 分頁導航
echo "<tr><td colspan='5'>";
echo "<a href='?page=1'>首頁</a> ";
if ($page > 1) echo "<a href='?page=" . ($page-1) . "'>上頁</a> ";
for ($i = 1; $i <= 15; $i++) {
echo "<a href='?page=$i'>$i</a> ";
}
if ($page < $totalPages) echo "<a href='?page=" . ($page+1) . "'>下頁</a> ";
echo "<a href='?page=$totalPages'>末頁</a>";
echo "</td></tr></table>";
?>
limitPage($page, $perPage) 自動處理 OFFSET 與 LIMIT 計算此範例展示 ZF1 時代典型的分頁實作模式,雖然框架已老舊,但查詢建構器的鏈式設計思想仍具參考價值。