Table of Contents
Legacy MySQL drivers
This page references the legacy MySQL drivers, which are deprecated since ADOdb 5.20 and were removed in 5.22.
Please refer to MySQL for the current, supported driver (mysqli).
Migrating to the mysqli driver
If you are still using the legacy mysql, mysqlt or mysqlpo drivers, you should be planning on migrating to the mysqli driver. Support for both drivers is built into PHP up to version PHP 5.4. From an ADOdb standpoint, it is simply a case of switching from
$db = newAdoConnection('mysql')
to
$db = newAdoConnection('mysqli')
mysql driver
Specification
| Driver Name | mysql |
|---|---|
| Data Provider | mysql) |
| Status | Obsolete1) |
| Windows | Yes |
| Unix | Yes |
| ADOdb V5 | Yes |
| ADOdb V6 | No |
This driver uses the PHP original mysql extension and only provides support to non-transactional tables such as MyIsam.
- It cannot be used with the PHP 'Improved' MySQL driver.
- The PHP extension is deprecated as of PHP Version 5.5 and will be removed in PHP version 7.
- This driver is deprecated as of ADOdb version 5.20 and has been removed in ADOdb version 5.22.1.
mysqlt driver
Specification
| Driver Name | mysqlt |
|---|---|
| Data Provider | mysql) |
| Status | Obsolete2) |
| Windows | Yes |
| Unix | Yes |
| ADOdb V5 | Yes |
| ADOdb V6 | No |
This driver uses the PHP original mysql extension and provided support to transactional tables such as InnoDB.
- It cannot be used with the PHP 'improved' MySQL driver.
- The PHP extension is deprecated as of PHP Version 5.5 and will be removed in PHP version 7.
- This driver is deprecated as of ADOdb version 5.20 and has been removed in ADOdb version 5.22.1
mysqlpo driver
Specification
| Driver Name | mysqlpo |
|---|---|
| Data Provider | mysql) |
| Status | Obsolete3) |
| Windows | Yes |
| Unix | Yes |
| ADOdb V5 | Yes |
| ADOdb V6 | No |
This driver duplicates the functionality of the mysqlt driver and is not maintained. It has been removed in ADOdb version 5.22.1