Question

页: 1 fetch model don t work within PDOStatement:fetch ( but in the manual 它说,你可以使用<代码>。 PDO:FETCH_INTO with PDOStatement:fetch()。

I was trying to do: $query->fetch( PDO::FETCH_INTO, $user );

This returns: PDOStatement::fetch() expects parameter 2 to be long, object given

这并不意味着手册是误导吗? 如果使用<代码>PDO:FETCH_INTO的话,是怎样的?

Answer 1

采用这种方式:

$stmt->setFetchMode(PDO::FETCH_INTO, $user);
$user = $stmt->fetch();

最新资料:

如果你拥有公共建筑(建议使用)而不是公共财产的私人/受保护的财产,则使用FETCH_CLASS:

class User {
    protected $username;

    public setUsername($username) {
        $this->username = $username;
    }
...
}
...
$stmt->setFetchMode(PDO::FETCH_CLASS,  User );
$user = $stmt->fetch();

附录2:

采用PDO:FETCH_CLASS, 您甚至不需要安装机(EDIT:不需要PDO机,这对田地来说是好的):

class User {
    protected $username;
...
}
...
$stmt->setFetchMode(PDO::FETCH_CLASS,  User );
$user = $stmt->fetch();

UPDATE 3: see full example here:

Answer 2

请注意:PDOStatement:fetch()第二论点是cursor_orientation。

You probably want something like this:

$user = $query->fetch(PDO::FETCH_INTO);

友情链接