Php PDO | how to use fetchAll with FETCH_LAZY?

Question

I am trying to use FETCH_LAZY. I can use a while loop whilst setting $row equal to $query->fetch(). The problem is that fetchAll does not work when the fetchMode is FETCH_LAZY.

How can I return an array of PDO Objects?

Thanks.

Show us some code that you've tried?

Kaylined
– Kaylined

2017-02-12 04:09:45 +00:00
Commented Feb 12, 2017 at 4:09 — Kaylined
– Kaylined, Commented Feb 12, 2017 at 4:09

István Ujj-Mészáros · Accepted Answer · 2024-12-08 19:51:27Z

3

Due to the very nature of FETCH_LAZY, you cannot use fetchAll with this mode. It can be used with fetch() only.

It seems that you are simply confusing this mode with FETCH_OBJ which will give you an array of objects you need

$array = $stmt->fetchAll(PDO::FETCH_OBJ);

Also note that beside creating stdObj instances you can make fetchAll to return an array of objects of any other class as well.

edited Dec 8, 2024 at 19:51

István Ujj-Mészáros

3,2571 gold badge30 silver badges48 bronze badges

answered Feb 12, 2017 at 6:52

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

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

Collectives™ on Stack Overflow

Php PDO | how to use fetchAll with FETCH_LAZY?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related