query( 'SELECT s.id, s.code, s.label, s.price_per_hour, a.available_slots FROM service_types s JOIN availability a ON a.service_type_id = s.id ORDER BY s.id' )->fetchAll(); // Handle form submission if ($_SERVER['REQUEST_METHOD'] === 'POST') { $svcId = (int) ($_POST['service_type_id'] ?? 0); $checkIn = trim($_POST['check_in'] ?? ''); $checkOut = trim($_POST['check_out'] ?? ''); $vehicle = trim($_POST['vehicle_number'] ?? ''); $guests = max(1, (int) ($_POST['guests'] ?? 1)); $notes = trim($_POST['notes'] ?? ''); $driverId = $_SESSION['driver_id']; // Validate if (!$svcId) $errors[] = 'Please select a service.'; if (!$checkIn) $errors[] = 'Check-in date/time is required.'; if (!$checkOut) $errors[] = 'Check-out date/time is required.'; if ($checkIn && $checkOut && strtotime($checkOut) <= strtotime($checkIn)) $errors[] = 'Check-out must be after check-in.'; if (empty($errors)) { // Calculate total $hrs = (strtotime($checkOut) - strtotime($checkIn)) / 3600; $stmt = db()->prepare('SELECT price_per_hour FROM service_types WHERE id = ?'); $stmt->execute([$svcId]); $rate = (float) ($stmt->fetchColumn() ?: 0); $total = $rate * $hrs; $ref = generateRef(); try { db()->beginTransaction(); // Insert booking $ins = db()->prepare( 'INSERT INTO bookings (driver_id, service_type_id, booking_ref, check_in, check_out, vehicle_number, guests, total_amount, notes) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)' ); $ins->execute([$driverId, $svcId, $ref, $checkIn, $checkOut, $vehicle, $guests, $total, $notes]); // Decrement availability db()->prepare( 'UPDATE availability SET available_slots = GREATEST(0, available_slots - 1) WHERE service_type_id = ?' )->execute([$svcId]); db()->commit(); flash("Booking confirmed! Your reference is {$ref}. Total: ₹" . number_format($total, 2), 'success'); header('Location: my-bookings.php'); exit; } catch (Exception $e) { db()->rollBack(); $errors[] = 'Booking failed: ' . $e->getMessage(); } } } renderHeader('Book a Slot'); ?>
Reserve Your Space

Book a Slot

Quick, secure online booking. Confirmation is instant.

⚠

Booking Details

All prices shown are per hour. Total is calculated automatically.

ESTIMATED TOTAL —

Want to see your past bookings? View My Bookings →