无效的患者ID
';
exit;
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$name = mysqli_real_escape_string($connID, $_POST['name']);
$gender = mysqli_real_escape_string($connID, $_POST['gender']);
$birth_date = $_POST['birth_date'] ? mysqli_real_escape_string($connID, $_POST['birth_date']) : NULL;
$phone = mysqli_real_escape_string($connID, $_POST['phone']);
$id_card = $_POST['id_card'] ? mysqli_real_escape_string($connID, $_POST['id_card']) : NULL;
$address = $_POST['address'] ? mysqli_real_escape_string($connID, $_POST['address']) : NULL;
$emergency_contact = $_POST['emergency_contact'] ? mysqli_real_escape_string($connID, $_POST['emergency_contact']) : NULL;
$emergency_phone = $_POST['emergency_phone'] ? mysqli_real_escape_string($connID, $_POST['emergency_phone']) : NULL;
$sql = "UPDATE patients SET
name = '$name',
gender = '$gender',
birth_date = " . ($birth_date ? "'$birth_date'" : "NULL") . ",
phone = '$phone',
id_card = " . ($id_card ? "'$id_card'" : "NULL") . ",
address = " . ($address ? "'$address'" : "NULL") . ",
emergency_contact = " . ($emergency_contact ? "'$emergency_contact'" : "NULL") . ",
emergency_phone = " . ($emergency_phone ? "'$emergency_phone'" : "NULL") . "
WHERE id = $patient_id";
if (mysqli_query($connID, $sql)) {
echo '患者信息更新成功!
';
echo '';
} else {
echo '更新失败:' . mysqli_error($connID) . '
';
}
}
$sql = "SELECT * FROM patients WHERE id = $patient_id";
$result = mysqli_query($connID, $sql);
if (mysqli_num_rows($result) == 0) {
echo '患者不存在
';
exit;
}
$patient = mysqli_fetch_assoc($result);
?>
创建时间: