function getAllAdmin() { $sql = "select id,username,email from imooc_admin"; $rows = fetAll($sql); return $rows; }
$sql = "select * from imooc_admin"; $totalRows = getResultNum($sql); $pageSize = 2; //每页显示的条数 $totalPage = ceil($totalRows / $pageSize); //总页码数 @($page = $_REQUEST['page'] ? (int) $_REQUEST['page'] : 1); if ($page < 1 || !is_numeric($page)) { $page = 1; } if ($page > $totalPage) { $page = $totalPage; } $offset = ($page - 1) * $pageSize; $sql = "select * from imooc_admin limit {$offset},{$pageSize}"; $rows = fetAll($sql); foreach ($rows as $row) { echo "编号: " . $row['id'] . '<br/>'; echo "管理员名称: " . $row['username'] . '<hr/>'; } echo showPage($page, $totalPage); echo "<hr/>"; echo showPage($page, $totalPage, "cid=5&pid=6"); function showPage($page, $totalPage, $where = null, $sep = ' ') { $where = $where == null ? null : "&" . $where; //$where参数可以显示子类 $url = $_SERVER['PHP_SELF']; //获取当前页面的路径 $index = $page == 1 ? "首页" : "<a href='{$url}?page=1{$where}'>首页</a>"; $last = $page == $totalPage ? "尾页" : "<a href='{$url}?page={$totalPage}{$where}'>尾页</a>";