mysql&之间的区别mysqli [英] Difference between mysql & mysqli

问题描述

可能重复:
mysql与php中的mysqli

Possible Duplicate:
mysql vs mysqli in php

mysql_* functions和mysqli_* functions有什么区别?我们不应该使用mysql_* functions背后的任何技术原因吗?

What is the difference between mysql_* functions and mysqli_* functions? Is there any technical reasons behind we shouldn't use mysql_* functions?

推荐答案

"i"代表改进".可以在此处中找到改进列表.

The "i" stands for "improved". The list of improvements can be found in here.

MySQLi是MySQL扩展的OOP版本.最后，MySQLi和MySQL完成了相同的事情:它们是从PHP与MySQL进行交互的扩展.许多人仍然使用原始的MySQL扩展而不是新的MySQLi扩展，因为MySQLi需要MySQL 4.1.13+和PHP 5.0.7 +.

MySQLi is the OOP version of MySQL extension. In the end, MySQLi and MySQL accomplish the same thing: they are extension for interacting with MySQL from PHP. A lot of people still use the original MySQL extension instead of the new MySQLi extension because MySQLi requires MySQL 4.1.13+ and PHP 5.0.7+ .

MySQLi支持旧的MySQL扩展不支持的某些功能.诸如准备好的语句，多条语句和事务之类的事情浮现在我头上.

MySQLi supports some things that the old MySQL extension doesn't. Things like prepared statements, multiple statements, and transactions on top of my head.

这篇关于mysql&之间的区别mysqli的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！