<?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";
} else {
  echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);
?>