ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/customer-list.php |
<?php
// Enable error reporting in development (disable in production)
ini_set('display_errors', 1);
error_reporting(E_ALL);
// Database configuration
$host = 'localhost';
$db = 'poojajeweller';
$user = 'poojajeweller_user';
$pass = 'Poojajeweller@12345#';
$charset = 'utf8mb4';
// Data Source Name (DSN)
$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
// PDO options
$options = [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false,
];
try {
$pdo = new PDO($dsn, $user, $pass, $options);
// Fetch customers
$stmt = $pdo->query("SELECT * FROM customers ORDER BY created_at DESC");
$customers = $stmt->fetchAll();
} catch (PDOException $e) {
die("Database connection failed: " . htmlspecialchars($e->getMessage()));
}
?>
<?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="add_customer.php" class="btn btn-sm btn-primary">
Add Customers
</a>
</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>Customer Name</th>
<th>Email</th>
<th>Phone</th>
<th>Password</th>
<th>Status</th>
<th>Created At</th>
<th>Updated At</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php if ($customers): ?>
<?php foreach ($customers as $index => $customer): ?>
<tr>
<td><?= $index + 1 ?></td>
<td><?= htmlspecialchars($customer['first_name'] . ' ' . $customer['last_name']) ?></td>
<td><?= htmlspecialchars($customer['email']) ?></td>
<td><?= htmlspecialchars($customer['phone']) ?></td>
<td>******</td> <!-- Hide real password -->
<td>
<?php if ($customer['status'] === 'active'): ?>
<span class="badge bg-success-subtle text-success py-1 px-2">Active</span>
<?php else: ?>
<span class="badge bg-danger-subtle text-danger py-1 px-2">Inactive</span>
<?php endif; ?>
</td>
<td><?= date("d M, Y", strtotime($customer['created_at'])) ?></td>
<td><?= date("d M, Y", strtotime($customer['updated_at'])) ?></td>
<td>
<div class="d-flex gap-2">
<a href="view_customer.php?id=<?= $customer['customer_id'] ?>" class="btn btn-light btn-sm">
<iconify-icon icon="solar:eye-broken" class="align-middle fs-18"></iconify-icon>
</a>
<a href="edit_customer.php?id=<?= $customer['customer_id'] ?>" class="btn btn-soft-primary btn-sm">
<iconify-icon icon="solar:pen-2-broken" class="align-middle fs-18"></iconify-icon>
</a>
<a href="delete_customer.php?id=<?= $customer['customer_id'] ?>" class="btn btn-soft-danger btn-sm" onclick="return confirm('Are you sure to delete this customer?');">
<iconify-icon icon="solar:trash-bin-minimalistic-2-broken" class="align-middle fs-18"></iconify-icon>
</a>
</div>
</td>
</tr>
<?php endforeach; ?>
<?php else: ?>
<tr>
<td colspan="9" class="text-center text-muted">No customers found</td>
</tr>
<?php endif; ?>
</tbody>
</table>
</div>
</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>
........