Root Explorer PHP

Editing: submit_appointment.php

<?php
include('include/connect.php'); // Make sure $con is defined here
if ($_SERVER['REQUEST_METHOD'] == 'POST') {

// Collect input
    $name = $_POST['name'];
    $email = $_POST['email'];
    $phone = $_POST['phone'];
    $treatment = $_POST['treatment'];
    $appointment_date = $_POST['appointment_date'];
    $appointment_time = $_POST['appointment_time'];
    $message = $_POST['message'];

// Use prepared statement to avoid SQL errors
    $stmt = $conn->prepare("INSERT INTO appointments (name, email, phone, treatment, appointment_date, appointment_time, message) VALUES (?, ?, ?, ?, ?, ?, ?)");
    $stmt->bind_param("sssssss", $name, $email, $phone, $treatment, $appointment_date, $appointment_time, $message);

if ($stmt->execute()) {
        echo "<script>alert('Your message has been sent successfully!'); window.location.href='index.php';</script>";
    } else {
        echo "<script>alert('Something went wrong. Please try again later.'); window.history.back();</script>";
    }

$stmt->close();
    $conn->close();
} else {
    echo "<script>window.history.back();</script>";
    exit;
}
?>

[ CANCEL ]

Name	Type	Actions
.. (Parent Directory)
📁 Include/	DIR
📁 Uploads/	DIR
📄 about.php	FILE	[EDIT]
📁 admin/	DIR
📄 appointment.php	FILE	[EDIT]
📄 blog-detail.php	FILE	[EDIT]
📄 blog-grid.php	FILE	[EDIT]
📁 ckfinder/	DIR
📁 component/	DIR
📄 contact-form-handler.php	FILE	[EDIT]
📄 contact-us.php	FILE	[EDIT]
📁 css/	DIR
📁 fonts/	DIR
📄 google8b838d2ce142f997.html	FILE	[EDIT]
📁 images/	DIR
📁 img/	DIR
📄 index.php	FILE	[EDIT]
📄 javascripr.html	FILE	[EDIT]
📁 js/	DIR
📄 package-lock.json	FILE	[EDIT]
📄 photos.php	FILE	[EDIT]
📄 robots.txt	FILE	[EDIT]
📄 service-detail.php	FILE	[EDIT]
📄 service.php	FILE	[EDIT]
📄 sitemap.xml	FILE	[EDIT]
📄 submit_appointment.php	FILE	[EDIT]
📄 temp.md	FILE	[EDIT]
📄 videos.php	FILE	[EDIT]

[ Root System Explorer ]

Editing: submit_appointment.php