ikan Uploader :
Directory : /home/ni05r7l36tus/.trash/sabksolutions.com/admin/pages/
Upload File : |
| Current File : /home/ni05r7l36tus/.trash/sabksolutions.com/admin/pages/pegination.php |
<?php
include 'connection/config.php';
$limit = 6;
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$offset = ($page - 1) * $limit;
$total_images_query = $mysqli->query("SELECT COUNT(*) AS total FROM multiple_images");
$total_images_row = $total_images_query->fetch_assoc();//these rows converts associative array
$total_images = $total_images_row['total'];
$total_pages = ceil($total_images / $limit);
$image_query = $mysqli->query("SELECT * FROM multiple_images LIMIT $offset, $limit");
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Paginated Image Gallery</title>
<link href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<div class="container mt-4">
<h2 class="mb-4">Image Gallery</h2>
<div class="d-flex flex-wrap">
<?php while ($image_row = $image_query->fetch_assoc()) { ?>
<div class="m-2">
<img src="upload/<?php echo $image_row['multiple_images']; ?>" class="img-thumbnail" height="150" width="150" />
</div>
<?php } ?>
</div>
<!-- Pagination Controls -->
<nav aria-label="Page navigation" class="mt-4">
<ul class="pagination justify-content-center">
<!-- Previous Button -->
<li class="page-item <?php if ($page <= 1) echo 'disabled'; ?>">
<a class="page-link" href="?page=<?php echo $page - 1; ?>" tabindex="-1">Previous</a>
</li>
<!-- Page Numbers -->
<?php for ($i = 1; $i <= $total_pages; $i++) { ?>
<li class="page-item <?php if ($i == $page) echo 'active'; ?>">
<a class="page-link" href="?page=<?php echo $i; ?>"><?php echo $i; ?></a>
</li>
<?php } ?>
<!-- Next Button -->
<li class="page-item <?php if ($page >= $total_pages) echo 'disabled'; ?>">
<a class="page-link" href="?page=<?php echo $page + 1; ?>">Next</a>
</li>
</ul>
</nav>
</div>
<!-- Bootstrap JS -->
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.5.2/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
........