<?php
@include('condb.php');


if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $p_prefix = $_POST["prefix"]; 
    $p_name = $_POST["name"];
    $p_home = $_POST["home"];
    $p_moo = $_POST["moo"];
    $p_soi = $_POST["soi"];
    $p_road = $_POST["road"];
    $p_tambol = $_POST["tambol"];
    $p_district = $_POST["district"];
    $p_province = $_POST["province"];
    $p_postal = $_POST["postal"];
    $p_work = $_POST["work"];
    $p_phone = $_POST["phone"];

 
    $sql = "INSERT INTO `pta_parent` (`p_id`, `p_prefix`, `p_name`, `p_home`, `p_moo`, `p_soi`, `p_road`, `p_tambol`, `p_district`, `p_province`, `p_postal`, `p_work`, `p_phone`)
     VALUES (NULL, '$p_prefix', '$p_name', '$p_home', '$p_moo', '$p_soi', '$p_road', '$p_tambol', '$p_district', '$p_province', '$p_postal', '$p_work', '$p_phone');";

    if ($conn->query($sql) === TRUE) {
        echo "บันทึกข้อมูลสำเร็จ!";
    } else {
        echo "เกิดข้อผิดพลาด: " . $sql . "<br>" . $conn->error;
    }

    $sql = "SELECT * FROM `pta_parent` order by p_id desc LIMIT 1";
    $result = $conn->query($sql);
    if ($result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {
            $p_id = $row["p_id"];
            $s_prefix = $_POST["prefix_1"];
            $s_name = $_POST["student_name_1"];
            $s_level = $_POST["student_level_1"];
            $s_dept = $_POST["student_dept_1"];
            $sql_student = "INSERT INTO `pta_student` (`s_id`, `p_id`, `s_prefix`, `s_name`, `s_level`, `s_dept`) 
            VALUES (NULL, '$p_id', '$s_prefix', '$s_name', '$s_level', '$s_dept');";
            if ($conn->query($sql_student) === TRUE) {
                echo "<script>
                alert('บันทึกข้อมูลเรียบร้อยแล้วครับ !');
                window.location.href = 'index.php';
              </script>";

            } else {
                echo "<script>
                alert('เกิดข้อผิดพลาด: " . $conn->error . "');
              </script>";

            }
        }
    } else {
        echo "ไม่พบข้อมูล";
    }
}
$conn->close();
?>