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

It is believed that many inexperienced people have no idea about how to interact with MySQL database through PDO extension. therefore, this paper summarizes the causes and solutions of the problem. I hope you can solve this problem through this article.

Today let's take a look at another PHP built-in database extension, PDO, whose full name is PHP Data Objects, or PHP data object.

1. Introduction and installation of PDO

PDO defines a lightweight and consistent interface for PHP to access the database, so it provides a data access abstraction layer, which itself can not achieve any database interaction functions, so it must use a specific database PDO driver to access database services, including MySQL, PostgreSQL, SQLite, SQL Server, Oracle and so on, so PDO is a more standard and general database extension. And it is completely object-oriented. At present, in various mainstream PHP frameworks, PDO has become the basic component of building database interaction, including Laravel framework, and also provides database access functions based on PDO extensions.

Our previously recommended PHP native integrated development environment integrates support for PDO extensions (the following are Laragon pre-installed PHP extensions):

PHP extension

And you can see that in addition to the PDO extension, there is a matching specific database extension pdo_mysql, with which you can access the MySQL database. In addition, PDO provides a unified database access interface, so the specific database extension that implements the PDO interface can access the database in exactly the same way, so that if the application needs to switch the database, there is no need to reconstruct the database operation code. With this alone, we can throw away the MySQLi extension and throw it into the arms of PDO.

If you have installed Laradock, you can start the workspace container and look at its pre-installed PHP extension. You can see that it contains more specific PDO database driver support:

PHP extension

Where pdo_pgsql represents the PostgresSQL database driver and pdo_sqlite represents the SQLite database driver.

Establishing database connection and basic query

In our tutorial, we chose to use MySQL as an example to demonstrate.

To establish a database connection through the PDO extension, you can instantiate the PDO object directly. We write a simple sample code as follows (create a new pdo.php storage code in the php_learning/mysql directory):

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.