PDO multiple queries

by

It turns out that you need to use PDOStatement::nextRowset.

$stmt   = $db->query("SELECT 1; SELECT 2;");
$stmt->nextRowset();
var_dump( $stmt->fetchAll(PDO::FETCH_ASSOC) );

This will return result for the second query.

It is a bit odd implementation. It would certainly be easier if multi-query statement would just return both results sets under one array. However, the advantage is that this implementation allows to fetch every query using different FETCH styles.

More Related Contents:

  1. PDOException SQLSTATE[HY000] [2002] No such file or directory
  2. PHP PDO: charset, set names?
  3. How to get numeric types from MySQL using PDO?
  4. How can I use PDO to fetch a results array in PHP?
  5. PHP PDOException: “SQLSTATE[HY093]: Invalid parameter number”
  6. Use bound parameter multiple times
  7. What is the difference between MySQL, MySQLi and PDO? [closed]
  8. MySQL check if a table exists without throwing an exception
  9. how safe are PDO prepared statements
  10. Can I use a PDO prepared statement to bind an identifier (a table or field name) or a syntax keyword?
  11. PHP PDO – Num Rows
  12. How to solve General error: 2006 MySQL server has gone away
  13. How to install pdo driver in php docker image?
  14. Replacing mysql_* functions with PDO and prepared statements
  15. MySQL retrieve variable from Stored Procedure in PHP PDO
  16. Understanding pdo mysql transactions
  17. Calling stored procedure with Out parameter using PDO
  18. When *not* to use prepared statements?
  19. How to insert an array into a single MySQL Prepared statement w/ PHP and PDO
  20. Setting a connect timeout with PDO
  21. In PHP with PDO, how to check the final SQL parametrized query? [duplicate]
  22. What is the best way to insert multiple rows in PHP PDO MYSQL?
  23. PDO MySQL: Insert multiple rows in one query
  24. How to bind LIKE values using the PDO extension?
  25. Error while using PDO prepared statements and LIMIT in query [duplicate]
  26. PDO prepared statement fetch() returning double results
  27. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  28. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  29. PHP 7 RC3: How to install missing MySQL PDO
  30. Using PDO Prepared Statement and Incrementing a column value

Leave a Comment