Viewing file:  appo.php (1.45 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
if (isset($_POST['submit'])) {
include "admin/conn.php";
error_reporting(0);
$newStartValue = 1;
$query = "ALTER TABLE appointments AUTO_INCREMENT = $newStartValue";
$result = mysqli_query($con, $query);
// Process form submission
$name = $_POST['name'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$department = $_POST['department'];
$doctor_name = $_POST['doctor_name'];
$date = $_POST['date'];
$time = $_POST['time'];
$appo_fa = isset($_POST['appo_fa']) ? $_POST['appo_fa'] : ""; // Set it to an empty string if not provided
$appo_message = $_POST['appo_message'];
$sql = "INSERT INTO appointments (name, email, phone, department, doctor_name, date, time, appo_message) VALUES ('$name', '$email', '$phone', '$department', '$doctor_name', '$date', '$time', '$appo_message')";
if (empty($appo_fa)) { // Check if appo_fa is empty
if (mysqli_query($con, $sql)) {
echo "<script>window.location.href = 'mail-success.php'</script>";
exit;
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
} else if ($appo_fa === "fa") {
if (mysqli_query($con, $sql)) {
echo "<script>window.location.href = 'mail-success_fa.php'</script>";
exit;
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
}
mysqli_close($con);
}
?>
|