What is the difference between mysql and mysqli?

This extension was added in version 2.0 of PHP and deprecated with PHP 5.5.0. Added in PHP 5.5 and is capable to work on MYSQL 4.1.3 or above.
No support for prepared statements. Supports prepared statements.
Offers procedural interface. Offers procedural interface as well as object-oriented interface.
No support for the stored procedure. Supports store procedure.
Lags with security and other special features. Users will receive here better security and advanced debugging.
Only SQL queries handled transactions. It supports API transaction.

Suggest An Answer

No suggestions avaliable!

Latest post from PHP interview questions

Ask Question