用于动态显示来自 mysql 的 10 条记录的 PHP 代码

非常广泛的问题，但基础知识是可以使用"LIMIT"MySQL命令解决。 基本上，您的PHP代码会检测某人是否转到了另一个页面，然后在进行查询时，会调整"LIMIT"。 因此，对于第 1 页，此 MySQL 伪代码中的"限制"将是：

SELECT * FROM {my table} WHERE {criteria is this} LIMIT 0,10

对于第 2 页，"限制"将是这样的：

SELECT * FROM {my table} WHERE {criteria is this} LIMIT 11,20

至于PHP分页，你必须想出一些逻辑。 也许（也是最传统地）通过 POST 传递 URL 变量，例如：

http://localhost/index.php?pn=2

然后你的PHP逻辑做一些数学运算来确定范围的开始和结束。 所以在这个例子中，可以做这样的事情：

$pn = $GET['pn'];
$per_page = 10;
$bottom_limit = (($pn*$per_page)-$per_page)+1);
$top_limit = ($pn*$per_page);

然后在PHP中，LIMIT将按以下方式放置：

$limit = " LIMIT " . $bottom_limit . ", " . $top_limit;

页代码如下。

试试吧。

<?php
    include('config.php');  // include your code to connect to DB.
    $tbl_name="";       //your table name
    $adjacents = 3;
    $query = "SELECT COUNT(*) as num FROM $tbl_name";
    $total_pages = mysqli_fetch_array(mysqli_query($query));
    $total_pages = $total_pages[num];

    $targetpage = "filename.php";   //your file name  (the name of this file)
    $limit = 10;                                //how many items to show per page
    $page = $_GET['page'];
    if($page) 
        $start = ($page - 1) * $limit;          //first item to display on this page
    else
        $start = 0;                             //if no page var is given, set start to 0
    /* Get data. */
    $sql = "SELECT column_name FROM $tbl_name LIMIT $start, $limit";
    $result = mysqli_query($sql);
    /* Setup page vars for display. */
    if ($page == 0) $page = 1;                  //if no page var is given, default to 1.
    $prev = $page - 1;                          //previous page is page - 1
    $next = $page + 1;                          //next page is page + 1
    $lastpage = ceil($total_pages/$limit);      //lastpage is = total pages / items per page, rounded up.
    $lpm1 = $lastpage - 1;                      //last page minus 1
    /* 
        Now we apply our rules and draw the pagination object. 
        We're actually saving the code to a variable in case we want to draw it more than once.
    */
    $pagination = "";
    if($lastpage > 1)
    {   
        $pagination .= "<div class='"pagination'">";
        //previous button
        if ($page > 1) 
            $pagination.= "<a href='"$targetpage?page=$prev'">? previous</a>";
        else
            $pagination.= "<span class='"disabled'">? previous</span>"; 
        //pages 
        if ($lastpage < 7 + ($adjacents * 2))    //not enough pages to bother breaking it up
        {   
            for ($counter = 1; $counter <= $lastpage; $counter++)
            {
                if ($counter == $page)
                    $pagination.= "<span class='"current'">$counter</span>";
                else
                    $pagination.= "<a href='"$targetpage?page=$counter'">$counter</a>";                 
            }
        }
        elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some
        {
            //close to beginning; only hide later pages
            if($page < 1 + ($adjacents * 2))     
            {
                for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
                {
                    if ($counter == $page)
                        $pagination.= "<span class='"current'">$counter</span>";
                    else
                        $pagination.= "<a href='"$targetpage?page=$counter'">$counter</a>";                 
                }
                $pagination.= "...";
                $pagination.= "<a href='"$targetpage?page=$lpm1'">$lpm1</a>";
                $pagination.= "<a href='"$targetpage?page=$lastpage'">$lastpage</a>";       
            }
            //in middle; hide some front and some back
            elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
            {
                $pagination.= "<a href='"$targetpage?page=1'">1</a>";
                $pagination.= "<a href='"$targetpage?page=2'">2</a>";
                $pagination.= "...";
                for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
                {
                    if ($counter == $page)
                        $pagination.= "<span class='"current'">$counter</span>";
                    else
                        $pagination.= "<a href='"$targetpage?page=$counter'">$counter</a>";                 
                }
                $pagination.= "...";
                $pagination.= "<a href='"$targetpage?page=$lpm1'">$lpm1</a>";
                $pagination.= "<a href='"$targetpage?page=$lastpage'">$lastpage</a>";       
            }
            //close to end; only hide early pages
            else
            {
                $pagination.= "<a href='"$targetpage?page=1'">1</a>";
                $pagination.= "<a href='"$targetpage?page=2'">2</a>";
                $pagination.= "...";
                for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
                {
                    if ($counter == $page)
                        $pagination.= "<span class='"current'">$counter</span>";
                    else
                        $pagination.= "<a href='"$targetpage?page=$counter'">$counter</a>";                 
                }
            }
        }
        //next button
        if ($page < $counter - 1) 
            $pagination.= "<a href='"$targetpage?page=$next'">next ?</a>";
        else
            $pagination.= "<span class='"disabled'">next ?</span>";
        $pagination.= "</div>'n";     
    }
?>
    <?php
        while($row = mysqli_fetch_array($result))
        {
        // Your while loop here
        }
    ?>
<?=$pagination?>

在查询中使用 LIMIT 语句...。您需要在Php中使用分页。