PDO Unbuffered queries

by

The issue is that mysql only allows for one outstanding cursor at a given time. By using the fetch() method and not consuming all the pending data, you are leaving a cursor open.

The recommended approach is to consume all the data using the fetchAll() method.
An alternative is to use the closeCursor() method.

If you change this function, I think you will be happier:

<?php
function getValue($cn, $comando) {
    $resul = $cn->query($comando);
    if (!$resul) return null;
    foreach ($resul->fetchAll() as $res) {
            $retorno = $res[0];
            break;
    }
    return $retorno;
}
?>

More Related Contents:

  1. Why does this PDO statement silently fail?
  2. Cleansing User Passwords
  3. How to get numeric types from MySQL using PDO?
  4. How can I use PDO to fetch a results array in PHP?
  5. What are the disadvantages of using persistent connection in PDO
  6. PHP PDOException: “SQLSTATE[HY093]: Invalid parameter number”
  7. Causes of MySQL error 2014 Cannot execute queries while other unbuffered queries are active
  8. PDO prepared statement – what are colons in parameter names used for?
  9. php pdo: get the columns name of a table
  10. Use bound parameter multiple times
  11. MySQL check if a table exists without throwing an exception
  12. PDO bindParam vs. execute
  13. how safe are PDO prepared statements
  14. Error logging, in a smooth way
  15. PDO error message? [duplicate]
  16. How to read “fetch(PDO::FETCH_ASSOC);”
  17. Replacing mysql_* functions with PDO and prepared statements
  18. PDO + MySQL and broken UTF-8 encoding
  19. Is there a way to fetch associative array grouped by the values of a specified column with PDO?
  20. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  21. Why is constructing PDO connection slow?
  22. php code to test pdo is available?
  23. When *not* to use prepared statements?
  24. PDO fetchAll group key-value pairs into assoc array
  25. how to properly use while loop in PDO fetchAll
  26. PDO MySQL: Insert multiple rows in one query
  27. Binding parameters for WHERE IN clause with PDO [duplicate]
  28. PHP 7 RC3: How to install missing MySQL PDO
  29. I’m getting this error code: Invalid argument supplied for foreach() [duplicate]
  30. Is a BLOB converted using the current/default charset in MySQL?

Leave a Comment