PHPでページネーションを実装する方法

function query($sql, $params = []) { $dsn = "mysql:host=localhost;dbname=mydatabase;charset=utf8mb4"; $username = "myusername"; $password = "mypassword"; $options = [ PDO::ATTR_EMULATE_PREPARES => false, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION ]; try { $pdo = new PDO($dsn, $username, $password, $options); $stmt = $pdo->prepare($sql); $stmt->execute($params); return $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { die("Database error: " . $e->getMessage()); } }

$result = query("SELECT * FROM mytable");

totalPages = ceil(totalItems / pageSize)

$totalItems = count($result); $pageSize = 10; $totalPages = ceil($totalItems / $pageSize);

function getPageData($data, $page, $pageSize) { $start = ($page - 1) * $pageSize; $end = $start + $pageSize; return array_slice($data, $start, $pageSize); }

$data = query("SELECT * FROM mytable"); $pageData = getPageData($data, 2, 10); // 获取第2页，每页显示10条数据

function getPageLinks($currentPage, $totalPages) { $links = []; for ($i = 1; $i <= $totalPages; $i++) { $isActive = $i == $currentPage; $links[] = [ "page" => $i, "isActive" => $isActive, "url" => "?page=$i", ]; } $prevPage = $currentPage - 1; $nextPage = $currentPage + 1; if ($prevPage >= 1) { array_unshift($links, [ "page" => $prevPage, "isActive" => false, "url" => "?page=$prevPage", ]); } if ($nextPage <= $totalPages) { array_push($links, [ "page" => $nextPage, "isActive" => false, "url" => "?page=$nextPage", ]); } return $links; }

$totalPages = ceil($totalItems / $pageSize); $pageLinks = getPageLinks($currentPage, $totalPages);