## 讀取數據分頁獲取內容
這里用到了分頁函數
```
function pages($page, $class, $pages, $annex = null) {
//分頁附加值
if ($annex == NULL) {
$annexs = NULL;
} else {
$annexs = $annex;
}
if (($page - 1) > 0) { //上一頁
$shang .= '<li class="' . $class . '">';
$shang .= '<a href="?page=' . ($page - 1) . $annexs . '">«</a>';
$shang .= '</li>';
} else {
$shang .= '<li class="disabled">';
$shang .= '<a>«</a>';
$shang .= '</li>';
}
if (($page + 1) <= $pages) {//下一頁
$xia .= '<li class="' . $class . '">';
$xia .= '<a href="?page=' . ($page + 1) . $annexs . '">»</a>';
$xia .= '</li>';
} else {
$xia .= '<li class="disabled">';
$xia .= '<a>»</a>';
$xia .= '</li>';
}
$list .= '<footer class="panel-footer">';
$list .= '<ul class="pagination">';
$list .= '<li class="' . $class . '">';
$list .= '<a href="?page=1' . $annexs . '">首頁</a>';
$list .= '</li>';
$list .= $shang;
$list .= '<li class="disabled">';
$list .= '<a>第' . $page . '頁</a>';
$list .= '</li>';
$list .= $xia;
$list .= '<li class="' . $class . '">';
$list .= '<a href="?page=' . $pages . $annexs . '">尾頁</a>';
$list .= '</li>';
$list .= '<li class="disabled">';
$list .= '<a>共' . $pages . '頁</a>';
$list .= '</li>';
$list .= '</ul>';
$list .= '</footer>';
return $list;
}
```
**內置方法**
獲取數據總量
```
$count = DB('table')->getCount();
```
頁碼計算
```
//每頁顯示數量
$pagesize = 20;
//獲取頁數
$pages = ceil($count / $pagesize);
//當前頁碼
if (isset($_GET['page'])) {
$page = intval($_GET['page']);
} else {
$page = 1;
}
//獲取開始
$offset = $pagesize * ($page - 1);
//分頁是否可點
if ($pages < 2) {
$class = 'disabled';
} else {
$class = null;
}
```
獲取數據集
```
//獲取數據集
$rows = DB($tables)->limit($offset,$pagesize)->select();
```
**純SQL方法**
獲取數據總量
```
$count = DB('table')->getCount();
```
頁碼計算
```
//每頁顯示數量
$pagesize = 20;
//獲取頁數
$pages = ceil($count / $pagesize);
//當前頁碼
if (isset($_GET['page'])) {
$page = intval($_GET['page']);
} else {
$page = 1;
}
//獲取開始
$offset = $pagesize * ($page - 1);
//分頁是否可點
if ($pages < 2) {
$class = 'disabled';
} else {
$class = null;
}
```
獲取數據
```
$sql = "SELECT * FROM cp_table ORDER BY id DESC LIMIT " . $offset . " , " . $pagesize;
$rows = DB()->query($sql);
```
頁碼顯示
```
<?= pages($page, $class, $pages, $anv) ?>
```