最新php分页类

<?php
class Paginator {
    private $totalRows;
    private $rowsPerPage;
    private $currentPage;

    public function __construct($totalRows, $rowsPerPage = 10) {
        $this->totalRows = $totalRows;
        $this->rowsPerPage = $rowsPerPage;
        $this->currentPage = isset($_GET['page']) ? intval($_GET['page']) : 1;
    }

    public function getOffset() {
        return ($this->currentPage - 1) * $this->rowsPerPage;
    }

    public function getTotalPages() {
        return ceil($this->totalRows / $this->rowsPerPage);
    }

    public function getCurrentPage() {
        return $this->currentPage;
    }

    public function getPrevPage() {
        return $this->currentPage > 1 ? $this->currentPage - 1 : null;
    }

    public function getNextPage() {
        return $this->currentPage < $this->getTotalPages() ? $this->currentPage + 1 : null;
    }
}

// 示例用法
$totalRows = 100; // 总行数
$paginator = new Paginator($totalRows, 10); // 每页显示10行

$offset = $Paginator->getOffset();
$totalPages = $Paginator->getTotalPages();
$current_page = $Paginator->getCurrentPage();
$prev_page = $Paginator->getPrevPage();
$next_page = $Paginator->getNextPage();

echo "当前页: $current_page / 总页数: $totalPages<br>";
echo "上一页: $prev_page<br>";
echo "下一页: $next_page<br>";

// 数据库查询示例
$sql = "SELECT * FROM table_name LIMIT $offset, $Paginator->rowsPerPage";
$result = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_assoc($result)) {
    echo $row['column_name'] . "<br>";
}
?>