What new features are introduced in MYSQLi?
MySQLi extension has been specifically developed to take advantage of the new features available in MySQL Server version 4.1.3 and above. MySQLi protects users from SQL injection, with the help of prepared statements, a safer way to send data. MySQLi, unlike MySQL, is object oriented. MySQLi supports multiple Statements, Complex Transaction statements and has enhanced debugging capabilities and embedded server support. MySQL handles transactions through queries only, whereas MySQLi supports APIs as well.