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

This article mainly introduces how to use PDO in PHP, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

1. Basic knowledge 1. What is PDO?

PDO is PHP data Object, which provides a unified interface for PHP to operate multiple databases.

2. Why use PDO?

PDO is a major function newly added by PHP5. Our database server is MySQL, and the database operation of all program code is operated by a mysql () or mysqli () function. When our database needs to be replaced, such as SQL, SERVER, PostgreSQL, MS, etc., we can not modify all the program code! So it is necessary to use PDO,PDO to solve this problem. It is very convenient to use PDO. You only need to modify the data source format and load the corresponding driver file to PHP.ini.

3. What are the characteristics of PDO? 1) coding consistency

Because the various database extensions available to PHP are written by different publishers, although all of them provide basically the same features, they are not satisfied with coding consistency. PDO eliminates this inconsistency and provides a single interface for a variety of databases

2) flexibility

Because PDO loads the necessary database drivers at run time, there is no need to reconfigure and recompile PHP each time you use a different database. For example, if the database needs to switch from SQL to MySQL, simply load the PDO_MYSQL driver.

3) object-oriented features

PDO makes use of the object-oriented features of PHP5 to achieve more powerful and efficient database communication.

4) High performance

PDO is written in C and compiled into PHP, providing higher performance than other solutions written in PHP, although all others are the same.

2. PDO basically uses 1. Configuration of PDO 1) modify php.ini and add PDO extension of MySQL

Open the PHP configuration file php.ini, and find the php_pdo_mysql.dll line. Remove the semicolon to buy you.

2) there should be corresponding extension files in the extension directory

Open the PHP configuration file php.ini and find extension_dir, which is the directory where we extend the existence. First remove the previous semicolon, and then modify the extension directory. My extension directory is in "E:/Web/php/ext" and change it to extension_dir= "E:/Web/php/ext".

3) PDO connects different data with different database driver files, that is, the extension of the configuration file we added. 4) restart the server, IIS/Apache, mine is apache, make the configuration effective 2, data source configuration format 1) data source format

(1) user name and password to connect to the database and database

Syntax: $dsn = "Database type: dbname= database name; domain name of host= database"

$user = "user name of the database"

$password = "password for the database"

Example: $dsn = "mysql:dbname=test;host=127.0.0.1"

$user = "root"

$password= "123456"

(2) declare the object

$object = new PDO ($dsn,$user,$password)

3. Method explanation 1) add

Main ideas:

(1) user name and password to connect to the database and database

(2) generate PDO object

(3) perform the add

The implementation code is as follows:

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.