How can PHP objects be directly mapped from database query results?

To directly map PHP objects from database query results, you can use the PDO extension in PHP to fetch the query results as associative arrays and then instantiate objects with the retrieved data. You can create a class for the object type you want to map the query results to, and then loop through the query results to create instances of this class with the data from each row. 

// Assume we have a database connection stored in $pdo

class User {
    public $id;
    public $username;
    public $email;

    public function __construct($id, $username, $email) {
        $this->id = $id;
        $this->username = $username;
        $this->email = $email;
    }
}

$query = $pdo->query("SELECT * FROM users");
$users = [];
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
    $user = new User($row['id'], $row['username'], $row['email']);
    $users[] = $user;
}

// $users now contains an array of User objects mapped from database query results

Keywords

PHP objects database mapping query results

Related Questions