tags:

views:

751

answers:

3

What are the advantages of using MySQLi over MySQL?

+1  A: 

PHP Manual explains the differences

RaYell
+11  A: 

See the docs:

What is PHP's mysqli Extension?

The mysqli extension, or as it is sometimes known, the MySQL improved extension, was developed to take advantage of new features found in MySQL systems versions 4.1.3 and newer. The mysqli extension is included with PHP versions 5 and later.

The mysqli extension has a number of benefits, the key enhancements over the mysql extension being:

  • Object-oriented interface
  • Support for Prepared Statements
  • Support for Multiple Statements
  • Support for Transactions
  • Enhanced debugging capabilities
  • Embedded server support
Dominic Rodger
You're playing with fire if you're not using prepared statements, you only need to get hacked a couple of times to realize that!
Ali
@Ali: a *couple* of times?
geowa4
A: 

mysqli looks more uglier that mysql

danihf