php-pdoFetch all resulting rows with PHP PDO
$st = $pdo->prepare('SELECT * FROM test');
$st->execute();
$rows = $st->fetchAll(PDO::FETCH_ASSOC);ctrl + c$pdo->prepareprepare given query to execute | $st->execute(run query on the server |
fetchAllreturns all rows from result set | FETCH_ASSOCwill return row as an associative array (rather than numbered array) |
$rowsresulting array of rows | |
Usage example
<?php
$pdo = new PDO('mysql:host=localhost;dbname=test', 'usr', 'pwd');
$st = $pdo->prepare('SELECT * FROM test LIMIT 3');
$st->execute();
$rows = $st->fetchAll(PDO::FETCH_ASSOC);
print_r($rows);output
Array
(
[0] => Array
(
[id] => 1
[age] => 25
[name] => A
[data] =>
)
[1] => Array
(
[id] => 2
[age] => 52
[name] => B
[data] =>
)
[2] => Array
(
[id] => 3
[age] => 52
[name] => C
[data] =>
)
)
Related
More of Php Pdo
- Set execution timeout with PHP PDO
- Set charset in PHP PDO
- Fetch single column value with PHP PDO
- Bind current datetime with PHP PDO
- How to get results after PHP PDO statement execute()
- Escape string with PHP PDO
- Get last query error with PHP PDO
- Commit transaction in PHP PDO
- Get current database name with PHP PDO
- Transaction example with PHP PDO
See more codes...