Comparison of MySQL API options for PHP
Blogs20142014-02-25
Comparison of MySQL API options for PHP
The comparison table is from php.net, put here for easy retrieving:
|  | PHP’s mysqli Extension | PDO (Using PDO MySQL Driver and MySQL Native Driver) | PHP’s MySQL Extension |
|---|---|---|---|
| PHP version introduced | 5.0 | 5.0 | Prior to 3.0 |
| Included with PHP 5.x | yes | yes | Yes |
| MySQL development status | Active development | Active development as of PHP 5.3 | Maintenance only |
| Recommended by MySQL for new projects | Yes - preferred option | Yes | No |
| API supports Charsets | Yes | Yes | No |
| API supports server-side Prepared Statements | Yes | Yes | No |
| API supports client-side Prepared Statements | No | Yes | No |
| API supports Stored Procedures | Yes | Yes | No |
| API supports Multiple Statements | Yes | Most | No |
| Supports all MySQL 4.1+ functionality | Yes | Most | No |
Summary: consider to use mysqli Extension first, then PDO, then MySQL native Extension.