Booking not found'; 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 = '
Booking updated!
'; $booking = getBooking($id); } else { $msg = '
Update failed.
'; } } ?>

Edit Booking #

Back