Using PDO to operate MySQL

The PDO extension defines a lightweight, consistent interface for the PHP Access database, which provides a data access abstraction layer,
This allows you to execute queries and get data through consistent functions, regardless of the database you are using.

The PHP version supported by PDO is PHP5.1 and higher, and the PDO is turned on 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 database, you need to open the appropriate extension in the PHP configuration file, for example, to support MySQL, you need to open the following extension

Extension=php_pdo_mysql.dll

Here is the basic use of PDO to delete and change MySQL operation

Program code:

Header ("Content-type:text/html;charset=utf-8"); $dsn = "Mysql:dbname=test;host=localhost"; $db _user= ' root '; $db _ pass= ' admin '; try{$pdo =new PDO ($DSN, $db _user, $db _pass);} catch (Pdoexception $e) {echo ' Database connection failed '. $e->getmessage ();} Added $sql= "INSERT into buyer (username,password,email) VALUES (' FF ', ' 123456 ', ' [email protected] '); $res = $pdo->exec ($sql); Echo ' affects the number of rows: '. $res;//Modify $sql= "Update buyer set username= ' ff123 ' where id>3"; $res = $pdo->exec ($sql); Echo ' Number of rows affected: '. $res;//Query $sql= "SELECT * from Buyer", $res = $pdo->query ($sql), foreach ($res as $row) {echo $row [' username ']. ' <br/> ';} Delete $sql= "Delete from buyer where id>5"; $res = $pdo->exec ($sql); Echo ' affects number of rows: '. $res;

Using PDO to operate MySQL