Method 1 of error handling in PDO - errorCode() method
Method 1 of error handling in PDO - errorCode() method
There are two methods in PDO to obtain error information in the program: errorCode() method and errorInfo() method! So in the next article, we will introduce these two methods to you one by one!
Previously we introduced to you three methods for capturing SQL statement errors in PDO. If you are still unfamiliar or don’t understand something, you can review "Use the default mode-PDO: ) ##Use exception mode-PDO::ERRMODE_EXCEPTION (three methods of capturing errors in SQL statements in PDO)》Contents in these three articles! So today we will introduce to you the first method of error handling in PDO:
errorCode() method
The errorCode() method is used to obtain the error code that occurs when operating the database handle. These error codes are called: SQLSTATE codes. The syntax format of this function is as follows: ini PDOStatement::errorCode(void)
ini PDOStatement::errorCode(void)
errorCode() method returns a SQLSTATE code, which is Composed of 5 arrays and letters~
The data query operation is completed through the query() method in PDO, and the loop output of the data is completed through the foreach statement. An incorrect data table is used when defining the SQL statement. , and returns the error code through the errorCode() method. The specific implementation is as follows:
Create a php file, first connect to the MySQL database through PDO, then execute the query statement through the query() method, and then obtain it through the errorCode() method Error code, and finally complete the loop output of data through the foreach statement. The specific code is as follows:
<?php header("Content-Type:text/html; charset=utf-8"); //设置页面的编码格式 $dbms = "mysql"; // 数据库的类型 $dbName ="php_cn"; //使用的数据库名称 $user = "root"; //使用的数据库用户名 $pwd = "root"; //使用的数据库密码 $host = "localhost"; //使用的主机名称 $dsn = "$dbms:host=$host;dbname=$dbName"; try{ $pdo=new PDO($dsn,$user,$pwd);//初始化一个PDO对象,就是创建了数据库连接对象$pdo $query="select * from user_12";//需要执行的sql语句 $res=$pdo->query($query);//准备查询语句 $res->execute(); echo "errorCode 为:".$pdo->errorCode()."<br>"; ?> <table border="1" width="500"> <tr> <td height="22" align="center" valign="middle">id</td> <td height="22" align="center" valign="middle">用户名</td> <td height="22" align="center" valign="middle">密码</td> </tr> <?php foreach ($res as $items){ ?> <tr> <td height="22" align="center" valign="middle"><?php echo $items["id"];?></td> <td height="22" align="center" valign="middle"><?php echo $items["username"];?></td> <td height="22" align="center" valign="middle"><?php echo $items["password"];?></td> </tr> <?php } }catch(PDOException $e){ echo "errorCode 为:".$pdo->errorCode()."<br>"; die("Error!:".$e->getMessage().'<br>'); } ?> </table>
Note:
In the above code, when defining the SELECT query statement, we deliberately used the wrong data table name user_12 (the correct data table name is: user). This is written for testing!
The running results are as follows:
This is the end of the introduction to the errorCode() method. We will continue to introduce it to you in the next article. The second method of error handling in PDO, please read "Error handling method two in PDO - errorInfo() method" for details!
The above is the detailed content of Method 1 of error handling in PDO - errorCode() method. For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

Use middleware to improve error handling in Go functions: Introducing the concept of middleware, which can intercept function calls and execute specific logic. Create error handling middleware that wraps error handling logic in a custom function. Use middleware to wrap handler functions so that error handling logic is performed before the function is called. Returns the appropriate error code based on the error type, улучшениеобработкиошибоквфункциях Goспомощьюпромежуточногопрограммногообеспечения.Оно позволяетнамсосредоточитьсянаобработкеошибо

In C++, exception handling handles errors gracefully through try-catch blocks. Common exception types include runtime errors, logic errors, and out-of-bounds errors. Take file opening error handling as an example. When the program fails to open a file, it will throw an exception and print the error message and return the error code through the catch block, thereby handling the error without terminating the program. Exception handling provides advantages such as centralization of error handling, error propagation, and code robustness.

The best error handling tools and libraries in PHP include: Built-in methods: set_error_handler() and error_get_last() Third-party toolkits: Whoops (debugging and error formatting) Third-party services: Sentry (error reporting and monitoring) Third-party libraries: PHP-error-handler (custom error logging and stack traces) and Monolog (error logging handler)

Error handling and logging in C++ class design include: Exception handling: catching and handling exceptions, using custom exception classes to provide specific error information. Error code: Use an integer or enumeration to represent the error condition and return it in the return value. Assertion: Verify pre- and post-conditions, and throw an exception if they are not met. C++ library logging: basic logging using std::cerr and std::clog. External logging libraries: Integrate third-party libraries for advanced features such as level filtering and log file rotation. Custom log class: Create your own log class, abstract the underlying mechanism, and provide a common interface to record different levels of information.

In Go functions, asynchronous error handling uses error channels to asynchronously pass errors from goroutines. The specific steps are as follows: Create an error channel. Start a goroutine to perform operations and send errors asynchronously. Use a select statement to receive errors from the channel. Handle errors asynchronously, such as printing or logging error messages. This approach improves the performance and scalability of concurrent code because error handling does not block the calling thread and execution can be canceled.

In Go function unit testing, there are two main strategies for error handling: 1. Represent the error as a specific value of the error type, which is used to assert the expected value; 2. Use channels to pass errors to the test function, which is suitable for testing concurrent code. In a practical case, the error value strategy is used to ensure that the function returns 0 for negative input.

In Golang, error wrappers allow you to create new errors by appending contextual information to the original error. This can be used to unify the types of errors thrown by different libraries or components, simplifying debugging and error handling. The steps are as follows: Use the errors.Wrap function to wrap the original errors into new errors. The new error contains contextual information from the original error. Use fmt.Printf to output wrapped errors, providing more context and actionability. When handling different types of errors, use the errors.Wrap function to unify the error types.

There are two ways to handle errors gracefully in Go: The defer statement is used to execute code before the function returns, usually to release resources or log errors. The recover statement is used to catch panics in functions and allow the program to handle errors in a more graceful manner instead of crashing.
