Returning Array of Objects from PDO

Question

I have a PHP class (POJO_FOO) which maps to a table (TABLE_FOO).

e.g. one row equal to one object of that class.

Now I am writing a manager which returns array of such objects matching a particular query. Using PDO, how can I return array of objects ?

When I do simple fetchAll, it returns array (representing number of results) of associative array (column => value). Is there a option in fetchALL which can give me result in form of array of objects ?

wow it works ... don't know why it wasn't working when I tried. anyways .. thanks for the answer. — mrd081
– mrd081, Commented Aug 28, 2012 at 8:32

artragis · Accepted Answer · 2012-08-28 08:49:54Z

8

you can use PDO::FETCH_CLASS to hydrate your class with your data :

return $pdo->query('SELECT * FROM tablefoo')->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE,'POJO_FOO');

it is also useful to use PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE because it makes the construction of the object more consistent. Habitualy your constructor is called before everything. If you do not use FETCH_PROPS_LATE it will called after your properties are hydrated.

edited Aug 28, 2012 at 8:49

answered Aug 28, 2012 at 8:21

artragis

3,7031 gold badge21 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

mrd081 Over a year ago

wow it works ... don't know why it wasn't working when I tried. anyways .. thanks for the answer :)

artragis Over a year ago

a litle comment about PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE

mrd081 Over a year ago

what will that do ? (FETCH_PROPS_LATE)

artragis Over a year ago

I tried to explain it : -without PROPS_LATE : PDO hydrates your object and then calls the constructor. If your constructor does call a important initialisation process, it is bad -with PROPS_LATE : PDO calls your constructor and then hydrate your object : that's consistent and secured.

Collectives™ on Stack Overflow

Returning Array of Objects from PDO

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related