"; //var_dump($_POST); // Create the SQL query $sql = "INSERT INTO tblpatient (fname, mname, lname, patientage, sex, civilstatus, phonenumber, address, dateofbirth, tblsec_userid, findings, recommendation, isCancelled) VALUES ('$fname', '$mname', '$lname', $age, '$sex', '$civilStatus', '$phonenum', '$address', '$dateOfBirth', $secIDFK, '', '', 0)"; if (mysqli_query($conn, $sql)) { // Data inserted successfully header("Location: secindex.php?msg=Patient created successfully"); exit(); // Make sure to exit after redirection } else { // Handle the case where data insertion failed echo "Error: " . mysqli_error($conn); } }