php - MySQL 查询 : Trying to get property of non-object

Question

我收到以下错误消息。

Notice: Trying to get property of non-object in
C:\xampp\htdocs\my\include\user_functions.php on line 34

这是我的代码

$conn = db_connection();
    if($conn == false) {
        user_error('Unable to connect to database');
        return false;
    }
    $query = "UPDATE user SET passwd = '".$new_passwd."'
            WHERE username = '".$username."'  ";

    $result=$conn->query($query);
    if($result == false) {
        user_error('Query Error'.$conn->error);
        return false;
    }           

    if($result->num_rows == 1) {
        echo 'Password changed';
    } else {
            echo 'Failed ';
    }

这是我的数据库连接

function db_connection() {
    $db = new mysqli('localhost','root','','php_login');
    if(!$db) {
        echo 'Could not connect to database server';
    } else {
        return $db;
    }
}

Answer 1

UPDATE 语句不返回结果集。您想从 fetch_array 获取什么？