<?php//showPage(頁(yè)號(hào)，總頁(yè)數(shù)，分隔符)function showPage($page,$totalPage,$sep=" "){  $url = $_SERVER ['PHP_SELF'];      //獲取當(dāng)前路徑  $index = ($page == 1) ? "首頁(yè)" : "<a href='{$url}?page=1'>首頁(yè)</a>";  $last = ($page == $totalPage) ? "尾頁(yè)" : "<a href='{$url}?page={$totalPage}'>尾頁(yè)</a>";  $prevPage=($page>=1)?$page-1:1;  $nextPage=($page>=$totalPage)?$totalPage:$page+1;  $prev = ($page == 1) ? "上一頁(yè)" : "<a href='{$url}?page={$prevPage}'>上一頁(yè)</a>";  $next = ($page == $totalPage) ? "下一頁(yè)" : "<a href='{$url}?page={$nextPage}'>下一頁(yè)</a>";  $str = "總共{$totalPage}頁(yè)/當(dāng)前是第{$page}頁(yè)";  $p="";  for($i = 1; $i <= $totalPage; $i ++) {    //當(dāng)前頁(yè)無(wú)連接    if ($page == $i) {      $p .= "[{$i}]";    } else {      $p .= "<a href='{$url}?page={$i}'>[{$i}]</a>";    }  }  $pageStr=$str.$sep . $index .$sep. $prev.$sep . $p.$sep . $next.$sep . $last;  return $pageStr;  //返回分頁(yè)字符串}

<?phpinclude "../mysql.php";include "../page.php";//連接數(shù)據(jù)庫(kù)$conn=new Mysql();//$pageSize=2;    //每頁(yè)顯示的記錄數(shù)$sql="select * from user;";$totalRows=$conn->getResultNum($sql);  //總記錄數(shù)$totalPage=ceil($totalRows/$pageSize); //總頁(yè)數(shù)$page=isset($_REQUEST['page'])?(int)$_REQUEST['page']:1;//當(dāng)前頁(yè)數(shù)if($page<1||$page==null||!is_numeric($page)){  $page=1;}if($page>=$totalPage)$page=$totalPage;$offset=($page-1)*$pageSize;$sql="select * from user limit {$offset},{$pageSize}";$result=$conn->sql($sql);echo "<table style='text-align: center'>";echo "<tr><td>用戶名</td><td>密碼</td><td>性別</td><td>郵箱</td></tr>";foreach ($result as $k=>$v){  echo "<tr><td>{$v['name']}</td>";  echo "<td>"."{$v['password']}"."</td>";  echo "<td>{$v['sex']}</td>";  echo "<td>{$v['email']}</td></tr>";}echo "</table>";echo showPage($page,$totalPage);    //輸出頁(yè)碼鏈接echo"<hr/>";//關(guān)閉數(shù)據(jù)庫(kù)$conn->close();