不检查用户是否被带走 [英] Not check if user is taken

问题描述

此代码段未按预期执行，我也看不出原因.请帮助

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);
}

感谢人们

推荐答案

您需要执行查询$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);
       }

   ?>

这篇关于不检查用户是否被带走的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！