PHP OOP 为类变量赋值

Question

class User{
public $id, $username, $firstname, $lastname;

public function find(){
$result = blabla->query('SELECT * FROM users WHERE id = 1');
return $result;
}
}

我对如何将值(来自 mysql)分配给类变量感兴趣。

$user = new User();
$user->find();
echo $user->username;
echo $user->lastname;

Answer 1

我不确定它是否适用于 SELECT *，但您可以尝试 PDO::FETCH_INTO :

class User{
    public $id, $username, $firstname, $lastname;
    public function find(){
        $result = blabla->query('SELECT id, username, firstname, lastname FROM users WHERE id = 1');
        $this = $result->fetch( PDO::FETCH_INTO );
    }
}

<小时/>

如果不起作用，您可以使用bindColumn call with PDO::FETCH_BOUND选项:

class User{
    public $id, $username, $firstname, $lastname;
    public function find() {
        $result = blabla->query('SELECT id, username, firstname, lastname FROM users WHERE id = 1');
        $result->bindColumn( 1, $this->id );
        /* Other bindColumn calls here */
        return $result->fetch( PDO::FETCH_BOUND );
    }
}