Download the PHP package php-kit/ext-pdo without Composer
On this page you can find all versions of the php package php-kit/ext-pdo. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download php-kit/ext-pdo
More information about php-kit/ext-pdo
Files in php-kit/ext-pdo
Package ext-pdo
Short Description An extension to the standard PHP PDO API
License MIT
Homepage https://github.com/php-kit/ext-pdo
Informations about the package ext-pdo
Ext-PDO
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()andget()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
ConnectionandConnectionshelpers 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:
Usage
Creating a connection directly
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
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.