Detailed explanation of how PDO operates MySQL in PHP

This article mainly introduces the method of operating MySQL with PHP PDO. It analyzes in detail the operating techniques related to opening PDO and database creation, connection, addition, deletion, modification and query in PHP based on examples. Friends in need can refer to the following

The details are as follows:

The PDO extension in PHP defines a lightweight, consistent interface for PHP to access the database. It provides a data access abstraction layer, so that no matter what database is used, it can be accessed through Consistent functions execute queries and retrieve data.

The PHP version supported by PDO is PHP5.1 and higher, and PDO is enabled by default under PHP5.2.

The following is the configuration of PDO in php.ini:

extension=php_pdo.dll

In order to enable support for a certain database, you need to open the corresponding extension in the php configuration file. For example, to support MySQL, you need to open the following extension

extension=php_pdo_mysql.dll

The following is to use PDO to perform basic add, delete, modify and query operations on mysql

Create the test database, and then run the following SQL statement:

DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
`id` int(10) NOT NULL DEFAULT '0',
`user` char(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_age` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Program code:

<?php
header("content-type:text/html;charset=utf-8");
$dsn="mysql:dbname=test;host=localhost";
$db_user=&#39;root&#39;;
$db_pass=&#39;admin123&#39;;
try{
$pdo=new PDO($dsn,$db_user,$db_pass);
}catch(PDOException $e){
echo &#39;数据库连接失败&#39;.$e->getMessage();
}
//新增
$sql="insert into test (id,user) values (1,&#39;phpthinking&#39;)";
$res=$pdo->exec($sql);
echo &#39;影响行数：&#39;.$res;
//修改
$sql="update test set user=&#39;phpthinking&#39; where id=1";
$res=$pdo->exec($sql);
echo &#39;影响行数：&#39;.$res;
//查询
$sql="select * from test";
$res=$pdo->query($sql);
foreach($res as $row){
echo $row[&#39;user&#39;].&#39;<br/>&#39;;
}
//删除
$sql="delete from test where id=1";
$res=$pdo->exec($sql);
echo &#39;影响行数：&#39;.$res;

Related recommendations:

Instance analysis of PDO database operation class encapsulated by PHP

PHP method of implementing SQLite operation class based on PDO

php inpdoPublic class definition and usage

The above is the detailed content of Detailed explanation of how PDO operates MySQL in PHP. For more information, please follow other related articles on the PHP Chinese website!