v5:database:mysql
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
v5:database:mysql [2018/08/01 10:09] – fix variable name ssl_cert in ssl example peterdd | v5:database:mysql [2020/01/13 13:31] – Move deprecated legacy drivers to separate page dregad | ||
---|---|---|---|
Line 20: | Line 20: | ||
* [[http:// | * [[http:// | ||
- | This preferred | + | This driver uses the PHP **mysqli** interface and supports all table types, with full support for transactions and rollback when the table type supports it. |
+ | |||
+ | It replaces [[v5: | ||
- | This driver replaces both **mysql** and **mysqlt** drivers. | ||
------------------------------------------- | ------------------------------------------- | ||
- | ===== Migrating To The mysqli driver ===== | ||
- | If you are still using the // | ||
- | |||
- | |||
- | |||
- | $db = newAdoConnection(' | ||
- | to | ||
- | $db = newAdoConnection(' | ||
===== Driver Specific Issues ===== | ===== Driver Specific Issues ===== | ||
Line 73: | Line 66: | ||
- | ===== mysql driver ===== | + | {{tag> |
- | <WRAP right box round 300px> | + | |
- | == Specification == | + | |
- | ^Driver Name|mysql| | + | |
- | ^Data Provider|mysql)| | + | |
- | ^Status|Obsolete((This driver will be removed in ADOdb version 6))| | + | |
- | ^Windows|Yes| | + | |
- | ^Unix|Yes| | + | |
- | ^ADOdb V5|Yes| | + | |
- | ^ADOdb V6|No| | + | |
- | </ | + | |
- | This driver uses the PHP original mysql driver and only provides support to non-transactional tables such as MyIsam. | + | |
- | + | ||
- | * It cannot be used with the PHP ' | + | |
- | * The PHP driver 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 will be removed in ADOdb version 6.0. | + | |
- | + | ||
- | + | ||
- | ----------------------------------------------- | + | |
- | ===== mysqlt driver ===== | + | |
- | <WRAP right box round 300px> | + | |
- | == Specification == | + | |
- | ^Driver Name|mysqlt| | + | |
- | ^Data Provider|mysql)| | + | |
- | ^Status|Obsolete((This driver will be removed in ADOdb version 6))| | + | |
- | ^Windows|Yes| | + | |
- | ^Unix|Yes| | + | |
- | ^ADOdb V5|Yes| | + | |
- | ^ADOdb V6|No| | + | |
- | </ | + | |
- | This driver uses the PHP original mysql driver and provided support to transactional tables such as InnoDB. | + | |
- | + | ||
- | * It cannot be used with the PHP ' | + | |
- | * The PHP driver 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 will be removed in ADOdb version 6.0 | + | |
- | + | ||
- | -------------------------------- | + | |
- | ===== mysqlpo driver ===== | + | |
- | <WRAP right box round 300px> | + | |
- | == Specification == | + | |
- | ^Driver Name|mysqlpo| | + | |
- | ^Data Provider|mysql)| | + | |
- | ^Status|Obsolete((This driver will be removed in ADOdb version 6))| | + | |
- | ^Windows|Yes| | + | |
- | ^Unix|Yes| | + | |
- | ^ADOdb V5|Yes| | + | |
- | ^ADOdb V6|No| | + | |
- | </ | + | |
- | This driver duplicates the functionality of the mysqlt driver and is not maintained. It will be removed in ADOdb version 6.0 | + | |
- | ------------------------------------------ | + | |
- | + | ||
- | {{tag> | + | |
{{htmlmetatags> | {{htmlmetatags> |
v5/database/mysql.txt · Last modified: 2024/04/30 13:07 by dregad