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.
BY Best Interview Question ON 06 Jul 2020