PDO multiple fetching of same query [duplicate]

Question

I am fetching the results from a db with PDO::FETCH_ASSOC. The issue is that I am doing it twice in the same file. Is that a known issue? What would be the alternative?

Here is my code:

FIRST TIME while($row = $ordersQuery->fetch(PDO::FETCH_ASSOC)) { $totalAmount += $row['clientPrice']/100; } echo $totalAmount; SECOND TIME while($row = $ordersQuery->fetch(PDO::FETCH_ASSOC)) { .... }

Whenever I remove the first fetching, the second works fine. If I have both, the second does not return anything.

Thanks!

JRL · Accepted Answer · 2013-04-15 22:56:22Z

7

You can't fetch from the DB multiple times like this. Do this instead:

$orders = $ordersQuery->fetchAll(PDO::FETCH_ASSOC); ... foreach ($orders as $val) { // stuff 1 } ... foreach ($orders as $val) { // stuff 2 }

edited Apr 15, 2013 at 22:56

answered Apr 15, 2013 at 21:23

JRL

8607 silver badges19 bronze badges

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

1 Comment

George Cummins Over a year ago

The statement handle ($ordersQuery) does not contain the result set. Do you mean to iterate $orders?

Steven Glasser · Accepted Answer · 2013-04-15 21:27:42Z

Use fetchAll() which will return an array. You then can loop through it as many times as you want:

$orders = $ordersQuery->fetchAll(PDO::FETCH_ASSOC);

Collectives™ on Stack Overflow

PDO multiple fetching of same query [duplicate]

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related