v5:database:pdo_new
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
v5:database:pdo_new [2022/03/20 19:47] – mnewnham | v5:database:pdo_new [2023/01/24 04:00] (current) – mnewnham | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== PDO ====== | + | ====== PDO (new) ====== |
+ | <WRAP important> | ||
+ | This is still [[https:// | ||
+ | Feedback is welcome, just add your comments in the pull request. | ||
+ | </ | ||
~~NOTOC~~ | ~~NOTOC~~ | ||
<WRAP right box round 300px> | <WRAP right box round 300px> | ||
Line 14: | Line 19: | ||
===== Description ===== | ===== Description ===== | ||
- | This driver supports connections using the standardized [[http:// | + | This driver supports connections using the standardized [[http:// |
Except for the '' | Except for the '' | ||
+ | ------------------------------------------------------- | ||
+ | ===== Quick Upgrade Notes ==== | ||
+ | <WRAP info> | ||
+ | * Instead of '' | ||
+ | * Passing a DSN statement to '' | ||
+ | * Do not start the DSN statement with the driver name | ||
+ | |||
+ | </ | ||
------------------------------------------------------------- | ------------------------------------------------------------- | ||
====Supported drivers==== | ====Supported drivers==== | ||
Line 22: | Line 35: | ||
^PHP Driver^Description^ADOdb Connector^ | ^PHP Driver^Description^ADOdb Connector^ | ||
|pdo_firebird|Firebird|firebird| | |pdo_firebird|Firebird|firebird| | ||
- | |pdo_ibm|IBM DB2|db2| | + | |pdo_ibm|IBM DB2|ibm| |
|pdo_informix|IBM Informix|informix| | |pdo_informix|IBM Informix|informix| | ||
|pdo_mysql|MySQL|mysql| | |pdo_mysql|MySQL|mysql| | ||
|pdo_oci|Oracle|oci| | |pdo_oci|Oracle|oci| | ||
- | |pdo_odbc|Generic ODBC|odbc | + | |pdo_odbc|Generic ODBC|odbc| |
|pdo_pgsql|Postgresql|pgsql| | |pdo_pgsql|Postgresql|pgsql| | ||
|pdo_sqlite|SQLite|sqlite| | |pdo_sqlite|SQLite|sqlite| | ||
- | |pdo_sqlsrv|SQL Server | + | |pdo_sqlsrv|Microsoft |
====Unsupported Drivers==== | ====Unsupported Drivers==== | ||
Line 117: | Line 130: | ||
* This driver requires the installation of the IBM DB2 client | * This driver requires the installation of the IBM DB2 client | ||
+ | * See the [[v5: | ||
------------------------------------------------------- | ------------------------------------------------------- | ||
Line 124: | Line 138: | ||
$db = ADOnewConnection(' | $db = ADOnewConnection(' | ||
- | $dsn = ' | + | $dsn = ' |
$dsn.= ' | $dsn.= ' | ||
$user = ''; | $user = ''; | ||
Line 140: | Line 154: | ||
* There is no native mode driver for IBM Informix Connections | * There is no native mode driver for IBM Informix Connections | ||
* This driver requires the installation of the IBM Informix Client | * This driver requires the installation of the IBM Informix Client | ||
+ | * Supports Informix Databases version 12+ | ||
------------------------------------------------------- | ------------------------------------------------------- | ||
Line 182: | Line 196: | ||
**pdo_odbc** | **pdo_odbc** | ||
</ | </ | ||
+ | * This is a simple driver for connection to any ODBC compliant database. | ||
+ | * It is useful for reading and simple writes to data sources such as Microsoft Access, Excel and Google Sheets | ||
+ | * There is no support for Data Dictionary functions or database specific items such as sequences. | ||
- | This is a simple driver for connection to any ODBC compliant database. There is no support for Data Dictionary functions or database specific items such as sequences. | ||
------------------------------------------------------- | ------------------------------------------------------- | ||
=== Sample Connection String === | === Sample Connection String === | ||
Line 190: | Line 206: | ||
$db = ADOnewConnection(' | $db = ADOnewConnection(' | ||
- | $dsn = 'hostname=127.0.0.1; | + | /* |
- | $user = ' | + | * Points directly at the DSN configuration in Windows Control Panel |
- | $password = ' | + | */ |
+ | $dsn = 'MYDSN' | ||
- | $db-> | + | $db-> |
</ | </ | ||
---------------------------------------------- | ---------------------------------------------- |
v5/database/pdo_new.1647802044.txt.gz · Last modified: 2022/03/20 19:47 by mnewnham