PHP 實現簡單數字分頁完整代碼

學習要點：LIMIT 用法、參數計算、超鏈接生成。

核心分頁邏輯

// 分頁模塊
if (isset($_GET['page'])) {
    $_page = $_GET['page'];
    if (empty($_page) || $_page < 0 || !is_numeric($_page)) $_page = 1;
    else $_page = intval($_page);
} else $_page = 1;

$_pagesize = 10;
$_num = _num_rows(_query("SELECT tg_id FROM tg_user"));
$_pageabsolute = $_num == 0 ? 1 : ceil($_num / $_pagesize);

// 頁碼超出總頁數修正
if ($_page > $_pageabsolute) $_page = $_pageabsolute;
$_pagenum = ($_page - 1) * $_pagesize;

數據查詢

$_result = _query("SELECT tg_username,tg_sex,tg_face FROM tg_user ORDER BY tg_reg_time DESC LIMIT $_pagenum,$_pagesize");

前端分頁顯示

<div id="page_num">
    <ul>
    <?php for($i=0; $i<$_pageabsolute; $i++) { 
        if ($_page == ($i+1)) {
            echo '<li><a href="blog.php?page='.($i+1).'" class="selected">'.($i+1).'</a></li>';
        } else {
            echo '<li><a href="blog.php?page='.($i+1).'">'.($i+1).'</a></li>';
        }
    } ?>
    </ul>
</div>

CSS 樣式

#page_num { height:20px; clear:both; padding:10px 0; position:relative; }
#page_num ul { position:absolute; right:30px; height:20px; }
#page_num ul li { float:left; width:26px; height:20px; }
#page_num ul li a { display:block; width:20px; height:20px; line-height:20px; border:1px solid #333; text-align:center; text-decoration:none; }
#page_num ul li a:hover, #page_num ul li a.selected { background:#666; font-weight:bold; color:#fff; }