<?php
$username = $_POST['username'];
$password = $_POST['password'];
$fName = $_POST['fName'];
$lName = $_POST['lName'];
$address = $_POST['address'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$userType = 2;
include('../../../include/connectDB.php');
$selectCheckUsername = "SELECT users_username FROM users WHERE users_username = '$username'";
$resultUsername = mysqli_query($con, $selectCheckUsername) or die(mysqli_error($con));
list($username_db) = mysqli_fetch_row($resultUsername);
if ($username == $username_db) {
    echo "<script>alert('username ซ้ำ กรุณากรอกใหม่')</script>";
    echo "<script>window.location = 'forms/formAddUser.php'</script>";
} else {
    $insertUser = "INSERT INTO users VALUES('$username','$password','$fName','$lName','$address','$email',$phone,'$userType')";
    mysqli_query($con, $insertUser) or die(mysqli_error($con));
    $redirectToManageUser = "./ManageUsers.php";
    mysqli_close($con);
    header("Location:$redirectToManageUser");
}
?>