<?php

session_start();

include("Admin/Includes/db.php");

if(isset($_POST['appointment_submit'])){

    $department = $_POST['department'];
    $doctor = $_POST['doctor'];
    $fromdateone = $_POST['fromdateone'];
    $fromtimeone = $_POST['fromtimeone'];
    $name = $_POST['name'];
    $email = $_POST['email'];
    $phone = $_POST['phone'];
    $disease = $_POST['disease'];

    if ($disease == 'Others') {
        // If 'Others' is selected, retrieve the custom disease entered by the user
        $disease = ($_POST['others_disease']);
    }


    $query = "INSERT INTO appointment (department, doctor, fromdateone, fromtimeone, name, email, phone,disease) 
              VALUES ('$department','$doctor','$fromdateone','$fromtimeone','$name', '$email','$phone','$disease')";
    $query_run = mysqli_query($con, $query);

    if($query_run){
        $_SESSION['status'] = "Appointment Book Successfully";
        header('Location: appointment.php');
    } else {
        $_SESSION['status'] = "Appointment Not Booked";
        header('Location: appointment.php');
    }
}
?>