PHP PDO与普通的mysql_connect [英] PHP PDO vs normal mysql_connect

问题描述

我应该使用php PDO还是普通的mysql_connect在PHP中执行数据库查询?

Should I use php PDO or normal mysql_connect to execute database queries in PHP?

哪个更快?

PDO的一大优点是接口在多个数据库之间是一致的. 对于准备好的语句也有一些很酷的功能，这些功能避免了转义所有查询字符串的麻烦. PDO的可移植性大于mysql_connect.

One of the big benefits of PDO is that the interface is consistent across multiple databases. There are some cool functions for prepared statements too, which take some of the hassle out of escaping all your query strings. The portability of PDO is greater than mysql_connect.

那么，出于这些原因，我应该使用PDO还是坚持使用传统的mysql_connect?

So, should I use PDO for those reasons or stick to the traditional mysql_connect?

推荐答案

PDO比mysql_ *慢一些 但是它具有很大的可移植性. PDO提供跨多个数据库的单个接口.这意味着您可以使用多个数据库，而无需将mysql_query用于mysql，将mssql_query用于MS sql等.始终使用$ db-> query("INSERT INTO ...")之类的东西.无论您使用哪种数据库驱动程序.

PDO is a bit slower than the mysql_* But it has great portability. PDO provides single interface across multiple databases. That means you can use multiple DB without using mysql_query for mysql, mssql_query for MS sql etc. Just use something like $db->query("INSERT INTO...") always. No matter what DB driver you are using.

因此，对于大型或便携式项目，PDO是可取的.甚至zend框架都使用PDO.

So, for larger or portable project PDO is preferable. Even zend framework use PDO.

这篇关于PHP PDO与普通的mysql_connect的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！