tomwright/extended-pdo

An extension on the standard PDO library.

Extended PDO

, _(*1)

Installation

composer install tomwright/extended-pdo

Connecting

ExtendedPDO implements the singleton design pattern using tomwright/singleton. For more information on how the following code works, see the documentation., _(*2)

$db = ExtendedPDO::createConnection($dsn, $username, $password, 'my-main-db');
$db2 = ExtendedPDO::getInstance('my-main-db');

var_dump($db === $db2) // TRUE

Usage

// Returns an array of records
$db->queryAll('SELECT * FROM users WHERE username = :username', [':username' => 'Tom']);

// Returns the first record
$db->queryRow('SELECT * FROM users WHERE username = :username LIMIT 1', [':username' => 'Tom']);

Query Return Types

You can set the return type of the dbQuery(), queryAll() and queryRow() methods using $db->setReturnType($x) where $x is the return type you'd like to use., _(*3)

Available return types are as follows:, _(*4)

• ExtendedPDO::RETURN_TYPE_OBJECT - Your results will be returned as objects
• ExtendedPDO::RETURN_TYPE_ASSOC - Your results will be returned as associative arrays
• ExtendedPDO::RETURN_TYPE_STMT - The statement object will be returned directly

You can also set a return type of \PDO::FETCH_ASSOC for example and it will override any of the above. This makes all of the standard PDO fetch types usable., _(*5)

Query Builder

ExtendedPDO also comes with it's own Query Builder., _(*6)