ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:database:pdo

This is an old revision of the document!


PDO

Description

This driver supports connections using the standardized PHP Data Objects connection. The pdo driver itself cannot be used, it must be used with one of the supported drivers:

PHP DriverDescriptionADOdb Connector
pdo_firebirdFirebirdfirebird
pdo_mssqlSQL Server with FREETDSmssql
pdo_mysqlMySQLmysql
pdo_ociOracleoci
pdo_pgsqlPostgresqlpgsql
pdo_sqliteSQLitesqlite
pdo_sqlsrvSQL Server using Windows Native Clientsqlsrv

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:

include_once 'adodb/adodb.inc.php';
$db = ADOnewConnection('pdo');
 
$user     = 'pdo-user';
$password = 'pdo-pass';
$dsnString= 'host=localhost;dbname=employees;charset=utf8mb4'
$db->connect('mysql:' . $dsnString,$user,$password);

Note that in the above example, the database type is separated from the rest of the DSN string by a : (colon). The rest of the DSN arguments are separated by a ; (semi-colon).

Preferred Drivers

In all cases, using native drivers (listed below) provide better functionality, as well as performance, than the equivalent PDO driver.

The PDO setAttribute function

As of ADOdb 5.21, the PDO::setAttribute() method can be emulated using setConnectionParameter().

Individual Driver Status


pdo_mssql

Preferred Driver

Microsoft native mode driver For Linux
FreeTDS Driver For Unix

Specification
Driver Namepdo
Data Providerpdo
StatusInactive1)
WindowsNo
UnixYes
ADOdb V5Yes
ADOdb V6Yes

The current status of this driver is unknown. Consider using the mssqlnative driver instead.


pdo_mysql

Preferred Driver

mysqli

Specification
Driver Namepdo
Data Providerpdo
StatusActive2)
WindowsYes
UnixNo
ADOdb V5Yes
ADOdb V6Yes
  • Some Meta functions are unavailable

Sample Connection String

include 'adodb-dir/adodb.inc.php';
$db   = ADOnewConnection('pdo');
 
$dsn  = 'mysql:hostname=127.0.0.1;database=employees;'
$user = 'user';
$password = 'password'
 
$db->connect($dsn,$user,$password);

pdo_oci

Preferred Driver

oci8

Specification
Driver Namepdo
Data Providerpdo
StatusInactive3)
WindowsYes
UnixNo
ADOdb V5Yes
ADOdb V6Yes

The current status of this driver is unknown


pdo_pgsql

Preferred Driver

postgres9

Specification
Driver Namepdo
Data Providerpdo
StatusActive4)
WindowsYes
UnixYes
ADOdb V5Yes
ADOdb V6Yes

Status

Some features are not supported


Sample Connection String

$db = newAdoConnection('pdo');
 
$dsn  = 'pgsql:host=192.168.0.212;dbname=dvdrental';
$user = 'someuser';
$pass = 'somepass';
 
$db->connect($dsn,$user,$pass);

pdo_sqlite

Preferred Driver

SQLite Database

Specification
Driver Namepdo
Data Providerpdo
StatusActive5)
WindowsYes
UnixNo
ADOdb V5Yes
ADOdb V6Yes

Sample Connection String

include 'adodb-dir/adodb.inc.php';
$db = ADOnewConnection('pdo');
 
$dsn  = 'sqlite:/home/sqlite/adodb-sqlite.db';
$user = 'root';
 
$db->connect($dsn,$user);

pdo_sqlsrv

Preferred Driver

Native Mode Driver

Specification
Driver Namepdo
Data Providerpdo
StatusActive6)
WindowsYes
UnixYes
ADOdb V5Yes
ADOdb V6Yes
  • This driver requires the installation of the Microsoft native client library, as well as the Microsoft SQL Server PDO drivers for PHP
  • Dates are always returned as strings
  • Most Meta functions are unsupported
  • setConnectionParameter() is not supported, so changing the character set at run-time is not available.
  • This driver can also be used on Linux platforms, beginning with PHP Version 7. The program relies on the Microsoft drivers for Linux. For more information, see the mssqlnative driver

Sample Connection String

include 'adodb-dir/adodb.inc.php';
$db = ADOnewConnection('pdo');
 
$user = 'user';
$pass = 'password';
$dsn  ='sqlsrv:server=SERVER\SQLEXPRESS;database=NORTHWND;';
 
$db->connect($dsn,$user,$password);

pdo_firebird

This driver is available from version 5.21

Native Driver

Firebird/Interbase Driver

Specification
Driver Namepdo
Data Providerpdo
StatusActive7)
WindowsYes
UnixYes
ADOdb V5Yes
ADOdb V6Yes

Unlike other pdo drivers, pdo_firebird is the preferred driver for this database. This is due to specific issues with this driver reported here.


Sample Connection String

include 'adodb-dir/adodb.inc.php';
$db = ADOnewConnection('pdo');
 
$dsn  = 'firebird:dbname=employee.fdb;hostname=localhost';
$user = 'SYSDBA';
$pass = 'master-key';
 
$db->connect($dsn,$user,$pass);
1) , 3)
This driver is not supported by ADOdb project members, but you can contribute to this driver if you have the expertise
2) , 4) , 5) , 6) , 7)
This driver is supported by ADOdb project members
v5/database/pdo.1546744965.txt.gz · Last modified: 2019/01/06 04:22 by mnewnham