mysqli和mysql之间的区别？[重复]-Differencebetweenmysqliandmysql?[duplicate]

15  

Use MySQLi over the older MySQL functions. The "i" stands for "improved". The list of improvements can be found in the docs.

在旧的MySQL函数上使用MySQLi。 “i”代表“改进”。可以在文档中找到改进列表。

2  

First of all, you better use PDO (as Lior suggested) or an intermediate layer (coded by you) between your code and the database functions provided by PHP, so that you can easily change mysql with mysqli or whatever your like without re-editing your whole code.

首先,你最好在你的代码和PHP提供的数据库函数之间使用PDO(如Lior建议的)或中间层(由你编码),这样你就可以轻松地用mysqli或任何你喜欢的方式更改mysql而无需重新编辑你的整个代码。

As of the differences, mysqli has more functionalities (there are a bunch of new functions) and is also object-oriented.

由于存在差异,mysqli具有更多功能(有许多新功能),并且也是面向对象的。

2  

Why not use PDO instead? You have the benefit of prepared statements amongst other features there and it would prove to be a wise decision should you decide to move to another DB one day.

为什么不使用PDO呢?你可以从那里的其他功能中获得准备好的声明,如果你决定有一天转到另一个数据库,这将是一个明智的决定。

http://php.net/manual/en/book.pdo.php

If you insist on using one of the options mentioned above, MySQLi is basically a more Object Oriented approach to the standard mysql extension. For the most part, they are functionality-wise the same. If you're building an OOP based application, MySQLi would probably be a wiser, more consistent choice.

如果你坚持使用上面提到的选项之一,那么MySQLi基本上是一种更加面向对象的标准mysql扩展方法。在大多数情况下,它们在功能方面是相同的。如果您正在构建基于OOP的应用程序,那么MySQLi可能是更明智,更一致的选择。

1  

From my point of view, the main difference (improvement) is that mysqli lets you execute multiple queries; that in turn allows you to execute (and retrieve results from) stored procedures with out parameters or which return resultset.

从我的角度来看,主要的区别(改进)是mysqli允许你执行多个查询;这反过来允许您使用out参数执行(并从中检索结果)存储过程或返回结果集。

I do agree with others that using PDO is a better choice though.

我同意其他人认为使用PDO是一个更好的选择。

0  

For all those saying to use PDO. Is it only for the prepared statements? Because you can do prepared statements in mySQLi without PDO. Just FYI.

对于那些说使用PDO的人。它只适用于准备好的陈述吗?因为你可以在没有PDO的mySQLi中做预备语句。仅供参考。