Home >Backend Development >PHP Tutorial >Recommended articles about abnormal patterns
Use exception mode -PDO::ERRMODE_EXCEPTION (Method 3 for capturing errors in SQL statements in PDO) exception mode will create a PDOException and set the erorCode attribute, which can encapsulate the execution code into a try{...}catch In the {...} statement, uncaught exceptions will cause the script to interrupt and display a stack trace to let the user understand where the problem occurred! In the first two articles "Using the default mode-PDO::ERRMODE_SILENT (Method 1 to capture errors in SQL statements in PDO)" and "Using warning mode-PDO::ERRMODE_WARNING (Method 2 to capture errors in SQL statements in PDO)" We have introduced two methods: default mode and exception mode, so today we will introduce the third method to capture errors in SQL statements in PDO ~ Another very useful thing about exception mode is that it can be clearer than traditional PHP style warnings You can easily build your own error handling, and exception mode requires less code/nesting than silent mode and explicitly checking the return value of each database call. Except
1. Recommended articles about PDO::ERRMODE_EXCEPTION
##Introduction: Use exception mode-PDO::ERRMODE_EXCEPTION (Method 3 to capture errors in SQL statements in PDO) Exception mode will create a PDOException and set the erorCode attribute, which can encapsulate the execution code into a try{... In the }catch{...} statement, uncaught exceptions will cause the script to interrupt, and a stack trace will be displayed to let the user understand where the problem occurred! In the first two articles "Using the default mode-PDO::ERRMODE_SILENT(Capturing S...
2. Using the exception mode-PDO::ERRMODE_EXCEPTION(PDO Method 3 for capturing errors in SQL statements)
##Introduction: Exception mode will create a PDOException and set erorCode attribute, which can encapsulate the execution code into a try{...}catch{...} statement. Uncaught exceptions will cause the script to interrupt and display a stack trace to let the user understand where the problem occurred!
##3.
PHP pdo, why doesn’t it throw an exception?##Introduction: The following code: {Code... } The following SQL will be generated, {code...} When executing the above statement with PHP, no errors will occur and no exception will be thrown. The exception throwing mode of pdo has been turned on {code...} However, it will appear when executed with phpmyadmin. The following error
## [Related Q&A recommendations]:
PHP pdo, why does it not throw an exception?
The above is the detailed content of Recommended articles about abnormal patterns. For more information, please follow other related articles on the PHP Chinese website!