✏ EDIT: book_appointment.php

<?php
// Public page to book an appointment
$pageTitle = 'Book Appointment';
require_once __DIR__ . '/includes/header.php';

$success = false;
$error = '';
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $name = trim($_POST['name'] ?? '');
    $email = trim($_POST['email'] ?? '');
    $phone = trim($_POST['phone'] ?? '');
    $preferred_date = trim($_POST['preferred_date'] ?? '');
    $message = trim($_POST['message'] ?? '');
    if ($name && $email && $phone && $preferred_date) {
        // Insert into appointments table
        $stmt = $conn->prepare("INSERT INTO appointments (name, email, phone, preferred_date, message) VALUES (?, ?, ?, ?, ?)");
        if ($stmt) {
            $stmt->bind_param('sssss', $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;">Book an Appointment</h1>
        <?php if ($success): ?>
            <p style="color:green;text-align:center;font-weight:bold;">Thank you! Your appointment 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">
            <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