PDO FetchAll Array

Question

I know that $stmt->fetchAll(PDO::FETCH_ASSOC); returns the result in an array to the variable, but how would you go around extracting the information from the array? Say the variable holds 3000 entries.

Thank you

it gives you a two-dimensional array... either loop through the array or access a particular record via it's zero-based index. — Orangepill
– Orangepill, Commented Aug 18, 2013 at 2:41
@orangepill What did you mean by two dimensional? Assming the variable is $hello = $stmt->fetchAll(PDO::FETCH_ASSOC); I can't just do $hello[0][blah]? — user2693086
– user2693086, Commented Aug 18, 2013 at 2:45
I mean that it is an array of arrays. you would access the field name id in the first record by $hello[0]["id"]; — Orangepill
– Orangepill, Commented Aug 18, 2013 at 2:46
or each of the row's id elements in turn via foreach($hello as $row){ echo $row["id"]; } — Orangepill
– Orangepill, Commented Aug 18, 2013 at 2:47

iRector · Accepted Answer · 2013-08-18 02:45:26Z

1

If you mean extract information from what $stmt->fetchAll(PDO::FETCH_ASSOC); returns, you need to set it to a variable.

$returned_results = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach($returned_results as $key=>$result) {
     echo "<pre>"; var_dump($result); echo "</pre>";
}

This will dump every result, which will show you how to directly access the array hierarchy.
Which will end up being something like:

$returned_results[2]['somefield'];

answered Aug 18, 2013 at 2:45

iRector

1,9824 gold badges22 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

PDO FetchAll Array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related