What is the difference between MySQL and MySQLi interfaces in PHP?

 in relation to PHP, MySQL is the old database driver, and MySQLi is the Improved driver. MySQLi takes advantage of the newer features of MySQL5. Lifted verbatim from the php.net site:

• Object-oriented interface
• Support for Prepared Statements
• Support for Multiple Statements
• Support for Transactions
• Enhanced debugging capabilities
• Embedded server support

You have the choice of using mysql, mysqli, or PDO essentially.

source

Cheers!