Shulou(Shulou.com)06/01 Report--

How to implement additions, deletions, modifications, queries and database transactions by interacting with MySQL database through PDO extension? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

Add, delete and modify through preprocessing statements to find out why preprocessing statements are used

We briefly introduced the preprocessing statement in the previous tutorial, and we can compare it to the view template. The preprocessing statement is a predefined SQL statement template, where the specific parameter values are replaced by placeholders:

INSERT INTO REGISTRY (name, value) VALUES (?) INSERT INTO REGISTRY (name, value) VALUES (: name,: value)

Then, before the actual SQL statement is executed later, the specific parameter values are bound and mapped to the corresponding placeholders through specific API methods. Just as the defined view template also replaces the variable with a specific placeholder, and then passes the variable value into the fill and rendering when it is actually rendered.

Why go to so much trouble? Directly use the previous demonstration of the query method to add, delete, modify and search operation, isn't it fragrant? Well, then let's talk about the benefits of preprocessing statements, or why we use preprocessing statements for database interaction, there are two benefits:

First of all, the SQL template defined in advance using the preprocessing statement will only be parsed once, but it can be executed many times by passing different parameter values, so as to avoid repeated analysis, compilation and optimization of SQL statements with the same template, and improve the execution speed of database operations; secondly, the parameter values passed to the preprocessing statement will be processed by the underlying driver, so as to effectively avoid SQL injection attacks.

To sum up, from the point of view of performance and security, it is recommended to use preprocessing statements to deal with database additions, deletions, modifications and queries.

Add, delete, modify and check sample code

Next, we implement the operation of adding, deleting, modifying and querying the MySQL database based on the preprocessing statement API provided by PDO. We will implement it in an object-oriented way:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.