PDO Exception Questions – How to Catch Them

by

You should look at the documentation. But If you dont find anything, you can add another catch :

<?php
try {
  $stmt = $db->prepare("INSERT INTO tbl_user (id, name, password, question, answer)    VALUES (NULL, :name, :password, :question, :answer)");
  $stmt->bindValue(":name", $_POST['name']);
  $stmt->bindValue(":password", $_POST['password']);
  $stmt->bindValue(":question", $_POST['question']);
  $stmt->bindValue(":answer", $_POST['answer']);
  $stmt->execute();
  echo "Successfully added the new user " . $_POST['name'];
} catch (PDOException $e) {
  echo "DataBase Error: The user could not be added.<br>".$e->getMessage();
} catch (Exception $e) {
  echo "General Error: The user could not be added.<br>".$e->getMessage();
}
?>

This must work because all exceptions of PHP plugins herits from the Exception native PHP class. (Since 5.0 if my memory is well).

More Related Contents:

  1. Cleansing User Passwords
  2. How to apply bindValue method in LIMIT clause?
  3. How to properly set up a PDO connection
  4. Getting raw SQL query string from PDO prepared statements
  5. PDO with INSERT INTO through prepared statements [closed]
  6. Use bound parameter multiple times
  7. How to replace MySQL functions with PDO?
  8. How to debug PDO database queries?
  9. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  10. Do SQL connections opened with PDO in PHP have to be closed
  11. Using value of a column as index in results using PDO
  12. How to handle PDO exceptions [duplicate]
  13. I’m getting this error code: Invalid argument supplied for foreach() [duplicate]
  14. PDO and MySQL ‘between’
  15. PDO Return All Rows [duplicate]
  16. PHP PDO and Mysql [closed]
  17. Using PHP data in MySQL [closed]
  18. PHP PDO prepared statements
  19. Best way to get result count before LIMIT was applied
  20. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  21. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  22. Loading .sql files from within PHP
  23. PHPUnit assert that an exception was thrown?
  24. How do I use pdo’s prepared statement for order by and limit clauses?
  25. PHP: multiple SQL queries in one mysql_query statement
  26. Error while using PDO prepared statements and LIMIT in query [duplicate]
  27. PDO prepared statement fetch() returning double results
  28. Pass array literal to PostgreSQL function
  29. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  30. PHP Warning: PHP Startup: Unable to load dynamic library ‘pdo_mysql.so’

Leave a Comment