ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/offer.php |
<?php include "common/header.php" ?>
<?php
include 'connection/config.php';
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['save_offer'])) {
$title = trim($_POST['title']);
$description = trim($_POST['description']);
// Keep old image path
$imagePath = $_POST['old_image'] ?? '';
// Handle image upload
if (isset($_FILES['image']) && $_FILES['image']['error'] === UPLOAD_ERR_OK) {
$uploadDir = '../uploads/offers/';
if (!is_dir($uploadDir)) mkdir($uploadDir, 0755, true);
$fileName = time() . '_' . basename($_FILES['image']['name']);
$targetFile = $uploadDir . $fileName;
if (move_uploaded_file($_FILES['image']['tmp_name'], $targetFile)) {
// Delete old image if exists
if (!empty($imagePath) && file_exists('../' . $imagePath)) {
unlink('../' . $imagePath);
}
$imagePath = 'uploads/offers/' . $fileName;
}
}
if (!empty($title) && !empty($description)) {
try {
if (!empty($_POST['id'])) {
// UPDATE
$stmt = $pdo->prepare("UPDATE offer SET title = :title, description = :description, image = :image WHERE id = :id");
$stmt->execute([
'title' => $title,
'description' => $description,
'image' => $imagePath,
'id' => $_POST['id']
]);
echo "<script>
localStorage.setItem('swal_message', 'updated');
window.location.href='offer.php';
</script>";
exit;
} else {
// INSERT
$stmt = $pdo->prepare("INSERT INTO offer (title, description, image) VALUES (:title, :description, :image)");
$stmt->execute([
'title' => $title,
'description' => $description,
'image' => $imagePath
]);
echo "<script>
localStorage.setItem('swal_message', 'added');
window.location.href='offer.php';
</script>";
exit;
}
} catch (PDOException $e) {
echo "<script>
localStorage.setItem('swal_message', 'error');
window.location.href='offer.php';
</script>";
exit;
}
} else {
echo "<script>
localStorage.setItem('swal_message', 'empty');
window.location.href='offer.php';
</script>";
exit;
}
}
// ---------- DELETE ----------
if (isset($_GET['delete'])) {
$id = (int) $_GET['delete'];
$pdo->prepare("DELETE FROM offer WHERE id = :id")->execute(['id' => $id]);
echo "<script>
localStorage.setItem('swal_message', 'deleted');
window.location.href='offer.php';
</script>";
exit;
}
// ---------- EDIT ----------
$editOffer = null;
if (isset($_GET['edit'])) {
$id = (int) $_GET['edit'];
$stmt = $pdo->prepare("SELECT * FROM offer WHERE id = :id");
$stmt->execute(['id' => $id]);
$editOffer = $stmt->fetch();
}
// ---------- READ ----------
$stmt = $pdo->query("SELECT * FROM offer ORDER BY id ASC");
$offers = $stmt->fetchAll();
?>
<div class="page-content">
<div class="container-xxl">
<!-- Offer Form -->
<form method="POST" action="" enctype="multipart/form-data">
<input type="hidden" name="old_image" value="<?= htmlspecialchars($editOffer['image'] ?? '') ?>">
<div class="row">
<div class="col-xl-12">
<div class="card">
<div class="card-header">
<h4 class="card-title"><?= $editOffer ? "Edit Offer" : "Add New Offer" ?></h4>
</div>
<div class="card-body">
<input type="hidden" name="id" value="<?= $editOffer['id'] ?? '' ?>">
<!-- Title -->
<div class="mb-3">
<label class="form-label">Offer Title</label>
<input type="text" class="form-control" name="title" placeholder="Enter Offer Title" required
value="<?= htmlspecialchars($editOffer['title'] ?? '') ?>">
</div>
<!-- Description -->
<div class="mb-3">
<label class="form-label">Description</label>
<textarea class="form-control" name="description" rows="4" placeholder="Enter Description" required><?= htmlspecialchars($editOffer['description'] ?? '') ?></textarea>
</div>
<!-- Image -->
<div class="mb-3">
<label class="form-label">Image</label>
<input type="file" name="image" id="imageInput" class="form-control" accept="image/*">
<div class="mt-2">
<img id="imagePreview" src="../<?= isset($editOffer['image']) ? htmlspecialchars($editOffer['image']) : '' ?>"
alt="Preview" style="max-width:150px; border-radius:8px; margin-top:10px; <?= isset($editOffer['image']) ? '' : 'display:none;' ?>">
</div>
</div>
<div class="mt-3">
<button type="submit" name="save_offer" class="btn btn-primary"><?= $editOffer ? "Update Offer" : "Save Offer" ?></button>
<a href="offer.php" class="btn btn-secondary">Back to List</a>
</div>
</div>
</div>
</div>
</div>
</form>
<!-- Offer List -->
<div class="row">
<div class="col-xl-12">
<div class="card">
<div class="card-header">
<h4 class="card-title">All Offers</h4>
</div>
<div class="card-body">
<div class="table-responsive">
<table class="table align-middle mb-0 table-hover table-centered">
<thead class="bg-light-subtle">
<tr>
<th>ID</th>
<th>Title</th>
<th>Description</th>
<th>Image</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<?php if ($offers): ?>
<?php foreach ($offers as $offer): ?>
<tr>
<td><?= htmlspecialchars($offer['id']) ?></td>
<td><?= htmlspecialchars($offer['title']) ?></td>
<td><?= htmlspecialchars($offer['description']) ?></td>
<td>
<?php if($offer['image']): ?>
<img src="../<?= htmlspecialchars($offer['image']) ?>" style="max-width:80px; border-radius:4px;">
<?php endif; ?>
</td>
<td>
<div class="d-flex gap-2">
<a href="offer.php?edit=<?= $offer['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="offer.php?delete=<?= $offer['id'] ?>"
onclick="return confirm('Are you sure you want to delete this offer?');"
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="5" class="text-center">No offers found.</td>
</tr>
<?php endif; ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include "common/footer.php" ?>
</div>
<!-- SweetAlert -->
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
<script>
document.addEventListener("DOMContentLoaded", function() {
const swalMsg = localStorage.getItem("swal_message");
if (swalMsg) {
if (swalMsg === "added") Swal.fire("Success!", "Offer added successfully!", "success");
else if (swalMsg === "updated") Swal.fire("Success!", "Offer updated successfully!", "success");
else if (swalMsg === "deleted") Swal.fire("Deleted!", "Offer deleted successfully!", "success");
else if (swalMsg === "empty") Swal.fire("Oops!", "Please fill all fields.", "warning");
else if (swalMsg === "error") Swal.fire("Error!", "Something went wrong.", "error");
localStorage.removeItem("swal_message");
}
// Image preview
const imageInput = document.getElementById('imageInput');
const imagePreview = document.getElementById('imagePreview');
imageInput.addEventListener('change', function(event) {
const file = event.target.files[0];
if (file) {
const reader = new FileReader();
reader.onload = function(e) {
imagePreview.src = e.target.result;
imagePreview.style.display = 'block';
}
reader.readAsDataURL(file);
} else {
imagePreview.src = '';
imagePreview.style.display = 'none';
}
});
});
</script>
<!-- Vendor Javascript -->
<script src="assets/js/vendor.js"></script>
<script src="assets/js/app.js"></script>
</body>
</html>
........