医院咨询挂号系统 php

<?php
// 数据库连接
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "hospital";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 处理预约请求
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $patientName = $_POST['patientName'];
    $doctorId = $_POST['doctorId'];
    $appointmentDate = $_POST['appointmentDate'];

    // 检查时间段是否可用
    $sql = "SELECT * FROM appointments WHERE doctor_id = ? AND appointment_date = ? FOR UPDATE";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("is", $doctorId, $appointmentDate);
    $stmt->execute();
    $result = $stmt->get_result();

    if ($result->num_rows > 0) {
        echo "时间段已被占用，请选择其他时间。";
    } else {
        // 插入预约记录
        $sql = "INSERT INTO appointments (patient_name, doctor_id, appointment_date) VALUES (?, ?, ?)";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("sis", $patientName, $doctorId, $appointmentDate);
        if ($stmt->execute()) {
            echo "预约成功！";
        } else {
            echo "预约失败：" . $stmt->error;
        }
    }
}

$conn->close();
?>