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 | ||
database:mysql [2015/08/15 00:43] – mnewnham | v5:database:mysql [2020/01/13 13:31] – Move deprecated legacy drivers to separate page dregad | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== MySQL ===== | ====== MySQL ===== | ||
- | ====== mysqli driver | + | ~~NOTOC~~ |
- | < | + | ===== mysqli driver ===== |
- | |Driver Name|mysqli| | + | < |
- | |Status|Active| | + | == Specification == |
- | |Windows|Yes| | + | ^Driver Name|mysqli| |
- | |Unix|Yes| | + | ^Data Provider|mysql| |
+ | ^Status|Active((This driver is actively supported by ADOdb project members))| | ||
+ | ^Windows|Yes| | ||
+ | ^Unix|Yes| | ||
+ | ^ADOdb V5|Yes| | ||
+ | ^ADOdb V6|Yes| | ||
+ | == Alternatives == | ||
+ | [[v5: | ||
</ | </ | ||
- | This preferred driver uses the PHP mysqli interface and supports all MySQL table types. | ||
- | ---------------------------------------------- | + | ** This is the preferred driver for connections to the following databases: |
+ | * [[http:// | ||
+ | * [[http:// | ||
+ | * [[http:// | ||
+ | |||
+ | 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: | ||
+ | |||
+ | ------------------------------------------- | ||
+ | |||
+ | ===== Driver Specific Issues ===== | ||
+ | ==== renameColumnSql ==== | ||
+ | The method [[v5: | ||
+ | '' | ||
+ | ==== Usage ==== | ||
+ | <code php> | ||
+ | /* | ||
+ | * We are going to rename a column from col9 to col6. | ||
+ | */ | ||
+ | $flds = 'col6 C(50) NOTNULL DEFAULT " | ||
+ | |||
+ | # Then create a data dictionary object, using this connection | ||
+ | $dict = NewDataDictionary($db); | ||
+ | |||
+ | $sql = $dict-> | ||
+ | </ | ||
+ | ==== Connecting With SSL ==== | ||
+ | From ADOdb version 5.21, you can make an SSL connection to MySQL in the following way: | ||
+ | |||
+ | <code php> | ||
+ | /* | ||
+ | * Enable ADOdb | ||
+ | */ | ||
+ | $db = newAdoConnection(' | ||
+ | /* | ||
+ | * Set the SSL parameters | ||
+ | */ | ||
+ | $db-> | ||
+ | $db-> | ||
+ | $db-> | ||
+ | $db-> | ||
+ | $db-> | ||
+ | |||
+ | /* | ||
+ | * Open the connection | ||
+ | */ | ||
+ | $db-> | ||
+ | </ | ||
- | ====== mysql driver ====== | ||
- | <WRAP left 300px box> | ||
- | |Driver Name|mysql| | ||
- | |Status|Deprecated| | ||
- | |Windows|Yes| | ||
- | |Unix|Yes| | ||
- | </ | ||
- | This driver uses the PHP original mysql driver and provides support to non-transactional tables. 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 left 300px box> | ||
- | |Driver Name|mysqlt| | ||
- | |Status|Deprecated| | ||
- | |Windows|Yes| | ||
- | |Unix|Yes| | ||
- | </ | ||
- | This driver uses the PHP original mysql driver and provides support to transactional tables. 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 left 300px box> | ||
- | |Driver Name|mysqlpo| | ||
- | |Status|Obsolete| | ||
- | |Windows|Yes| | ||
- | |Unix|Yes| | ||
- | </ | ||
- | This driver duplicates the functionality of the mysqlt driver and is not maintained. It will be removed in ADOdb version 6.0 | ||
- | {{tag> | + | {{tag> |
+ | {{htmlmetatags> |
v5/database/mysql.txt · Last modified: 2024/04/30 13:07 by dregad