# 常規獲取 第一步：獲取數據 ``` //狀態排序 if ($_GET['status'] > 0) { $status = "status=" . $_GET['status']; } else { $status = "status>0"; } //數據查詢 if ($_POST['type'] != '') { $search = "{$_POST['type']}='{$_POST['search']}'"; } else { $search = '1'; } //獲取數據總量 $count = DB('shop_project')->where("$status and $search")->getCount(); //每頁顯示數量 $pagesize = CP_SYS_PAGES; //獲取頁數 $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('shop_project')->where("$status and $search")->order('sort asc')->limit($offset, $pagesize)->select(); ``` 第二步：展示與分頁 1、數據列表展示 ``` foreach ($rows as $res) { if ($res['status'] == 1) { $status = '<font color="green">正常</font>'; } elseif ($res['status'] == 2) { $status = '<font color="red">停用</font>'; } echo '<tr>' . '<th><input class="form-control" style="width: 48px;" type="text" name="sort" value="' . $res['sort'] . '"> <input type="hidden" name="id" value="' . $res['id'] . '"></th>' . '<th>' . $res['id'] . '</th>' . '<th>' . $res['name'] . '</th>' . '<th></th>' . '<th></th>' . '<th>' . app::cout(app::clear_all($res['info']), 30) . '</th>' . '<th>' . $status . '</th>' . '<th>' . '<a href="?do=edit&id=' . $res['id'] . '" class="btn btn-sm btn-info btn-addon"><i class="fa fa-edit"></i>編輯</a> ' . '</th>' . '</tr>'; } ``` 2、分頁代碼 ``` <?= pages($page, $class, $pages, '&status=' . $_GET['status']) ?> ``` ***** # 多表查詢 其它方法同上【常規獲取】 獲取數據如下： ``` //狀態排序 if ($_GET['status'] > 0) { $status = "a.status=" . $_GET['status']; } else { $status = "a.status>0"; } //數據查詢 if ($_POST['type'] != '') { $search = "a.{$_POST['type']}='{$_POST['search']}'"; } else { $search = '1'; } //獲取數據總量 $sql = "SELECT b.name AS gname,b.info AS ginfo,a.* FROM {$_tb}shop_project AS a LEFT JOIN {$_tb}shop_project_type AS b ON a.tid = b.id WHERE $status and $search"; $count = DB()->execute($sql); //每頁顯示數量 $pagesize = CP_SYS_PAGES; //獲取頁數 $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 = $sql . " ORDER BY a.sort asc LIMIT " . $offset . " , " . $pagesize; $rows = DB()->query($sql); ```