You want a concise way to execute a query and retrieve the data it returns.
Use fetchAll() to get all the results from a query at once, as shown in Example 10-13.
Example 10-13. Getting all results at once
|
1 2 3 4 5 |
$st = $db->query('SELECT planet, element FROM zodiac'); $results = $st->fetchAll(); foreach ($results as $i => $result) { print "Planet $i is {$result['planet']} <br/>\n"; } |
The fetchAll() method is useful when you need to do something that depends on all the rows a query returns, such as counting how many rows there are or handling rows out of order.
Like fetch(), fetchAll() defaults to representing each row as an array with both numeric and string keys and accepts the various PDO::FETCH_* constants to change that behavior.
fetchAll() also accepts a few other constants that affect the results it returns.
To retrieve just a single column from the results, pass PDO::FETCH_COLUMN and a second argument, the index of the column you want. The first column is 0, not 1.
