✏ EDIT: book_service.php

<?php
// Public page to book a service (maintenance or repair)
$pageTitle = 'Service Booking';
require_once __DIR__ . '/includes/header.php';

// Fetch list of available services for the dropdown
$serviceOptions = [];
$resSvc = $conn->query("SELECT title FROM services ORDER BY title ASC");
if ($resSvc && $resSvc->num_rows > 0) {
    while ($row = $resSvc->fetch_assoc()) {
        $serviceOptions[] = $row['title'];
    }
}

$success = false;
$error = '';
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $service_type = trim($_POST['service_type'] ?? '');
    $name  = trim($_POST['name'] ?? '');
    $email = trim($_POST['email'] ?? '');
    $phone = trim($_POST['phone'] ?? '');
    $preferred_date = trim($_POST['preferred_date'] ?? '');
    $message = trim($_POST['message'] ?? '');
    if ($service_type && $name && $email && $phone && $preferred_date) {
        $stmt = $conn->prepare("INSERT INTO service_bookings (service_type, name, email, phone, preferred_date, message) VALUES (?, ?, ?, ?, ?, ?)");
        if ($stmt) {
            $stmt->bind_param('ssssss', $service_type, $name, $email, $phone, $preferred_date, $message);
            if ($stmt->execute()) {
                $success = true;
            } else {
                $error = 'Could not save your booking. Please try again later.';
            }
        } else {
            $error = 'Database error.';
        }
    } else {
        $error = 'Please fill in all required fields.';
    }
}
?>
<main>
    <div class="container bordered-section">
        <h1 style="text-align:center;margin-top:30px;">Service Booking</h1>
        <?php if ($success): ?>
            <p style="color:green;text-align:center;font-weight:bold;">Thank you! Your service booking request has been received. Our team will contact you shortly.</p>
        <?php elseif ($error): ?>
            <p style="color:red;text-align:center;font-weight:bold;">
                <?php echo e($error); ?>
            </p>
        <?php endif; ?>
        <form method="post" class="booking-form">
            <select name="service_type" required>
                <option value="" disabled selected>Select Service</option>
                <?php foreach ($serviceOptions as $opt): ?>
                    <option value="<?php echo e($opt); ?>" <?php echo (isset($_POST['service_type']) && $_POST['service_type'] === $opt) ? 'selected' : ''; ?>><?php echo e($opt); ?></option>
                <?php endforeach; ?>
            </select>
            <input type="text" name="name" placeholder="Your Name" value="<?php echo isset($_POST['name']) ? e($_POST['name']) : ''; ?>" required>
            <input type="email" name="email" placeholder="Email Address" value="<?php echo isset($_POST['email']) ? e($_POST['email']) : ''; ?>" required>
            <input type="text" name="phone" placeholder="Phone Number" value="<?php echo isset($_POST['phone']) ? e($_POST['phone']) : ''; ?>" required>
            <input type="datetime-local" name="preferred_date" value="<?php echo isset($_POST['preferred_date']) ? e($_POST['preferred_date']) : ''; ?>" required>
            <textarea name="message" placeholder="Message (Optional)"><?php echo isset($_POST['message']) ? e($_POST['message']) : ''; ?></textarea>
            <button type="submit">Submit Booking</button>
        </form>
    </div>
</main>
<?php require __DIR__ . '/includes/footer.php'; ?>

[✗] CANCEL