pagination

<?php

        $limit = 5;
        $totalBooks = count($books);
        $totalPages = ceil($totalBooks / $limit);

        $currentPage = isset($_GET['page']) ? $_GET['page'] : 1;
        $offset = ($currentPage - 1) * $limit;

        // Modified query with pagination
        $queryBook = mysqli_query($conn, "SELECT * FROM books LIMIT $limit OFFSET $offset");

        // Reset $books array before fetching paginated data
        $books = [];
        while ($book = mysqli_fetch_assoc($queryBook)) {
            $books[] = $book;
        }
        
?>    
        
         <!-- Pagination Controls -->
        <nav aria-label="Page navigation">
            <ul class="pagination">
                <?php for ($page = 1; $page <= $totalPages; $page++) : ?>
                    <li class="page-item <?php if ($page == $currentPage) echo 'active'; ?>">
                            <a class="page-link" href="?page=<?= $page; ?>"><?= $page; ?></a>
                    </li>
                <?php endfor; ?>
            </ul>
        </nav>