Comprehensively learn PHP PDO installation and use

Comprehensively learn PHP PDO installation and use_PHP tutorial

WBOY

Release： 2016-07-15 13:28:14

Original

1021 people have browsed it

With the rapid development of PHP, its functions are becoming more and more powerful. PDO (PHP Data Object) is a new thing in PHP 5. When PHP 6 is about to be released, PHP 6 will only use it by default. PDO handles databases and will move all database extensions to PECL. Then by default, our favorite php_mysql.dll will no longer exist. So what should we do? We can only keep pace with the times, so I gave it a try. Put PDO. (This article is only entry-level, experts can skip it, haha)

What is PHP PDO?

What is PDO A major new feature added to PHP 5, because before PHP 5, php4/php3 had a bunch of database extensions to connect and process each database, such as php_mysql.dll, php_pgsql.dll, php_mssql.dll, php_sqlite.dll Wait for extensions to connect to MySQL, PostgreSQL, MS SQL Server, SQLite. Similarly, we must use database abstract classes such as ADOdb, PEAR::DB, PHPlib::DB to help us, which is extremely cumbersome and inefficient. After all, How can the efficiency of PHP code be so high that we write it directly in C/C++? Therefore, the emergence of PDO is inevitable. Everyone should accept its use with a calm learning attitude. Maybe you will find that it can save you a lot of effort.

Installing PHP PDO

I am on Windows XP SP2, so the whole process is done on Windows. As for Linux/FreeBSD and other platforms, Please find the information and set up the installation by yourself.
Mine is PHP 5.1.4, which already comes with the php_pdo.dll extension, but it requires a little setup before it can be used.

Open c:windowsphp.ini, which is my PHP configuration file. Find the following line:

<ol class="dp-xml"><li class="alt"><span><span>extension_dir </span></span></li></ol>

Copy after login

This is the directory where our extension exists. My PHP 5 extension is in :C:php5ext, then I will change this line to:

<ol class="dp-xml"><li class="alt"><span><span class="attribute"><font color="#ff0000">extension_dir</font></span><span> = </span><span class="attribute-value"><font color="#0000ff">"C:/php5/ext"</font></span><span> </span></span></li></ol>

Copy after login

Then go to php.ini and find:

<ol class="dp-xml"><li class="alt"><span><span>Dynamic Extensions ; </span></span></li></ol>

Copy after login

There are a bunch of similar;extension below =php_mbstring.dll, here is the configuration of PHP extension loading, we will add our PDO extension at the end:

<ol class="dp-xml">
<li class="alt"><span><span class="attribute"><font color="#ff0000">extension</font></span><span>=</span><span class="attribute-value"><font color="#0000ff">php_pdo</font></span><span>.dll  </span></span></li>
<li class="">
<span></span><span class="attribute"><font color="#ff0000">extension</font></span><span>=</span><span class="attribute-value"><font color="#0000ff">php_pdo_mysql</font></span><span>.dll  </span>
</li>
<li class="alt">
<span></span><span class="attribute"><font color="#ff0000">extension</font></span><span>=</span><span class="attribute-value"><font color="#0000ff">php_pdo_pgsql</font></span><span>.dll  </span>
</li>
<li class="">
<span></span><span class="attribute"><font color="#ff0000">extension</font></span><span>=</span><span class="attribute-value"><font color="#0000ff">php_pdo_sqlite</font></span><span>.dll  </span>
</li>
<li class="alt">
<span></span><span class="attribute"><font color="#ff0000">extension</font></span><span>=</span><span class="attribute-value"><font color="#0000ff">php_pdo_mssql</font></span><span>.dll  </span>
</li>
<li class="">
<span></span><span class="attribute"><font color="#ff0000">extension</font></span><span>=</span><span class="attribute-value"><font color="#0000ff">php_pdo_odbc</font></span><span>.dll  </span>
</li>
<li class="alt">
<span></span><span class="attribute"><font color="#ff0000">extension</font></span><span>=</span><span class="attribute-value"><font color="#0000ff">php_pdo_firebird</font></span><span>.dll  </span>
</li>
<li class="">
<span>;</span><span class="attribute"><font color="#ff0000">extension</font></span><span>=</span><span class="attribute-value"><font color="#0000ff">php_pdo_oci8</font></span><span>.dll </span>
</li>
</ol>

Copy after login

Various PHP PDO drivers, all that can be added are provided In addition, the following php_pdo_oci8.dll, because I have not installed the Oralce database, does not have this, so I use a semicolon to comment it out. Then restart our web server, IIS/Apache, mine is IIS, hey, you look down on me, on Windows, it’s easy.

After restarting, write a phpinfo.php file in the document directory of our web server, add these:

<ol class="dp-xml">
<li class="alt"><span><span>＜?  </span></span></li>
<li class=""><span>phpinfo();  </span></li>
<li class="alt"><span>?＞ </span></li>
</ol>

Copy after login

Then open our lovely browser: IE/FireFox, Mine is FireFox 2.0, I just downloaded it, it’s great, I’m not afraid of rogue software, haha. Enter: http://localhost/phpinfo.php in the browser. If your path to this page is inconsistent, please enter it yourself. In the output content, if you can successfully see:

<ol class="dp-xml">
<li class="alt"><span><span>PDO  </span></span></li>
<li class=""><span>PDO support enabled  </span></li>
<li class="alt"><span>PDO drivers mysql, pgsql, sqlite, mssql, odbc, firebird </span></li>
</ol>

Copy after login

followed by various driver instructions: PDO_Firebird, pdo_mssql, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, then congratulations on your successful installation, otherwise Please check the steps above carefully