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


if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $p_id = $_POST["p_id"]; 
    $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 = "UPDATE `pta_parent` SET 
    `p_prefix` = '$p_prefix', 
    `p_name` = '$p_name', 
    `p_home` = '$p_home', 
    `p_moo` = '$p_moo', 
    `p_soi` = '$p_soi', 
    `p_road` = '$p_road', 
    `p_tambol` = '$p_tambol', 
    `p_district` = '$p_district', 
    `p_province` = '$p_province', 
    `p_postal` = '$p_postal', 
    `p_work` = '$p_work', 
    `p_phone` = '$p_phone' 
    WHERE `pta_parent`.`p_id` = $p_id;";

    if ($conn->query($sql) === TRUE) {
        echo "<script>
        alert('บันทึกข้อมูลเรียบร้อยแล้วครับ !');
        window.location.href = 'index.php';
    </script>";

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

    }

}
$conn->close();
?>