<?php include "common/header.php" ?>
<!-- ==================================================== -->
<!-- Start right Content here -->
<!-- ==================================================== -->
<div class="page-content">
<!-- Start Container Fluid -->
<div class="container-xxl">
<div class="row">
<div class="col-xl-12">
<div class="card">
<div class="d-flex card-header justify-content-between align-items-center">
<div>
<h4 class="card-title">All Customers List</h4>
</div>
<div class="dropdown">
<a href="#" class="dropdown-toggle btn btn-sm btn-outline-light rounded" data-bs-toggle="dropdown" aria-expanded="false">
This Month
</a>
<div class="dropdown-menu dropdown-menu-end">
<!-- item-->
<a href="#!" class="dropdown-item">Download</a>
<!-- item-->
<a href="#!" class="dropdown-item">Export</a>
<!-- item-->
<a href="#!" class="dropdown-item">Import</a>
</div>
</div>
</div>
<div>
<div class="table-responsive">
<table class="table align-middle mb-0 table-hover table-centered">
<thead class="bg-light-subtle">
<tr>
<th>sl no</th>
<th>Image</th>
<th>Title</th>
<th>Publish Date</th>
<th>Author</th>
<th>Created At</th>
<th>Updated At</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
include 'connection/config.php';
try {
$stmt = $pdo->prepare("SELECT * FROM blog ORDER BY id DESC");
$stmt->execute();
$blogs = $stmt->fetchAll(PDO::FETCH_ASSOC);
$i = 0;
foreach ($blogs as $blog) {
$i++;
?>
<tr>
<td><?php echo $i; ?></td>
<td><img src="../uploads/blog/<?php echo htmlspecialchars($blog['image']); ?>" alt="blog Image" height="40"></td>
<td><?php echo htmlspecialchars($blog['title']); ?></td>
<td><?php echo htmlspecialchars($blog['publish_date']); ?></td>
<td> <?php echo htmlspecialchars($blog['author']); ?></td>
<td><?php echo htmlspecialchars($blog['created_at']); ?></td>
<td><?php echo htmlspecialchars($blog['updated_at']); ?></td>
<td>
<div class="d-flex gap-2">
<a href="add_blog.php?id=<?= $blog['id'] ?>&action=edit_blog" class="btn btn-soft-primary btn-sm">
<iconify-icon icon="solar:pen-2-broken" class="align-middle fs-18"></iconify-icon>
</a>
<a href="function.php?delete_blog=<?= $blog['id'] ?>&redirect=blog.php"
onclick="return confirm('Are you sure you want to delete this record?')"
class="btn btn-soft-danger btn-sm">
<iconify-icon icon="solar:trash-bin-minimalistic-2-broken" class="align-middle fs-18"></iconify-icon>
</a>
</div>
</td>
</tr>
<?php
}
} catch (PDOException $e) {
echo "<tr><td colspan='4'>Error: " . htmlspecialchars($e->getMessage()) . "</td></tr>";
}
?>
</tbody>
</table>
</div>
<!-- end table-responsive -->
</div>
<div class="card-footer border-top">
<nav aria-label="Page navigation example">
<ul class="pagination justify-content-end mb-0">
<li class="page-item"><a class="page-link" href="javascript:void(0);">Previous</a></li>
<li class="page-item active"><a class="page-link" href="javascript:void(0);">1</a></li>
<li class="page-item"><a class="page-link" href="javascript:void(0);">2</a></li>
<li class="page-item"><a class="page-link" href="javascript:void(0);">3</a></li>
<li class="page-item"><a class="page-link" href="javascript:void(0);">Next</a></li>
</ul>
</nav>
</div>
</div>
</div>
</div>
</div>
<!-- End Container Fluid -->
<!-- ========== Footer Start ========== -->
<?php include "common/footer.php" ?>
<!-- ========== Footer End ========== -->
</div>
<!-- ==================================================== -->
<!-- End Page Content -->
<!-- ==================================================== -->
</div>
<!-- END Wrapper -->
<!-- Vendor Javascript (Require in all Page) -->
<script src="assets/js/vendor.js"></script>
<!-- App Javascript (Require in all Page) -->
<script src="assets/js/app.js"></script>
</body>
<!-- Mirrored from techzaa.in/larkon/admin/customer-list.html by HTTrack Website Copier/3.x [XR&CO'2014], Mon, 18 Aug 2025 09:05:12 GMT -->
</html>