不检查用户是否被关闭[关闭]

Question

This snip of code doesn't do as it's supposed to and i can't see why. Please help

$userquery = "SELECT Username FROM Member WHERE Username = '$username'";
$checkUser = mysqli_num_rows($conn, $userquery);
if($checkUser > 0 ){
header("Location:Registration.php?UserError=true&reason=taken" );
}else{

$query = "INSERT INTO Member ( Username, Password, Email, Salt, Verify_Code ) VALUES
( '$username', '$password', '$email', '$salt', '$verify_code' )";
$result = mysqli_query($conn, $query);
}

Thanks people

Answer 1

You need to execute your query $Result = mysqli_query ($conn , $query);

   <?php 
       $userquery = "SELECT Username FROM Member WHERE Username = '$username'";        
       $Result =  mysqli_query ($conn , $query);
       $checkUser = mysqli_num_rows($Result);
       if($checkUser > 0 ){
        header("Location:Registration.php?UserError=true&reason=taken" );
       }else{

        $query = "INSERT INTO Member ( Username, Password, Email, Salt, Verify_Code ) VALUES
        ( '$username', '$password', '$email', '$salt', '$verify_code' )";
        $result = mysqli_query($conn, $query);
       }

   ?>