PDO Cannot execute queries while other unbuffered queries are active

by

You need to free up your connection using the PDOStatement::closeCursor() method

http://www.php.net/manual/en/pdostatement.closecursor.php

I believe 

foreach($phones as $phone)
{
    $stmt = db::getInstance()->prepare("CALL phones(:phone)");
    $stmt->bindParam(':phone', $phone, PDO::PARAM_INT, 10);
    $stmt->execute();

    $stmt->closeCursor()

    $result[] = db::getInstance()->query("SELECT @phone;")->fetchAll(PDO::FETCH_ASSOC);
}

should do it for you

More Related Contents:

  1. How to avoid to display this error in PHP?
  2. Disappears \ from db value [closed]
  3. What to put in database columns when creating registration/login system? (xampp)
  4. How to properly set up a PDO connection
  5. Query with multiple values in a column
  6. Preserve Line Breaks From TextArea
  7. Search with comma-separated value mysql
  8. How to do this in Laravel, subquery where in
  9. How can I loop through a MySQL result set more than once using the mysql_* functions?
  10. PHP MySQLI Prevent SQL Injection [duplicate]
  11. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  12. WAMP Cannot access on local network 403 Forbidden
  13. How do I give each registered user their own url using PHP?
  14. MySQL “NOT IN” query 3 tables
  15. Calculating distance between zip codes in PHP
  16. Access denied for user ‘root’@’localhost’ with PHPMyAdmin
  17. LOAD DATA LOCAL INFILE forbidden in… PHP
  18. How get all values in a column using PHP?
  19. Warning: mysql_query(): 3 is not a valid MySQL-Link resource
  20. Why does this return Resource id #2? [duplicate]
  21. In PHP with PDO, how to check the final SQL parametrized query? [duplicate]
  22. Dynamically create PHP object based on string
  23. Insert current date in datetime format mySQL
  24. How to build unlimited level of menu through PHP and mysql
  25. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known
  26. select within 20 kilometers based on latitude/longitude
  27. Backup a mysql database and download as a file
  28. MYSQL select a piece of a string and order by that piece
  29. Is a BLOB converted using the current/default charset in MySQL?
  30. PHP/MySQL Pagination

Leave a Comment