Interacting with MySQL database through PDO extension to achieve basic use
## on In this tutorial, I introduced you how to interact with the MySQL database through PHP's built-in Mysqli extension. Today we will take a look at another PHP built-in database extension - PDO, whose full name is PHP Data Objects, that is, PHP data objects. PDO Introduction and InstallationPDO defines a lightweight consistent interface for PHP to access the database, so it provides a data access abstraction layer and does not itself implement any database interaction functions. , you must use a PDO driver of a specific database to access database services. These specific database drivers include MySQL, PostgreSQL, SQLite, SQL Server, Oracle, etc. Therefore, PDO is a more standard and more general database extension, and it is completely object-oriented. At present, PDO has become the basic component for building database interaction in various mainstream PHP frameworks, including the Laravel framework, which also provides database access functions based on PDO extensions. The PHP local integrated development environments we previously recommended all integrate support for PDO extensions (the following are Laragon's pre-installed PHP extensions):Related learning recommendations: mysql tutorial, php programming
PDO extension, there is also a matching specific database extension pdo_mysql. Only with this specific extension can the MySQL database be accessed. In addition, PDO provides a unified database access interface, so specific database extensions that implement the PDO interface can access the database in exactly the same way. In this way, if the application needs to switch databases, there is no need to reconstruct the database operation code. Based on this alone, you can throw away the MySQLi extension and embrace PDO.
workspace container, and then view its pre-installed PHP extension. You can see that it contains more specific PDO database driver support:
pdo_pgsql represents the PostgresSQL database driver, pdo_sqlite represents the SQLite database driver.
pdo.php in the php_learning/mysql directory Storage code):
<?php
// 设置连接属性
$dsn = 'mysql:host=127.0.0.1;port=3306;dbname=test;charset=utf8mb4';
$user = 'root';
$pass = 'root';
try {
// 建立连接
$pdo = new PDO($dsn, $user, $pass);
// 执行 SQL 查询
$sql = $pdo->quote('SELECT * FROM `post` ORDER BY `id` DESC');
$res = $pdo->query($sql);
// 打印查询结果
echo '<pre class="brush:php;toolbar:false">';
foreach ($res as $row) {
print_r($row);
}
} catch (PDOException $exception) {
// 如果数据库操作出现异常，则捕获并打印
printf("Error: %s\n", $exception->getMessage());
} finally {
// 释放 PDO 连接实例
$pdo = null;
}mysql), IP address (the local address is 127.0.0.1), port number (optional, the default is 3306), and the name of the database to be connected (test), character encoding information (utf8mb4), etc. The second parameter is the user name, and the third parameter is the password.
$pdo to execute the specified SQL statement to interact with the database (add, delete, modify, check), but before that, we first The quote method is called to escape the query SQL statement. The function of this function is similar to mysqli_escape_string.
try...catch... The statement captures the PDOException exception, prints the error message, and finally releases the PDO object instance through the finally statement, because this statement block will be executed regardless of whether an exception is thrown.
php -S localhost:9000 Start the built-in HTTP server for testing, visit http://localhost:9000/mysql/pdo.php in the browser , you can see the normal printing result:
test, this The PDO exception will be caught and the error message will be printed:
Note: The IP address in the error message is the IP address inside the MySQL Docker container. It can be ignored. This error is caused by a wrong password, not an IP address problem.
If you want to know more related articles, please pay attention to the php mysql column!
The above is the detailed content of Interacting with MySQL database through PDO extension to achieve basic use. 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
MySQL's Role: Databases in Web Applications
Apr 17, 2025 am 12:23 AM
The main role of MySQL in web applications is to store and manage data. 1.MySQL efficiently processes user information, product catalogs, transaction records and other data. 2. Through SQL query, developers can extract information from the database to generate dynamic content. 3.MySQL works based on the client-server model to ensure acceptable query speed.
How to start mysql by docker
Apr 15, 2025 pm 12:09 PM
The process of starting MySQL in Docker consists of the following steps: Pull the MySQL image to create and start the container, set the root user password, and map the port verification connection Create the database and the user grants all permissions to the database
Laravel Introduction Example
Apr 18, 2025 pm 12:45 PM
Laravel is a PHP framework for easy building of web applications. It provides a range of powerful features including: Installation: Install the Laravel CLI globally with Composer and create applications in the project directory. Routing: Define the relationship between the URL and the handler in routes/web.php. View: Create a view in resources/views to render the application's interface. Database Integration: Provides out-of-the-box integration with databases such as MySQL and uses migration to create and modify tables. Model and Controller: The model represents the database entity and the controller processes HTTP requests.
Solve database connection problem: a practical case of using minii/db library
Apr 18, 2025 am 07:09 AM
I encountered a tricky problem when developing a small application: the need to quickly integrate a lightweight database operation library. After trying multiple libraries, I found that they either have too much functionality or are not very compatible. Eventually, I found minii/db, a simplified version based on Yii2 that solved my problem perfectly.
How to install mysql in centos7
Apr 14, 2025 pm 08:30 PM
The key to installing MySQL elegantly is to add the official MySQL repository. The specific steps are as follows: Download the MySQL official GPG key to prevent phishing attacks. Add MySQL repository file: rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm Update yum repository cache: yum update installation MySQL: yum install mysql-server startup MySQL service: systemctl start mysqld set up booting
Laravel framework installation method
Apr 18, 2025 pm 12:54 PM
Article summary: This article provides detailed step-by-step instructions to guide readers on how to easily install the Laravel framework. Laravel is a powerful PHP framework that speeds up the development process of web applications. This tutorial covers the installation process from system requirements to configuring databases and setting up routing. By following these steps, readers can quickly and efficiently lay a solid foundation for their Laravel project.
MySQL and phpMyAdmin: Core Features and Functions
Apr 22, 2025 am 12:12 AM
MySQL and phpMyAdmin are powerful database management tools. 1) MySQL is used to create databases and tables, and to execute DML and SQL queries. 2) phpMyAdmin provides an intuitive interface for database management, table structure management, data operations and user permission management.
Centos install mysql
Apr 14, 2025 pm 08:09 PM
Installing MySQL on CentOS involves the following steps: Adding the appropriate MySQL yum source. Execute the yum install mysql-server command to install the MySQL server. Use the mysql_secure_installation command to make security settings, such as setting the root user password. Customize the MySQL configuration file as needed. Tune MySQL parameters and optimize databases for performance.
