File Manager

Editing:edit-local-tour.php

<?php
include 'auth.php';
include '../includes/header.php';

$id = (int)$_GET['id'];
$tour = $conn->query("SELECT * FROM local_tours WHERE id = $id")->fetch_assoc();
$gallery = $conn->query("SELECT * FROM local_tour_gallery WHERE tour_id = $id");

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $title = sanitize($conn, $_POST['title']);
    $location = sanitize($conn, $_POST['location']);
    $description = sanitize($conn, $_POST['description']);
    $price = (float)$_POST['price'];

$update_fields = [
        "title = '$title'",
        "location = '$location'",
        "description = '$description'",
        "price = $price"
    ];

if (!empty($_FILES['main_image']['name'])) {
        $main_image = time() . '_' . $_FILES['main_image']['name'];
        move_uploaded_file($_FILES['main_image']['tmp_name'], "../uploads/" . $main_image);
        $update_fields[] = "main_image = '$main_image'";
    }

$sql = "UPDATE local_tours SET " . implode(', ', $update_fields) . " WHERE id = $id";
    
    if ($conn->query($sql)) {
        // Handle Gallery
        if (!empty($_FILES['gallery']['name'][0])) {
            foreach ($_FILES['gallery']['tmp_name'] as $key => $tmp_name) {
                $img_name = time() . '_' . $_FILES['gallery']['name'][$key];
                move_uploaded_file($tmp_name, "../uploads/" . $img_name);
                $conn->query("INSERT INTO local_tour_gallery (tour_id, image) VALUES ($id, '$img_name')");
            }
        }

echo "<script>alert('Local Tour updated successfully!'); window.location='local-tours.php';</script>";
    }
}
?>
<div class="container-fluid py-4">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h2 class="fw-bold mb-0">Edit Local Tour</h2>
        <a href="local-tours.php" class="btn btn-outline-secondary rounded-pill px-4">
            <i class="fas fa-arrow-left me-2"></i> Back to List
        </a>
    </div>

<div class="card border-0 shadow-sm" style="border-radius: 20px;">
        <div class="card-body p-5">
            <form method="POST" enctype="multipart/form-data">
                <div class="row g-4">
                    <div class="col-md-8">
                        <label class="form-label fw-bold text-muted small text-uppercase">Tour Title</label>
                        <input type="text" name="title" class="form-control form-control-lg border-0 bg-light" value="<?= htmlspecialchars($tour['title']) ?>" style="border-radius: 12px;" required>
                    </div>
                    <div class="col-md-4">
                        <label class="form-label fw-bold text-muted small text-uppercase">Location</label>
                        <input type="text" name="location" class="form-control form-control-lg border-0 bg-light" value="<?= htmlspecialchars($tour['location']) ?>" style="border-radius: 12px;" required>
                    </div>
                    <div class="col-md-12">
                        <label class="form-label fw-bold text-muted small text-uppercase">Description</label>
                        <textarea name="description" class="form-control border-0 bg-light" rows="5" style="border-radius: 15px;" required><?= htmlspecialchars($tour['description']) ?></textarea>
                    </div>
                    <div class="col-md-4">
                        <label class="form-label fw-bold text-muted small text-uppercase">Price (LKR)</label>
                        <div class="input-group">
                            <span class="input-group-text border-0 bg-light" style="border-radius: 12px 0 0 12px;">LKR</span>
                            <input type="number" name="price" class="form-control border-0 bg-light py-3" value="<?= (int)$tour['price'] ?>" style="border-radius: 0 12px 12px 0;" required>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <label class="form-label fw-bold text-muted small text-uppercase">Change Cover Image</label>
                        <input type="file" name="main_image" class="form-control border-0 bg-light py-3" style="border-radius: 12px;" accept="image/*">
                        <?php if($tour['main_image']): ?>
                            <div class="mt-2 p-2 bg-light rounded-3 d-inline-block">
                                <img src="../uploads/<?= $tour['main_image'] ?>" height="60" class="rounded">
                                <span class="ms-2 small text-muted">Current image</span>
                            </div>
                        <?php endif; ?>
                    </div>
                    <div class="col-md-4">
                        <label class="form-label fw-bold text-muted small text-uppercase">Add Gallery Images</label>
                        <input type="file" name="gallery[]" class="form-control border-0 bg-light py-3" style="border-radius: 12px;" accept="image/*" multiple>
                        <?php if($gallery && $gallery->num_rows > 0): ?>
                            <div class="mt-2 small text-muted"><?= $gallery->num_rows ?> image(s) already in gallery</div>
                        <?php endif; ?>
                    </div>
                </div>

<?php if($gallery && $gallery->num_rows > 0): ?>
                <div class="mt-4">
                    <label class="form-label fw-bold text-muted small text-uppercase">Current Gallery</label>
                    <div class="d-flex flex-wrap gap-2 mt-2">
                        <?php while($g = $gallery->fetch_assoc()): ?>
                        <div style="position: relative; display: inline-block;">
                            <img src="../uploads/<?= $g['image'] ?>" height="70" class="rounded">
                            <a href="delete-gallery-image.php?table=local_tour_gallery&id=<?= $g['id'] ?>&return=edit-local-tour.php?id=<?= $id ?>" class="btn btn-danger btn-sm rounded-circle position-absolute top-0 end-0" style="width: 20px; height: 20px; font-size: 10px; padding: 0; line-height: 20px;" onclick="return confirm('Delete this image?')">&times;</a>
                        </div>
                        <?php endwhile; ?>
                    </div>
                </div>
                <?php endif; ?>

<div class="text-end pt-5">
                    <button type="submit" class="btn btn-primary px-5 py-3 rounded-pill fw-bold shadow-lg">
                        <i class="fas fa-save me-2"></i> UPDATE LOCAL TOUR
                    </button>
                </div>
            </form>
        </div>
    </div>
</div>

<?php include '../includes/footer.php'; ?>

Cancel

🤩 File Manager - Mr.X

Editing:edit-local-tour.php