What is the difference between mysql and mysqli?
| MySQL | 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!
