How can I use PDO to fetch a results array in PHP?

by

Take a look at the PDOStatement.fetchAll method. You could also use fetch in an iterator pattern.

Code sample for fetchAll, from the PHP documentation:

<?php
$sth = $dbh->prepare("SELECT name, colour FROM fruit");
$sth->execute();

/* Fetch all of the remaining rows in the result set */
print("Fetch all of the remaining rows in the result set:\n");
$result = $sth->fetchAll(\PDO::FETCH_ASSOC);
print_r($result);

Results:

Array
(
    [0] => Array
        (
            [NAME] => pear
            [COLOUR] => green
        )

    [1] => Array
        (
            [NAME] => watermelon
            [COLOUR] => pink
        )
)

More Related Contents:

  1. PHP / PDO echo data from database into a table
  2. Can I mix MySQL APIs in PHP?
  3. How to apply bindValue method in LIMIT clause?
  4. PDO support for multiple queries (PDO_MYSQL, PDO_MYSQLND)
  5. PDOException “could not find driver”
  6. Row count with PDO
  7. How to prevent duplicate usernames when people register?
  8. PDO get the last ID inserted
  9. Error when preparing a multiple insert query
  10. PHP PDOException: “SQLSTATE[HY093]: Invalid parameter number”
  11. pdo prepared statements with wildcards
  12. Insert multiple rows with PDO prepared statements
  13. PDO + MySQL and broken UTF-8 encoding
  14. Do SQL connections opened with PDO in PHP have to be closed
  15. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  16. php code to test pdo is available?
  17. PDO fetchAll group key-value pairs into assoc array
  18. What is the advantage of using try {} catch {} versus if {} else {}
  19. Alternative for mysql_num_rows using PDO
  20. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  21. Unknown database error in PHP but it exists in PHPMyAdmin
  22. How do detect that transaction has already been started?
  23. Binding parameters for WHERE IN clause with PDO [duplicate]
  24. return one value from database with mysql php pdo
  25. Trying to access array offset on value of type bool
  26. return multiple response data in one response
  27. How to get a query error from prepare() in PDO PHP?
  28. How can I pass an array of PDO parameters yet still specify their types?
  29. PHP PDO how to run a multiple query request?
  30. Is a BLOB converted using the current/default charset in MySQL?

Leave a Comment