PDO error: ” SQLSTATE[HY000]: General error ” When updating database

by

You do not use fetchAll(),as in

$result = $stmt->fetchAll();

with update or insert queries. Removing this statement should rectify the problem.

More Related Contents:

  1. Insert form in MySQL with PDO [duplicate]
  2. Undefined index $_POST
  3. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  4. Are PDO prepared statements sufficient to prevent SQL injection?
  5. Reference — frequently asked questions about PDO
  6. Getting raw SQL query string from PDO prepared statements
  7. How do I set ORDER BY params using prepared PDO statement?
  8. “Invalid parameter number: parameter was not defined” Inserting data
  9. Having issue with matching rows in the database using PDO
  10. How can I properly use a PDO object for a parameterized SELECT query
  11. How do I return integer and numeric columns from MySQL as integers and numerics in PHP?
  12. pdo – Call to a member function prepare() on a non-object [duplicate]
  13. PDO with INSERT INTO through prepared statements [closed]
  14. How to replace MySQL functions with PDO?
  15. Connect to SQL Server through PDO using SQL Server Driver
  16. Real escape string and PDO [duplicate]
  17. How to check if a row exist in the database using PDO?
  18. PHP PDO vs normal mysql_connect
  19. Can I create a database using PDO in PHP?
  20. PHP PDO::bindParam() data types.. how does it work?
  21. PDO::PARAM for type decimal?
  22. PHP PDO and MySQLi [duplicate]
  23. PDO fetch one column from table into 1-dimensional array
  24. Using value of a column as index in results using PDO
  25. Retrieve (or simulate) full query from PDO prepared statement
  26. Getting a PHP PDO connection from a mysql_connect()?
  27. PDO returning incorrect, but duplicate, data. Key’s not in database.
  28. Having issue with matching rows in the database
  29. Set PDO to throw exceptions by default [duplicate]
  30. PDO and MySQL ‘between’

Leave a Comment