v5:database:pdo
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
v5:database:pdo [2020/12/06 20:02] – [The PDO setAttribute function] mnewnham | v5:database:pdo [2022/02/20 23:47] (current) – [Setting Construction Parameters] mnewnham | ||
---|---|---|---|
Line 3: | Line 3: | ||
===== Description ===== | ===== Description ===== | ||
- | This driver supports connections using the standardized [[http:// | + | |
+ | This driver supports connections using the standardized [[http:// | ||
+ | |||
+ | Supported | ||
^PHP Driver^Description^ADOdb Connector^ | ^PHP Driver^Description^ADOdb Connector^ | ||
Line 14: | Line 17: | ||
|pdo_sqlsrv|SQL Server using Windows Native Client|sqlsrv| | |pdo_sqlsrv|SQL Server using Windows Native Client|sqlsrv| | ||
+ | <WRAP important> | ||
+ | Note that the //pdo// driver cannot be used on its own. It is a technical component that is used internally by the above drivers. | ||
+ | </ | ||
+ | |||
+ | |||
===== Establishing A Connection ===== | ===== Establishing A Connection ===== | ||
To establish a connection, the **//DSN//** style of connection must be used, the first argument of the DSN string being the database type, e.g. to connect to a MySQL database: | To establish a connection, the **//DSN//** style of connection must be used, the first argument of the DSN string being the database type, e.g. to connect to a MySQL database: | ||
Line 39: | Line 47: | ||
===== Setting Construction Parameters ===== | ===== Setting Construction Parameters ===== | ||
- | Certain attributes need to be passed to the [[https:// | + | Certain attributes need to be passed to the [[https:// |
<code php> | <code php> | ||
$db = newAdoConnection(' | $db = newAdoConnection(' | ||
- | $db->pdoOptions | + | $db->pdoParameters |
\PDO:: | \PDO:: | ||
]; | ]; | ||
Line 54: | Line 62: | ||
===== The PDO setAttribute function ===== | ===== The PDO setAttribute function ===== | ||
- | For parameters that are set are the class is instantiated, | + | For parameters that are set after the class is instantiated, |
===== Individual Driver Status ==== | ===== Individual Driver Status ==== | ||
Line 239: | Line 247: | ||
==== pdo_firebird ==== | ==== pdo_firebird ==== | ||
- | <WRAP info> | ||
- | This driver is available from version 5.21 | ||
- | </ | ||
<WRAP right box round 300px> | <WRAP right box round 300px> | ||
== Native Driver == | == Native Driver == |
v5/database/pdo.1607281334.txt.gz · Last modified: 2020/12/06 20:02 by mnewnham