數據分頁詳解 · PhpGrace框架

# 數據分頁詳解查詢數據時使用數據操作對象的 page 函數即可快速完成分頁，使用page函數，查詢數據的格式如下： ~~~ $data?=?array( ????數據列表, ????分頁對象 ); ~~~ ## **分頁對象結構** ~~~ 分頁對象->firstPage?//第一頁鏈接分頁對象->prePage?//上一頁鏈接分頁對象->listPage?//列表頁鏈接【數組格式】分頁對象->nextPage?//下一頁鏈接分頁對象->lastPage?//最后一頁鏈接分頁對象->skipPage?//跳轉頁dom 分頁對象->currentPage?//當前頁 ~~~ ## **完整的演示示例 **![1.jpg](http://www.phpgrace.com/statics/images/201805/1525922642210160.jpg "1525922576330275.jpg") 如在 index\_index.php 視圖文件內展示數據： ## **演示數據表** ~~~ CREATE?TABLE?`accounts`?( ??`id`?int(10)?NOT?NULL?AUTO_INCREMENT, ??`name`?varchar(20)?DEFAULT?NULL, ??`balance`?int(10)?DEFAULT?NULL, ??PRIMARY?KEY?(`id`) )?ENGINE=InnoDB?AUTO_INCREMENT=102?DEFAULT?CHARSET=utf8; ~~~ ## **創建一些數據用于演示** ~~~ <?php class?indexController?extends?grace{ ????public?function?addData(){ ????????$db?=?db('accounts'); ????????for($i?=?1;?$i?<?100;?$i++){ ????????????$data?=?array( ????????????????'name'?=>?uniqid(), ????????????????'balance'?=>?mt_rand(111,999) ????????????); ????????????$db->add($data); ????????} ????} } ~~~ ## **您可以編寫分頁樣式來制作漂亮的分頁** ~~~ <?php?if(!defined('PG_VERSION')){exit;}?> <!DOCTYPE?html> <html> <head> <meta?charset="UTF-8"> <title>welcome?to?phpGrace</title> </head> <body> <style?type="text/css"> *{font-family:?"微軟雅黑";?color:#333;} a{text-decoration:none;} table?{border-left:1px?solid?#F0F9FC;?border-top:1px?solid?#F0F9FC;} td,th{border-right:1px?solid?#F0F9FC;?border-bottom:1px?solid?#F0F9FC;?padding:8px;?text-align:center;} /*?分頁樣式?*/ .grace-pager{float:right;} .grace-pager?a{display:block;?background:#F5F5F5;?padding:0px?10px;?height:30px;?line-height:30px;?float:left;?margin:3px;?border-radius:2px;} .grace-pager?a:hover{background:#2F4056;?text-decoration:none;?color:#FFF;} .grace-pager?.grace-current{background:#5FB878?!important;?color:#FFF?!important;} </style> <div?style="width:600px;?padding:50px;?margin:0?auto;"> ????<table?border="0"?cellspacing="0"?cellpadding="0"?width="100%"> ????????<tr> ????????????<th>ID</th> ????????????<th>Name</th> ????????????<th>Balance</th> ????????</tr> ????????<?php ????????$db?=?db('accounts'); ????????$data?=?$db->order('id?desc')->page(10)->fetchAll(); ????????foreach($data[0]?as?$rows){ ?????????> ????????<tr> ????????????<td><?php?echo?$rows['id'];?></td> ????????????<td><?php?echo?$rows['name'];?></td> ????????????<td><?php?echo?$rows['balance'];?></td> ????????</tr> ????????<?php?}?> ????</table> </div> <div?style="width:600px;?padding:0?50px;?margin:0?auto;"> ????<div?class="grace-pager"> ????????<a?href="<?php?echo?$data[1]->firstPage;?>">首頁</a> ????????<a?href="<?php?echo?$data[1]->prePage;?>">上一頁</a> ????????<?php ????????foreach($data[1]->listPage?as?$k?=>?$v){ ????????????if($k?==?$data[1]->currentPage){ ????????????????echo?'<a?href="'.$v.'"?class="grace-current">'.$k.'</a>'; ????????????}else{ ????????????????echo?'<a?href="'.$v.'">'.$k.'</a>'; ????????????} ????????} ?????????> ????????<a?href="<?php?echo?$data[1]->nextPage;?>">下一頁</a> ????????<a?href="<?php?echo?$data[1]->lastPage;?>">尾頁</a> ????</div> </div> </body> </html> ~~~ ## **關于數據總數說明** phpgrace 內置的分頁組件會自動根據查詢語句計算獲取數據總數，有時候您的查詢語句有可能是復雜的（相對總數查詢），那么您可以自己編寫查詢總數的代碼獲取總數并告知分頁組件： ~~~ $數據操作對象->page(每頁展示數,?總數)->..... ~~~ ## **上面的例子可以修改為** ~~~ <?php $db?=?db('accounts'); //手動查詢總數，比如：利用第一url參數記錄總數 if(empty($_GET['total'])){ ????$_GET['total']?=?$db->count(); }else{ ????echo?'使用?url?參數...'; } $data?=?$db->order('id?desc')->page(10,?$_GET['total'])->fetchAll(); foreach($data[0]?as?$rows){ ?> <tr> ????<td><?php?echo?$rows['id'];?></td> ????<td><?php?echo?$rows['name'];?></td> ????<td><?php?echo?$rows['balance'];?></td> </tr> <?php?}?> ~~~