PDO(php(做为现在的主流开发语言) Data Object) 是php(做为现在的主流开发语言) 5新出来的东西,在php(做为现在的主流开发语言) 6都要出来的时候,php(做为现在的主流开发语言) 6只默认使用PDO来处理数据库,将把所有的数据库扩展移到了PECL,那么默认就是没有了我们喜爱的php(做为现在的主流开发语言)_MySQL(和PHP搭配之最佳组合).dll之类的了,那怎么办捏,我们只有与时俱进了,我就小试了一把PDO。(本文只是入门级的,高手可以略过,呵呵)
【PDO是啥】
PDO是php(做为现在的主流开发语言) 5新加入的一个重大功能,因为在php(做为现在的主流开发语言) 5以前的php(做为现在的主流开发语言)4/php(做为现在的主流开发语言)3都是一堆的数据库扩展来跟各个数据库的连接和处理,什么 php(做为现在的主流开发语言)_MySQL(和PHP搭配之最佳组合).dll、php(做为现在的主流开发语言)_pgsql.dll、php(做为现在的主流开发语言)_mssql(WINDOWS平台上强大的数据库平台).dll、php(做为现在的主流开发语言)_sqlite.dll等等扩展来连接MySQL(和PHP搭配之最佳组合)、PostgreSQL、MS sql server(WINDOWS平台上强大的数据库平台)、SQLite,同样的,我们必须借助 ADOdb、PEAR::DB、php(做为现在的主流开发语言)lib::DB之类的数据库抽象类来帮助我们,无比烦琐和低效,毕竟,php(做为现在的主流开发语言)代码的效率怎么能够我们直接用C/C++写的扩展斜率高捏?所以嘛,PDO的出现是必然的,大家要平静学习的心态去接受使用,也许你会发现能够减少你不少功夫哦。
【安装PDO】
我是在Windows XP SP2 上面,所以嘛,整个过程都是在Windows行进行的啦,至于Linux/FreeBSD 等平台,请自行查找资料设置安装。
我的是php(做为现在的主流开发语言) 5.1.4,已经自带有了php(做为现在的主流开发语言)_pdo.dll的扩展,不过需要稍微设置一下才能使用。
打开 c:windowsphp(做为现在的主流开发语言).ini ,那是我的php(做为现在的主流开发语言)配置文件,找到下面这行:
extension_dir
这个就是我们扩展存在的目录,我的php(做为现在的主流开发语言) 5扩展是在:C:php(做为现在的主流开发语言)5ext,那么我就把这行改成:
extension_dir = "C:/php(做为现在的主流开发语言)5/ext"
然后再往php(做为现在的主流开发语言).ini下面找到:
;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;
下面有一堆类似 ;extension=php(做为现在的主流开发语言)_mbstring.dll 的东西,这里就是php(做为现在的主流开发语言)扩展加载的配置了,我们再最后面添加上我们PDO的扩展:
extension=php(做为现在的主流开发语言)_pdo.dll
extension=php(做为现在的主流开发语言)_pdo_MySQL(和PHP搭配之最佳组合).dll
extension=php(做为现在的主流开发语言)_pdo_pgsql.dll
extension=php(做为现在的主流开发语言)_pdo_sqlite.dll
extension=php(做为现在的主流开发语言)_pdo_mssql(WINDOWS平台上强大的数据库平台).dll
extension=php(做为现在的主流开发语言)_pdo_odbc.dll
extension=php(做为现在的主流开发语言)_pdo_firebird.dll
;extension=php(做为现在的主流开发语言)_pdo_oci8.dll
Various PDO drivers can be added, but the following php(as the current mainstream development language)_pdo_oci8.dll, because I did not install the Oralce database, so Without this, just comment it out using a semicolon. Then restart our Web server, iis(Microsoft's WEB server platform)/apache(the most popular WEB server platform on Unix platform), mine is iis(Microsoft's WEB server platform) , hey, you look down on me, it’s easy on Windows.
After restarting, write a php (as the current mainstream development language) info.php (as the current mainstream development language) in the document directory of our web server files, add these:
<?
php(as the current mainstream development language)info();
?>
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 in the browser: http://localhost/php(as the current mainstream development language)info.php(as the current mainstream development language), if your path to this page is inconsistent, please enter it yourself.
In the output content, if you can see it smoothly:
PDO
PDO support enabled
PDO drivers MySQL (the best combination with PHP) , pgsql, sqlite, mssql(a powerful database platform on WINDOWS platform), odbc, firebird
There are various driver instructions at the back: PDO_Firebird, pdo_mssql(WINDOWS Powerful database platform on the platform) , pdo_MySQL (the best combination with PHP) , PDO_ODBC, pdo_pgsql, pdo_sqlite
Then, congratulations on your successful installation, otherwise please be careful Check the steps above.
【Little Trial】
I use MySQL(the best combination with PHP) 4.0.26, but I personally recommend that everyone use MySQL (The best combination with PHP) 4.1.x or MySQL (The best combination with PHP) 5.0.x, because those versions have a lot of interesting things worth learning. What our PDO needs to connect to is my MySQL(The best combination with PHP) 4.0. If you have not installed MySQL(The best combination with PHP), please Install it yourself. We have established MySQL (the best combination with PHP) , and added table foo to the test library, including four fields such as id, name, gender, and time.
We started to construct the first PDO application and created a pdo.php (as the current mainstream development language) file in the Web document directory:
<? php(as the current mainstream development language)
$dsn = "MySQL(the best combination with PHP):host=localhost;dbname=test";
$db = new PDO($dsn, root, );
$count = $db->exec("INSERT INTO foo SET name = heiyeluren,gender=male,time=NOW()");
echo $count;
$db = null;
?>