關於php分頁代碼的簡單實現

這次給大家帶來關於php分頁代碼的簡單實現 ，下面就是具體內容，一起跟隨小編來看一下。

資料庫操作類代碼

<?php// 資料庫連接常量define('DB_HOST', 'localhost');define('DB_USER', 'root');define('DB_PWD', '');define('DB_NAME', 'guest');// 串連資料庫function conn(){    $conn = mysqli_connect(DB_HOST, DB_USER, DB_PWD, DB_NAME);    mysqli_query($conn, "set names utf8");    return $conn;}//獲得結果集function doresult($sql){   $result=mysqli_query(conn(), $sql);   return  $result;}//結果集轉為對象集合function dolists($result){    return mysqli_fetch_array($result, MYSQL_ASSOC);}function totalnums($sql) {    $result=mysqli_query(conn(), $sql);    return $result->num_rows;}// 關閉資料庫function closedb(){    if (! mysqli_close()) {        exit('關閉異常');    }}?>

分頁實現代碼:

<?phpinclude 'mysqli.func.php';// 總記錄數$sql = "SELECT dg_id  FROM  tb_user ";$totalnums = totalnums($sql);// 每頁顯示條數$fnum = 8;// 翻頁數$pagenum = ceil($totalnums / $fnum);// 頁數常量@$tmp = $_GET['page'];//防止惡意翻頁if ($tmp > $pagenum)    echo "<script>window.location.href='index.php'</script>";//計算分頁起始值if ($tmp == "") {    $num = 0;} else {    $num = ($tmp - 1) * $fnum;}// 查詢語句$sql = "SELECT dg_id,dg_username  FROM  tb_user ORDER BY dg_id DESC LIMIT " . $num . ",$fnum";$result = doresult($sql);// 遍曆輸出while (! ! $rows = dolists($result)) {    echo $rows['dg_id'] . " " . $rows['dg_username'] . "<br>";}// 翻頁連結for ($i = 0; $i < $pagenum; $i ++) {    echo "<a href=index.php?page=" . ($i + 1) . ">" . ($i + 1) . "</a>";}?>

簡單實現了翻頁功能,資料庫請自行配置結構