📁 File Manager
Editing:
/home/wedigitalindia/public_html/jaybalajiassociates.com/blogs.php
<?php include_once('include/header.php'); /* ========================= PAGINATION CONFIG ========================= */ $limit = 6; // blogs per page $page = isset($_GET['page']) && is_numeric($_GET['page']) ? (int)$_GET['page'] : 1; $page = max($page, 1); $offset = ($page - 1) * $limit; /* ========================= TOTAL BLOG COUNT ========================= */ $countResult = mysqli_query($con, "SELECT COUNT(*) AS total FROM blog"); $countRow = mysqli_fetch_assoc($countResult); $totalBlogs = $countRow['total']; if ($totalBlogs == 0) { include '404.php'; exit; } $totalPages = ceil($totalBlogs / $limit); /* ========================= FETCH BLOGS ========================= */ $blogs = mysqli_query( $con, "SELECT * FROM blog ORDER BY id DESC LIMIT $limit OFFSET $offset" ); ?> <div class="page-header parallaxie"> <div class="container"> <div class="row"> <div class="col-md-12"> <div class="page-header-box"> <h1 class="text-anime">All Blogs</h1> <nav class="wow fadeInUp" data-wow-delay="0.25s"> <ol class="breadcrumb"> <li class="breadcrumb-item"> <a href="<?php path(); ?>">Home ></a> </li> <li class="breadcrumb-item"> <a href="<?php path(); ?>blogs">All Blogs</a> </li> </ol> </nav> </div> </div> </div> </div> </div> <!-- Blog Archive Page Start --> <div class="page-blog-archive"> <div class="container"> <div class="row"> <?php while ($blog = mysqli_fetch_assoc($blogs)): ?> <div class="col-lg-4 col-md-6"> <a href="<?php path(); ?>blog/<?php echo htmlspecialchars($blog['slug']); ?>"> <div class="blog-item wow fadeInUp" data-wow-delay="0.25s"> <div class="post-featured-image"> <figure class="image-anime"> <img src="<?php path(); ?>admin/assets/images/blog/<?php echo htmlspecialchars($blog['Image']); ?>" alt="<?php echo htmlspecialchars($blog['title']); ?>"> </figure> </div> <div class="post-item-body"> <h2><?php echo htmlspecialchars($blog['title']); ?></h2> <div class="btn-readmore"> <span class="btn-default">Read More</span> </div> </div> </div> </a> </div> <?php endwhile; ?> </div> <!-- Pagination --> <?php if ($totalPages > 1): ?> <div class="row"> <div class="col-md-12"> <div class="post-pagination wow fadeInUp" data-wow-delay="1.50s"> <ul class="pagination"> <!-- Previous --> <?php if ($page > 1): ?> <li> <a href="?page=<?php echo $page - 1; ?>"> <i class="fa-solid fa-arrow-left-long"></i> </a> </li> <?php endif; ?> <!-- Page Numbers --> <?php for ($i = 1; $i <= $totalPages; $i++): ?> <li class="<?php echo ($i == $page) ? 'active' : ''; ?>"> <a href="?page=<?php echo $i; ?>"> <?php echo $i; ?> </a> </li> <?php endfor; ?> <!-- Next --> <?php if ($page < $totalPages): ?> <li> <a href="?page=<?php echo $page + 1; ?>"> <i class="fa-solid fa-arrow-right-long"></i> </a> </li> <?php endif; ?> </ul> </div> </div> </div> <?php endif; ?> </div> </div> <!-- Blog Archive Page End --> <?php include_once('include/footer.php'); ?>
Save
Cancel