Home > Article > Backend Development > Detailed explanation of pdo error handling method in php
Use php here 5. Object-oriented exception handling features. If there is an exception, call pdoexception to initialize an exception class. Attribute structure of pdoexception exception class:
This exception handling class is integrated with the built-in exception handling class of PHP 5. PHP 5 built-in exception handling class structure:
Correspondingly, getfile() and getline() can be appropriately called in the code to locate the error. Make debugging easier. Use process-oriented approach Code:
pdo and pdostatement objects have errorcode() and errorinfo() methods, if there are no errors , errorcode() returns: 00000, otherwise some error code will be returned. errorinfo() returns an array, including error codes defined by PHP and error codes and error messages of MySQL. The array structure is as follows: array ( [0] => 42s22 [1] => 1054 [2] => unknown column 'aaa' in 'field list' ) After each query is executed, the result of errorcode() is the latest, so we can easily control the error message display ourselves. What should I do if I encounter errors again during the development of PHP and database using pdo? Treat it as above. 11.3.4 Error handling of pdo pdo provides two methods to obtain error information in the program, one is the errorcode() method; the other is the errorinfo() method. 1. errorcode() method Theerrorcode() method is used to obtain error codes that occur when operating database handles. These error codes are called sqlstate codes. The syntax format of this method is as follows: 01 string errorcode (void) The return value of the errorcode() method is a sqlstate. sqlstate is a code composed of 5 numbers and letters. Example of using errorcode() method:
The error code output is as shown below: 2. errorinfo() method Theerrorinfo() method is used to obtain error information that occurs when operating a database handle. The syntax format of this method is as follows: 01 array errorinfo (void) The return value of the errorinfo() method is an array, which contains relevant error information. Use errorinfo() method:
, as shown below: |