Query used in checking existing users not working

Question

if( empty($errors)){

//if errors free
$password_encrypt = md5($password);
$query = "INSERT INTO `users`(user_id,firstname, lastname, password, email, phone_num)
VALUES (default,'$firstname','$lastname','$password_encrypt','$emailaddress', '$phonenumber')";
$run_query = mysqli_query($dbconn,$query);

//we need to check if a user does not already exist with the same email and or phone number

$check_existing_user = "SELECT * FROM `users` WHERE email = '$emailaddress' AND phone_num = '$phonenumber'";

$result = mysqli_query($dbconn, $check_existing_user);

if($result){
$numofrows = mysqli_num_rows($result);
if($numofrows > 0){
echo "address or phone number already exist";
}
}
if($run_query == TRUE){
header('Location: registersuccess.php');
}

else{
echo mysqli_error();
}

Answer 1

Yes, check out the link. Also, it's usually good to check if username and email are the same. If you want to make sure the phone number is unique, maybe you should make that field unique. http://www.mysqltutorial.org/mysql-unique/

Answer 2

What errors are you getting?

I would avoid writing user_id and default if it's auto_increment.

For reference:

https://codewithawa.com/posts/complete-user-registration-system-using-php-and-mysql-database

Answer 3

@dplusplus am actually not getting any errors but I noticed that it was accepting existing emails and phone number into the db after running the query

Answer 4

dplusplus

Answer 5

Is that query the best query for checking existing users

Answer 6

Thanks a lot. I will get back to you