Home / Questions / 20438
Accepted
Hoose
Asked: 2020-08-13 14:27:43 +0800 CST 2020-08-13 14:27:43 +0800 CST

如何缩短PHP中的分页？

  • 772

我在 PHP 中有一个分页，如下图所示：

分页

但是，当我在数据库中输入更多记录时，页数会增加，因为它每页显示 10 条记录。我希望，例如，在我的分页中，它会显示从 1 到 10，当它达到 10 时，它会显示从 10 到 20 ......我不知道我是否在解释自己。

我留下了我使用的 PHP 代码。

 <nav aria-label="Page navigation" class="text-center">
     <ul class="pagination">
        <?php
        if ($total_paginas > 1) {
           if ($pagina != 1)
              echo '<li><a href="'.$url.'?pagina='.($pagina-1).'" aria-label="Previous"><span aria-hidden="true">&laquo;</span></a></li>';
              for ($i = 1; $i <=$total_paginas; $i++){
                  if ($pagina == $i)
                      echo '<li class="active"><a href="#">'.$pagina.'</a></li>';
                  else
                      echo '<li><a href="'.$url.'?pagina='.$i.'">'.$i.'</a></li>';
              }
              if ($pagina != $total_paginas) {
                 echo '<li><a href="'.$url.'?pagina='.($pagina+1).'"><span aria-hidden="true">&raquo;</span></a></li>';
              }
        }
        ?>
      </ul>
 </nav>
php

3 Answers

  1. Best Answer

    在这里，我会根据您的代码为您提供一个选项，并且对其进行最少的更改。

    这个想法很简单（虽然我不知道我是否会很好地解释它），它包含以下内容：始终显示最多 10 个链接，这些链接将以该单元开头并以所述单元+9（或总数如果 unit+9 是老年人，则为页面）。这意味着对于第 5 页，显示的链接将从 1 到 10；对于第 13 页，链接将从 11 到 20 等。

    为此，有必要： 计算要显示的第一个数字和最后一个数字是多少，并使循环仅在它们之间。然后，在显示箭头时，需要检查第一页是否小于 10（在这种情况下，左侧的箭头不会显示）或者最后一页是否等于总页数（在在这种情况下不会显示）。向右的箭头）。

    这是如何完成的示例：

    注意-我（几乎）相信您可以以某种方式简化第一个和最后一个的计算，但是我的大脑现在被炸了（我最初有一个超级复杂的计算并将其缩小到这个范围）

    <?php
// calculamos la primera y última página a mostrar
$primera = $pagina - ($pagina % 10) + 1;
if ($primera > $pagina) { $primera = $primera - 10; }
$ultima = $primera + 9 > $total_paginas ? $total_paginas : $primera + 9; 
?>
<nav aria-label="Page navigation" class="text-center">
     <ul class="pagination">
        <?php
        if ($total_paginas > 1) {
            // comprobamos $primera en lugar de $pagina
            if ($primera != 1)
                echo '<li><a href="'.$url.'?pagina='.($primera-1).'" aria-label="Previous"><span aria-hidden="true">&laquo;</span></a></li>';

            // mostramos de la primera a la última
            for ($i = $primera; $i <=$ultima; $i++){
                if ($pagina == $i)
                    echo '<li class="active"><a href="#">'.$pagina.'</a></li>';
                else
                    echo '<li><a href="'.$url.'?pagina='.$i.'">'.$i.'</a></li>';
            }

            if ($i <= $total_paginas)
                echo '<li><a href="'.$url.'?pagina='.($i).'"><span aria-hidden="true">&raquo;</span></a></li>';
        }
        ?>
      </ul>
</nav>
    • 6

  2. 做一些类似于 Alvaro 所做的事情，以您的代码为基础，这是一个略有不同的版本，目标是：

    • 显示当前页之前的 5 页和后面的 5 页
    • 如果不在前一组中，则显示第一页
    • 如果不在第一个点的组中，则显示最后一页

    这个答案的想法是为“将来”遇到这个问题的人添加一个选项。

    $primera = ($pagina - 5) > 1 ? $pagina - 5 : 1;
$ultima = ($pagina + 5) < $total_paginas ? $pagina + 5 : $total_paginas;

if ($total_paginas > 1) {

    // flecha anterior
    if ($pagina != 1) {
        echo '<li><a href="'.$url.'?pagina='.($pagina-1).'" aria-label="Previous"><span aria-hidden="true">&laquo;</span></a></li>';
    }

    // si la primera del grupo no es la pagina 1, mostramos la 1 y los ...
    if ($primera != 1) {
        echo '<li><a href="'.$url.'?pagina=1">'.$i.'</a></li>';
        echo '<li>...</li>';
    }

    // mostramos la página actual, las 5 anteriores y las 5 posteriores
    for ($i = $primera; $i <= $ultima; $i++){
        if ($pagina == $i)
            echo '<li class="active"><a href="#">'.$pagina.'</a></li>';
        else
            echo '<li><a href="'.$url.'?pagina='.$i.'">'.$i.'</a></li>';
    }

    // si la ultima del grupo no es la ultima (lol), mostramos la ultima y los ...
    if ($ultima != $total_paginas) {
        echo '<li>...</li>';
        echo '<li><a href="'.$url.'?pagina='.$total_paginas.'">'.$i.'</a></li>';
    }

    // flecha siguiente
    if ($pagina != $total_paginas) {
        echo '<li><a href="'.$url.'?pagina='.($pagina+1).'"><span aria-hidden="true">&raquo;</span></a></li>';
    }

}
    • 3

  3. 同样是改变一点你现在使用的概念。我这样做的方式是分页在一个类中完成，然后在 中完成PHP，我称之为分页。

    我有这个文件用于连接，但是如果你在互联网上搜索，PDO你肯定会找到它mysqlmysqli

    分页.php

    class PDO_Pagination
{
  public $connection;
      public $total;
      public $page;
      public $total_page;
      public $start_row;
      public $item;
      public $max_pages;
      public $max_rows;
      public $step;
      public $max;
      public $param;
      public $btn_first_page;
      public $btn_last_page;
      public $btn_next_page;
      public $btn_back_page;
      public $btn_page;
      public $btn_active;

