Update query with PDO and MySQL

by
  1. Your UPDATE syntax is wrong
  2. You probably meant to update a row not all of them so you have to use WHERE clause to target your specific row

Change

UPDATE `access_users`   
      (`contact_first_name`,`contact_surname`,`contact_email`,`telephone`) 
      VALUES (:firstname, :surname, :telephone, :email)

to

UPDATE `access_users`   
   SET `contact_first_name` = :firstname,
       `contact_surname` = :surname,
       `contact_email` = :email,
       `telephone` = :telephone 
 WHERE `user_id` = :user_id -- you probably have some sort of id

More Related Contents:

  1. PHP PDO and Mysql [closed]
  2. PDO Fetch statement only retrieves first column
  3. PHP – Using PDO with IN clause array
  4. How to properly set up a PDO connection
  5. PHP PDO prepared statements
  6. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  7. How do I set ORDER BY params using prepared PDO statement?
  8. PDO binding values for MySQL IN statement [duplicate]
  9. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  10. PDO mysql: How to know if insert was successful
  11. mysql PDO how to bind LIKE
  12. implement LIKE query in PDO
  13. PHP PDO prepared statement — MySQL LIKE query
  14. Fetching single row, single column with PDO
  15. How to install pdo driver in php docker image?
  16. How do I loop through a MySQL query via PDO in PHP?
  17. MySQL retrieve variable from Stored Procedure in PHP PDO
  18. Understanding pdo mysql transactions
  19. PDO error: SQLSTATE[HY000]: General error: 2031
  20. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  21. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  22. Use of PDO in classes [duplicate]
  23. How to handle PDO exceptions [duplicate]
  24. Check if row exists in the database before inserting
  25. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  26. PDO and MySQL Fulltext searches
  27. PHP/PDO/MySQL: inserting into MEDIUMBLOB stores bad data
  28. Is a BLOB converted using the current/default charset in MySQL?
  29. What is the PDO equivalent of function mysql_real_escape_string?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment