你已经混合了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'");
to
$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 与 ->num_rows http://php.net/manual/en/mysqli-result.num-rows.php