PDO error: SQLSTATE[HY000]: General error: 2031

by

This same error 2031 can be issued when one bind two values with the same parameter name, like in:

  • $sth->bindValue(':colour', 'blue');
  • $sth->bindValue(':colour', 'red');

..so, beware.

More Related Contents:

  1. PHP – Using PDO with IN clause array
  2. pdo prepared statements with wildcards
  3. Can I use a PDO prepared statement to bind an identifier (a table or field name) or a syntax keyword?
  4. Insert multiple rows with PDO prepared statements
  5. Replacing mysql_* functions with PDO and prepared statements
  6. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  7. Calling stored procedure with Out parameter using PDO
  8. When *not* to use prepared statements?
  9. Use of PDO in classes [duplicate]
  10. Error while using PDO prepared statements and LIMIT in query [duplicate]
  11. PHP PDO and Mysql [closed]
  12. PDO Fetch statement only retrieves first column
  13. How to properly set up a PDO connection
  14. PHP PDO prepared statements
  15. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  16. Example of how to use bind_result vs get_result
  17. PDO Prepared Inserts multiple rows in single query
  18. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  19. mysql PDO how to bind LIKE
  20. How do I use pdo’s prepared statement for order by and limit clauses?
  21. How to install pdo driver in php docker image?
  22. MySQL retrieve variable from Stored Procedure in PHP PDO
  23. Understanding pdo mysql transactions
  24. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  25. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  26. How to handle PDO exceptions [duplicate]
  27. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  28. PDO and MySQL Fulltext searches
  29. Using Prepared Statement, how I return the id of the inserted row?
  30. Is a BLOB converted using the current/default charset in MySQL?

Leave a Comment