README

Ext-PDO is a lightweight extension to PHP's native PDO API that ships sensible defaults for the most popular database drivers and adds a few helper methods to streamline everyday database work.

Features

• Driver-aware factory – ExtPDO::create() instantiates the appropriate subclass for MySQL, PostgreSQL, SQLite or SQL Server, so you only need to provide driver-agnostic connection settings.
• Safer transaction handling – transparent tracking of the transaction depth prevents accidental commits when you are using nested transactions and only calls through to PDO when the outermost transaction succeeds.
• Convenience helpers – exec(), select() and get() accept bound parameters directly and return useful values without requiring boilerplate prepared-statement code.
• Optimized connection defaults – the bundled driver subclasses configure error modes, fetch modes, timeouts and driver-specific options like ANSI quotes for MySQL so you do not have to remember to tune them yourself.
• Environment-driven configuration (optional) – the Connection and Connections helpers can bootstrap connections from environment variables or custom factories, making it easy to centralize connection management in larger applications.

Benefits

• Reduce boilerplate when running parameterized queries and fetching results thanks to helper methods.
• Gain predictable error handling and data fetching behaviour from the sensible defaults applied to each driver.
• Safely compose higher-level data access routines that require nested transactions.
• Standardize how connections are created across environments while keeping the flexibility to override options when necessary.

Installation

Install the package via Composer:

composer require php-kit/ext-pdo

Usage

Creating a connection directly

use PhpKit\ExtPDO\ExtPDO;

$pdo = ExtPDO::create('mysql', [
 'host' => '127.0.0.1',
 'database' => 'app',
 'username' => 'app_user',
 'password' => 'secret',
 'charset' => 'utf8mb4',
]);

$pdo->beginTransaction();

try {
 // Run parameterized statements without manual statement preparation.
 $pdo->exec('INSERT INTO posts (title, body) VALUES (?, ?)', ['Hello', 'First post']);

 // Quickly fetch a single value.
 $postCount = $pdo->get('SELECT COUNT(*) FROM posts');

 // Or work with a full result set.
 $statement = $pdo->select('SELECT * FROM posts WHERE id = ?', [1]);
 $post = $statement->fetch();

 $pdo->commit();
} catch (Throwable $e) {
 $pdo->rollBack();
 throw $e;
}

You can override any PDO options at creation time by passing an $optionsOverride array as the third argument to ExtPDO::create().

Loading connections from the environment

use PhpKit\ExtPDO\Connections;

$connections = new Connections();

// Reads DB_DRIVER, DB_HOST, DB_DATABASE, DB_USERNAME, etc. from the environment.
$default = $connections->get();

// Register additional named connections when needed.
$connections->register('reporting', function () {
 // Build and return a Connection instance here.
});

Set environment variables such as DB_DRIVER, DB_HOST, DB_DATABASE, DB_USERNAME, and DB_PASSWORD (or their NAME_-prefixed variants for named connections) to let Ext-PDO configure the connection automatically.

Copyright © 2015 Impactwave, Lda.