ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/products_gender.php |
<?php include "common/header.php" ?>
<?php
include 'connection/config.php';
$message = "";
$swal = "";
// ---------- CREATE / UPDATE ----------
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['save_gender'])) {
$gender_name = trim($_POST['gender_name']);
if (!empty($gender_name)) {
try {
if (!empty($_POST['id'])) {
// ---------- UPDATE ----------
$stmt = $pdo->prepare("UPDATE products_gender SET gender_name = :gender_name WHERE id = :id");
$stmt->execute(['gender_name' => $gender_name, 'id' => $_POST['id']]);
$swal = "Swal.fire('Success','Gender updated successfully!','success').then(()=>{ window.location='products_gender.php'; });";
} else {
// ---------- INSERT ----------
$stmt = $pdo->prepare("INSERT INTO products_gender (gender_name) VALUES (:gender_name)");
$stmt->execute(['gender_name' => $gender_name]);
$swal = "Swal.fire('Success','Gender added successfully!','success').then(()=>{ window.location='products_gender.php'; });";
}
} catch (PDOException $e) {
if ($e->getCode() == 23000) {
$swal = "Swal.fire('Error','This gender already exists.','error');";
} else {
$swal = "Swal.fire('Error','" . htmlspecialchars($e->getMessage()) . "','error');";
}
}
} else {
$swal = "Swal.fire('Warning','Please enter a gender name.','warning');";
}
}
// ---------- DELETE ----------
if (isset($_GET['delete'])) {
$id = (int) $_GET['delete'];
$pdo->prepare("DELETE FROM products_gender WHERE id = :id")->execute(['id' => $id]);
$swal = "Swal.fire('Deleted!','Gender deleted successfully!','success').then(()=>{ window.location='products_gender.php'; });";
}
// ---------- EDIT (Fetch Data for Form) ----------
$editGender = null;
if (isset($_GET['edit'])) {
$id = (int) $_GET['edit'];
$stmt = $pdo->prepare("SELECT * FROM products_gender WHERE id = :id");
$stmt->execute(['id' => $id]);
$editGender = $stmt->fetch();
}
// ---------- READ (List) ----------
$stmt = $pdo->query("SELECT * FROM products_gender ORDER BY id ASC");
$genders = $stmt->fetchAll();
?>
<!-- ==================================================== -->
<!-- Start right Content here -->
<!-- ==================================================== -->
<div class="page-content">
<!-- Start Container Fluid -->
<div class="container-xxl">
<form method="POST" action="">
<div class="row">
<div class="col-xl-12 col-lg-12">
<div class="card">
<div class="card-header">
<h4 class="card-title"><?= $editGender ? "Edit Gender" : "General Information" ?></h4>
</div>
<div class="card-body">
<!-- Removed old alert divs, SweetAlert will handle -->
<div class="row">
<div class="col-lg-6">
<input type="hidden" name="id" value="<?= $editGender['id'] ?? '' ?>">
<div class="mb-3">
<label for="gender-title" class="form-label">Gender Name</label>
<input type="text" id="gender-title" class="form-control" name="gender_name" placeholder="Enter Gender" required value="<?= htmlspecialchars($editGender['gender_name'] ?? '') ?>">
</div>
<button type="submit" name="save_gender" class="btn btn-primary">
<?= $editGender ? "Update Gender" : "Save Gender" ?>
</button>
<a href="products_gender.php" class="btn btn-secondary">Back to List</a>
</div>
</div>
</div>
</div>
</div>
</div>
</form>
<div class="row">
<div class="col-xl-12">
<div class="card">
<div class="card-header d-flex justify-content-between align-items-center gap-1">
<h4 class="card-title flex-grow-1">All Genders List</h4>
<a href="products_gender.php" class="btn btn-sm btn-primary">
Add Gender
</a>
</div>
<div>
<div class="table-responsive">
<table class="table align-middle mb-0 table-hover table-centered">
<thead class="bg-light-subtle">
<tr>
<th style="width: 20px;">
<div class="form-check">
<input type="checkbox" class="form-check-input" id="customCheck1">
</div>
</th>
<th>ID</th>
<th>Gender Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<?php if ($genders): ?>
<?php foreach ($genders as $row): ?>
<tr>
<td>
<div class="form-check">
<input type="checkbox" class="form-check-input" id="check<?= $row['id'] ?>">
</div>
</td>
<td><?= htmlspecialchars($row['id']) ?></td>
<td><?= htmlspecialchars($row['gender_name']) ?></td>
<td>
<div class="d-flex gap-2">
<a href="products_gender.php?edit=<?= $row['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="products_gender.php?delete=<?= $row['id'] ?>"
onclick="return confirm('Are you sure you want to delete this gender?');"
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 endforeach; ?>
<?php else: ?>
<tr>
<td colspan="4" class="text-center">No genders found.</td>
</tr>
<?php endif; ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- End Container Fluid -->
<!-- ========== Footer Start ========== -->
<?php include "common/footer.php" ?>
<!-- ========== Footer End ========== -->
</div>
<!-- ==================================================== -->
<!-- End Page Content -->
<!-- ==================================================== -->
</div>
<!-- END Wrapper -->
<!-- SweetAlert2 -->
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
<!-- Vendor Javascript -->
<script src="assets/js/vendor.js"></script>
<!-- App Javascript -->
<script src="assets/js/app.js"></script>
<?php if (!empty($swal)): ?>
<script>
document.addEventListener("DOMContentLoaded", function() {
<?= $swal ?>
});
</script>
<?php endif; ?>
</body>
</html>
........