CREATE query (Adding, Inserting, etc.)
<?php
$query = "INSERT INTO users (username, user_email, user_password, user_role) ";
$query .= "VALUES('$username', '$email', '$password', 'subscriber')";
$register_user_query = mysqli_query($connection, $query);
if(!$register_user_query) {
die("QUERY FAILED " . mysqli_error($connection) . ' ' . mysqli_errno($connection));
}
?>