使用mysqli :: num_rows返回总记录

Question

why always $stmt->num_rows returns 0(zero), Whereas exist 2 records in users table. code:

    public function fetch_users()
    {
        if (!($stmt = $this->mysqli->prepare("SELECT * FROM users"))){
            echo "prepare failed: (" . $this->mysql->errno . ") " . $this->mysqli->error;
        }

        if (!$stmt->execute()) {
            echo "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
        }

        echo $stmt->num_rows;
    }

Answer 1

Solved with this change:

public function fetch_users()
{
    if (!($stmt = $this->mysqli->prepare("SELECT * FROM users"))){
        echo "prepare failed: (" . $this->mysql->errno . ") " . $this->mysqli->error;
    }

    if (!$stmt->execute()) {
        echo "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
    }

    $stmt->store_result();

    echo $stmt->num_rows;
}