使用两个单独的查询来检查数据库中是否存在电子邮件和用户名

Question

我正在尝试让我的PHP脚本来检查电子邮件和用户名是否已经存在于数据库中，如果存在，则显示消息-我最初能够成功检查一个，但现在我尝试在插入之前检查这两个，我遇到了一些问题。

有人能给我一些建议吗?我在这里做错了什么？

// Check if simple anti-bot test is correct
if ($human !== 5) {
    $errHuman = 'Your anti-spam is incorrect';
}
else {
    if (!$errEmail && !$errUsername && !$errPassword && !$errPassMatch && !$errHuman) {

        $query1="SELECT email FROM blog_members WHERE email='$email'";
        $query2="SELECT username FROM blog_members WHERE username='$signupusername'";
        $result1=mysqli_query($conn, $query1);
        $result2=mysqli_query($conn, $query2);

        if ($result1 && mysqli_num_rows($result1) >=1) {
            $error = "Email already exists!";
        }else if ($result2 && mysqli_num_rows($result2) >=1 ) {
            $error = "Username already exists!"
        }else {
            $query="INSERT INTO blog_members(username, password, email) VALUES ('$signupusername', '$signuppassword', '$email')";
            $result=mysqli_query($conn, $query);
            ?>
              <script type="text/javascript">
                alert("User created, please login from the homepage!");
                window.location.href = 'http://www.mywebsite.co.uk/index.php#login';
              </script>
            <?php
        }
    }
}

Answer 1

尝试这样做：

$query = mysqli_query("SELECT * FROM blog_members WHERE username='$username' OR email='$email'", $conn);
$result = mysqli_num_rows($query);

if ($result != 0) {
    // What happens if it exists
} else {
    // What happens if it doesn't exist
}

告诉我发生的任何错误，或者是否有任何错误。