检查是否已经是一个用户，然后插入到数据库php - Check if already a user then insert into the database php

Check if already a user then insert into the database php

如果我想插入到数据库中，我的代码可以工作，但是检查用户是否已经存在不起作用。

*我认为这个想法是检查是否存在一行与该用户名，如果是不添加该用户到数据库，否则

$email = $_POST['email'];
$password= password_hash($_POST['password'], PASSWORD_BCRYPT, $options);
$username= $_POST['username'];
$result = mysqli_query($mysqli, "SELECT username FROM users WHERE username = '$username'");
$row_count = $result->num_rows;
if($row_count == 1){
    echo'User exists';
}else{
$query = "INSERT INTO users (username, email, password) VALUES(?, ?, ?)";
$statement = $mysqli->prepare($query);
//bind parameters for markers, where (s = string, i = integer, d = double,  b = blob)
$statement->bind_param('sss', $username, $email, $password);
if($statement->execute()){
     print 'Success! ID of last inserted record is : ' .$statement->insert_id .'<br />'; 
}else{
     die('Error : ('. $mysqli->errno .') '. $mysqli->error);
}
$statement->close();
}

您已经混合了Procedural style &Object oriented style用于执行查询。

在使用,1)程序风格

$result = mysqli_query($mysqli, "Your Query");

使用这个，$row_count = mysqli_num_rows($result);

2)面向对象风格

$result = $mysqli->query("Your Query");

使用这个，$row_count = $result->num_rows;

所以，根据你的代码，你正在使用面向对象的风格。所以，你需要改变

$result = mysqli_query($mysqli,"SELECT username FROM users WHERE username = '$username'");

$result = $mysqli->query("SELECT username FROM users WHERE username = '$username'");

编辑代码。

$email = $_POST['email'];
$password= password_hash($_POST['password'], PASSWORD_BCRYPT, $options);
$username= $_POST['username'];
$result = $mysqli->query("SELECT username FROM users WHERE username = '$username'");
$row_count = $result->num_rows;
if($row_count == 1)
{
    echo 'User exists';
}
else
{
    $query = "INSERT INTO users (username, email, password) VALUES(?, ?, ?)";
    $statement = $mysqli->prepare($query);
    //bind parameters for markers, where (s = string, i = integer, d = double,  b = blob)
    $statement->bind_param('sss', $username, $email, $password);
    if($statement->execute())
    {
         print 'Success! ID of last inserted record is : ' .$statement->insert_id .'<br />'; 
    }
    else
    {
         die('Error : ('. $mysqli->errno .') '. $mysqli->error);
    }
    $statement->close();
}

更多信息，请查看mysqli_num_rows vs ->num_rows

$db = ("SELECT username FROM userlist WHERE username='$username'");
$query = $conn->query($db);
if(mysqli_fetch_array($query) > 0 ) { //check if there is already an entry for that username
    echo "Username already exists!";
}