我正在努力理解使用php和mysql实现分页的最佳方法。我有下面的代码，我曾试图显示前5个按钮，例如1-5，但我想一个“下一个按钮”，然后显示5-10，然后10-15等。非常感谢您的帮助。

$q=mysql_query("SELECT * FROM posts WHERE $ctq approved=1 Limit 15");
$pages = ceil(mysql_num_rows($q)/$item_per_page)+1; 

//create pagination
if($pages > 0)
{
    for($i = 1; $i<$pages; $i++)
    {
        $pagination .= '<a href="#" id="'.$i.'-page" class="inactive paginate_click">'.$i.'</a>';
    }
}

$ctajax='';
if(isset($_GET['cat_id']) && !empty($_GET['cat_id'])){
   $ctajax.=",'cat_id':".$_GET['cat_id'];
}
?>

<script type="text/javascript">
jQuery(document).ready(function($) {
    $("#results").load("fetch_pages.php", {'page':0<?php echo $ctajax ?>}, function() {
        $("#1-page").removeClass('inactive').addClass('current');
    });  

    //initial page number to load
    $(".paginate_click").click(function (e) {

        $("#results").prepend('<div class="loading-indication"><img src="ajax-loader.gif" /> Loading...</div>');

        var clicked_id = $(this).attr("id").split("-"); //ID of clicked element, split() to get page number.
        var page_num = parseInt(clicked_id[0]); //clicked_id[0] holds the page number we need 
        $('.paginate_click').addClass('inactive');
        $('.paginate_click').removeClass('current'); //remove any active class

        //post page number and load returned data into result element
        //notice (page_num-1), subtract 1 to get actual starting point
        $("#results").load("fetch_pages.php", {'page':(page_num-1)}, function(){

        });

        $(this).addClass('current'); //add active class to currently clicked element (style purpose)

        return false; //prevent going to herf link
    }); 
});
</script> 

    <div id="results"></div>

    <nav role="navigation" id="nav-below" class="site-navigation paging-navigation clearfix">
        <div class="pagination">
            <?php echo $pagination; ?>
            <a href="#" id="<?php echo $iadd;?>-page" class="inactive paginate_click">Next</a>
        </div>                                              
    </nav>
    <?php } ?>
    <!-- #nav-below --> 
</section>
<!-- /#content -->