donpvtzuux37724 2015-07-23 09:21
浏览 168

限制分页页数

I have one page where I echo 10 items from MySql DB and has pagination for next page. The problem is that there are 1000+ rows in database.. so you can guess how many pages are in pagination links. How can I limit their numbers for example to show

1 2 3 4 5 ... N

when user change to page 2

2 3 4 5 6 ... N

and so on?

Or something else.. the main goal is just to hide every single page number.

 <?php
     if (isset($_GET["page"])) { $page = $_GET["page"]; } else { $page=1; };
     $start_from = ($page-1) * 10;
     $result = $pdo->prepare("SELECT t.* FROM images t order by randorder ASC LIMIT $start_from, 10");
     $result->execute();

     for($i=0; $row = $result->fetch(); $i++)
     {                                      
            echo 'echo data';
     }

    echo '<div class="pagination" >';

        $result = $pdo->prepare("SELECT COUNT(image_id) FROM images");
        $result->execute();
        $row = $result->fetch();
        $total_records = $row[0];
        $total_pages = ceil($total_records / 10);

        for ($i=1; $i<=$total_pages; $i++) {
            echo "<a href='?page=".$i."'";
            if($page==$i)
            {
                echo "class=active";
            }
                echo ">";
                echo "".$i."</a> ";
        };
        echo '</div>'; 
?>  
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 Vue3 大型图片数据拖动排序
    • ¥15 划分vlan后不通了
    • ¥15 GDI处理通道视频时总是带有白色锯齿
    • ¥20 用雷电模拟器安装百达屋apk一直闪退
    • ¥15 算能科技20240506咨询(拒绝大模型回答)
    • ¥15 自适应 AR 模型 参数估计Matlab程序
    • ¥100 角动量包络面如何用MATLAB绘制
    • ¥15 merge函数占用内存过大
    • ¥15 使用EMD去噪处理RML2016数据集时候的原理
    • ¥15 神经网络预测均方误差很小 但是图像上看着差别太大