File Manager

Editing:booking-edit.php

<?php define('PAGE_TITLE', 'Edit Booking'); require_once 'includes/header.php';
$id = isset($_GET['id']) ? intval($_GET['id']) : 0;
$booking = getBooking($id);
if (!$booking) { echo '<div class="alert alert-danger">Booking not found</div>'; require_once 'includes/footer.php'; exit; }
$msg = '';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $event_date = cleanInput($_POST['event_date']); $start_time = cleanInput($_POST['start_time']); $end_time = cleanInput($_POST['end_time']);
    $venue = cleanInput($_POST['venue']); $address = cleanInput($_POST['address']); $district = cleanInput($_POST['district']);
    $color_theme = cleanInput($_POST['color_theme']); $special_notes = cleanInput($_POST['special_notes']);
    $total_price = floatval($_POST['total_price']); $advance_amount = floatval($_POST['advance_amount']);
    $balance_amount = $total_price - $advance_amount;
    $stmt = $conn->prepare("UPDATE bookings SET event_date=?, start_time=?, end_time=?, venue=?, address=?, district=?, color_theme=?, special_notes=?, total_price=?, advance_amount=?, balance_amount=? WHERE id=?");
    $stmt->bind_param("ssssssssdddi", $event_date, $start_time, $end_time, $venue, $address, $district, $color_theme, $special_notes, $total_price, $advance_amount, $balance_amount, $id);
    if ($stmt->execute()) { $msg = '<div class="alert alert-success">Booking updated!</div>'; $booking = getBooking($id); }
    else { $msg = '<div class="alert alert-danger">Update failed.</div>'; }
}
?>
<div class="d-flex justify-content-between align-items-center mb-4">
  <h4 class="fw-bold text-navy mb-0"><i class="bi bi-pencil-square text-warning me-2"></i>Edit Booking #<?= $booking['booking_id'] ?></h4>
  <a href="booking-details.php?id=<?= $id ?>" class="btn btn-outline-premium btn-sm"><i class="bi bi-arrow-left me-1"></i>Back</a>
</div>
<?= $msg ?>
<div class="premium-card p-4">
  <form method="post">
    <div class="row g-3">
      <div class="col-md-4"><label class="form-label">Event Date</label><input type="date" name="event_date" class="form-control" value="<?= $booking['event_date'] ?>" required></div>
      <div class="col-md-4"><label class="form-label">Start Time</label><input type="time" name="start_time" class="form-control" value="<?= $booking['start_time'] ?>" required></div>
      <div class="col-md-4"><label class="form-label">End Time</label><input type="time" name="end_time" class="form-control" value="<?= $booking['end_time'] ?>" required></div>
      <div class="col-md-6"><label class="form-label">Venue</label><input type="text" name="venue" class="form-control" value="<?= htmlspecialchars($booking['venue']) ?>" required></div>
      <div class="col-md-6"><label class="form-label">District</label><input type="text" name="district" class="form-control" value="<?= htmlspecialchars($booking['district']) ?>"></div>
      <div class="col-12"><label class="form-label">Address</label><textarea name="address" class="form-control" rows="2"><?= htmlspecialchars($booking['address'] ?? '') ?></textarea></div>
      <div class="col-md-4"><label class="form-label">Color Theme</label><input type="text" name="color_theme" class="form-control" value="<?= htmlspecialchars($booking['color_theme'] ?? '') ?>"></div>
      <div class="col-md-4"><label class="form-label">Total Price (<?= getSetting('currency')?:'LKR' ?>)</label><input type="number" name="total_price" class="form-control" step="0.01" value="<?= $booking['total_price'] ?>" required></div>
      <div class="col-md-4"><label class="form-label">Advance Amount</label><input type="number" name="advance_amount" class="form-control" step="0.01" value="<?= $booking['advance_amount'] ?>"></div>
      <div class="col-12"><label class="form-label">Special Notes</label><textarea name="special_notes" class="form-control" rows="3"><?= htmlspecialchars($booking['special_notes'] ?? '') ?></textarea></div>
      <div class="col-12"><button type="submit" class="btn btn-premium"><i class="bi bi-save me-2"></i>Save Changes</button></div>
    </div>
  </form>
</div>
<?php require_once 'includes/footer.php'; ?>

Cancel

🤩 File Manager - Mr.X

Editing:booking-edit.php