What is pdo in PHP? What are the advantages of accessing a database? What does extension do?

The previous article introduced you to "How to use try...case syntax in PHP? 》, this article continues to introduce to you what is pdo in PHP? What are the advantages of accessing a database? What does extension do? It has certain reference value. Friends in need can refer to it. I hope it will be helpful to everyone.

#1. What is PDO

php date object php data object It is a kind of database abstraction layer

2. What is the database abstraction layer

Taobao

马云php mysql

Who wants to replace the mysql database in the project with an oracle database? ?

What do we need to do if it involves database replacement?

1. Data migration mysq1 data into the oracle database

2. Connect all PHP in the project The code of mysq1 must be replaced with oracle (you also need to learn how to connect php to oracle)

3. Debugging program to modify BUG

Our background development program uses PHP, and we connect mysql through PHP way, and then operate the database,

If all databases need to be changed to oracle databases, we need to change to oracle databases, and then use the database to connect to oracle

3. Learn that Database abstraction layer?

PDO

4. Why should we learn PDO?

1. Directly enter the system in the form of modules , high execution efficiency.

2. The official website recommends using PDO as the database abstraction layer

3. Written by official staff. Chinese people write

4. PHP version has enabled PDO by default since version 5.3

What are the advantages of PDO accessing the database?

1: PDO is truly a unified interface database operation interface implemented at the bottom layer. No matter what kind of database is used in the backend, if the code is encapsulated, the application layer calls are basically the same. When the back-end database is replaced, the application layer code basically does not need to be modified.
2: PDO supports more advanced DB feature operations, such as: scheduling of stored procedures, etc., which is not supported by the mysql native library.
3: PDO is the official PECL library of PHP. Its compatibility and stability must be higher than MySQL Extension. You can directly use the pecl upgrade pdo command to upgrade.
4: PDO can prevent SQL injection and ensure that the database is more secure

What is the role of PDO extension in PHP?

• PDO is the abbreviation of PHP Data Object. You cannot use the PDO extension itself to perform any database operations. You must use a database-specific PDO driver (PDO driver for a specific database) to access the database server.
  PDO does not provide database abstraction. It does not rewrite SQL or provide functions missing from the database itself. If you need this function, you need to use a more mature abstraction layer.
  PDO requires support for PHP5 core OO features, so it cannot run on previous PHP versions.

Recommended learning: php video tutorial

The above is the detailed content of What is pdo in PHP? What are the advantages of accessing a database? What does extension do?. For more information, please follow other related articles on the PHP Chinese website!