PHP数据库查询结果错误

Question

Well, basically here is the error:

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, object given in

Here is my code:

function user_banned ($con, $username) {
    $result = mysqli_query($con, "SELECT `banned` FROM `users` WHERE `username` = '$username'");
    return(mysqli_num_rows($con) == 1) ? true : false;
}

I am not too sure what is causing this, I have seen several questions about this issue, however none of them have assisted my in finding a way to fix this issue.

Answer 1

You should add an extra column to your where clause: AND banned='yes' as an example.

Plus, you're using the wrong variable in

return(mysqli_num_rows($con) == 1) ? true : false;

you need to use the query variable and not the connection

return(mysqli_num_rows($result) == 1) ? true : false;

which explains the initial error:

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, object given in...