      public function __construct($connection) {
      $this->btn_first_page = 'Previous';
      $this->btn_last_page = 'Last';
      $this->btn_next_page = 'Next';
      $this->btn_back_page = 'Back';
      $this->btn_page = 'Pag.';
      $this->btn_active = 'active';
      return $this->connection = $connection;
  }

  public function rowCount($query){
      $query = $this->connection->prepare($query);
      $query->execute();
      $this->total = $query->rowCount();
  }

      public function config($max_pages, $max_rows){
      $this->start_row = 0;
      $this->item = 0;
      $this->max_pages = $max_pages;
      $this->max_rows = $max_rows;
      $this->total_page = $this->total / $this->max_rows;

      if (isset($_GET["page"])){
          $this->page = $_GET["page"];
          if ($this->page < 0 || !preg_match("/^([0-9])+$/", $this->page)){
              return;
          }

          $this->start_row = $this->page * $this->max_rows;

          $this->item = $_GET["item"];
          if ($this->item < 0  || !preg_match("/^([0-9])+$/", $this->item)){
              return;
          }

          $this->max_pages = $this->max_pages + $this->max_rows;

          $this->max = $_GET["max"];
          if ($this->max < 0  || !preg_match("/^([0-9])+$/", $this->max)){
              return;
          }
          $this->max_pages = $this->max;
      }


      if(isset($_GET["next_page"])){
          $this->page = $_GET["next_page"];
          if ($this->page < 0  || !preg_match("/^([0-9])+$/", $this->page)){
              return;
          }

          $this->start_row = $this->page * $this->max_rows;

          $this->item = $_GET["item"];
          if ($this->item < 0  || !preg_match("/^([0-9])+$/", $this->item)){
              return;
          }

          $this->max = $_GET["max"];
          if ($this->max < 0  || !preg_match("/^([0-9])+$/", $this->max)){
              return;
          }
              $this->max_pages = $this->max + 1;
          }

          if(isset($_GET["back_page"])){
          $this->page = $_GET["back_page"] - 1;
          if ($this->page < 0  || !preg_match("/^([0-9])+$/", $this->page)){
              return;
          }
          $this->start_row = $this->page * $this->max_rows;

          $this->item = $_GET["item"] - 1;
          if ($this->item < 0  || !preg_match("/^([0-9])+$/", $this->item)){
              return;
          }

          $this->max = $_GET["max"];
              if ($this->max < 0  || !preg_match("/^([0-9])+$/", $this->max)){
              return;
          }

          $this->max_pages = $this->max - 1;
      }

          if (isset($_GET["previous"])){
          $this->max_pages = $this->max_pages;
          $this->start_row=0;
          $this->item = 0;
      }
  }

  public function pages($class=''){

  if($this->item >= 1){
          echo "<a class='$class'  href='?previous=1".$this->param."'>$this->btn_first_page</a>";
          echo "<a class='$class'  href='?back_page=$this->page&item=$this->item&max=$this->max_pages".$this->param."'>$this->btn_back_page</a>";
      }
      for($x = $this->item; $x < $this->max_pages; $x++){
      while($x * $this->max_rows < $this->total){
          $p = $x+1;
          $this->page == $p-1 ? $active = ' ' . $this->btn_active : $active = null;
          echo "<a class='$class$active' href='?page=$x&item=$this->item&max=$this->max_pages".$this->param."'>$p</a>";
          break;
      }
  }

      $numbers = $this->page+1;
      echo "<span class='$class'>$this->btn_page <b>$numbers</b></span>";

      if ($this->max_pages * $this->max_rows < $this->total){
      $this->page = $this->page+1;
      $this->item = $this->item + 1;
      echo "<a class='$class' href='?next_page=$this->page&item=$this->item&max=$this->max_pages".$this->param."'>$this->btn_next_page</a>";

      $this->page = round($this->total_page - 1);
      $this->item = round($this->total_page - $this->max_pages);
      $this->max = round($this->total_page);
      echo "<a class='$class'  href='?page=$this->page&item=$this->item&max=$this->max".$this->param."'>$this->btn_last_page</a>";
  }
  }
}

    代码中的调用将是：

    <?php
$connection = dbConnect ();
$pagination = new PDO_Pagination($connection);
$pagination->rowCount("SELECT * FROM noticias WHERE publicado=1");
$pagination->config(5, 30); 
$sql = "SELECT * FROM noticias WHERE publicado=1 ORDER BY fecha DESC LIMIT $pagination->start_row,
$pagination->max_rows";
$query = $connection->prepare($sql);
$query->execute();
$model = array();
while($rows = $query->fetch())
 {
  $model[] = $rows;
}
 foreach($model as $row){
  echo "<li class='li_noticias'>";
  echo "<a href='".$row['idref'].".html' rel='follow'>";
  //echo "<a href='noticias2.php?ref=".$row['idref']."' rel='follow'>";
   echo $row['titulo'];
   echo "</a>";
   echo "</li>";
 }
?>
    • 0