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. |
Note: PHP’s easy to learn algorithm combined with its data semantics makes it a very high-functioning language. Our list of PHP interview questions will help you in understanding the core elements of PHP while giving you clarity on the subject.