Example Analysis of Security processing and transaction handling in PDO

Today, I will talk to you about the example analysis of security processing and thing processing in PDO. Many people may not know much about it. In order to let you know more, Xiaobian summarizes the following contents for you. I hope you can gain something according to this article.

Transaction is a very important feature of an operational database, which allows you to order a SQL statement or a series of SQL statements and execute them together, and in the process, if one of them fails, you can roll back all the changed operations. If executed successfully, then this series of operations will be permanently effective. Transactions are a good solution to the problem of operating out of sync with the database. At the same time, when executing large amounts of data through transactions, execution efficiency can be improved a lot.

Transaction processing has four characteristics: atomicity, consistency, independence, and persistence. Not all databases support transaction processing, PDO provides transaction support for databases capable of performing transaction processing.

1.PDO exception handling

PDO::ATTR_ERRMODE

1)PDO::ATTR_ERRMODE//No error reported (ignored)(0)

2) PDO::ERRMODE_WARNING

//error in warning mode (1)

3)PDO::ERRMODE_EXCEPTION //Error reported in an abnormal manner (2)