PDO :: FETCH_OBJ +自定义类？

Question

When I fetchAll() query results (SELECT * FROM users ...) as an array of objects, I want these objects to be of a certain class, namely User.

1. How do I force PDO to use the data type User for the result objects, and
2. do I have to define all member variables corresponding to the field names in the class?

Answer 1

there is a static field to tell PDO to fetch into a class, PDO::FETCH_CLASS.

Here is an example of getting User objects;

class User {
    public $name;
    public $firstname;
}

You have to ensure that the field names are same as the column ones and that the class is accessible from the class / file you're working from. (SELECT * works too, just have all fields available)

$query = "SELECT name, firstname FROM users";

And to wrap it in classes, use the next,

$users = $sth->fetchAll(PDO::FETCH_CLASS, "User");

Then you can simply access it as an array of User objects.