<?php
    $username=$_POST["username"];
    $password=$_POST["password"];
    $fullname=$_POST["fullname"];
    $email=$_POST["email"];
    $phone=$_POST["phone"];
    $address=$_POST["address"];
    /*
    echo"ชื่อผู้ใช้ = $username<br>";
    echo"รหัสผ่าน = $password<br>";
    echo"ชื่อ-นามสกุล = $fullname<br>";
    echo"email = $email<br>";
    echo"phone = $phone<br>";
    echo"address = $address<br>";
    */
    
    $sql = "INSERT INTO user (uid, username, password, fullname, email, phone, address, creation_date)
    VALUES (NULL, '$username', '$password','$fullname' ,'$email','$phone' ,'$address', 
    current_timestamp() )";

    if (mysqli_query($conn, $sql)) {
    echo "New record created successfully";
    echo"<meta http-equiv=\"refresh\" content=\"1;url=?page=show\">";
    } else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
    }

    mysqli_close($conn);

?>