DBAL

DataBase Abstraction Layer., _(*1)

Installation

The package can be installed via Composer by requiring the "artoodetoo/dbal" package in your project's composer.json., _(*2)

{
    "require": {
        "artoodetoo/dbal": "dev-master"
    }
}

Usage

require 'vendor/autoload.php';

use R2\DBAL\PDOMySQL;

$db = new PDOMySQL([
    'username' => 'john',
    'password' => 'tiger',
    'dbname'   => 'testdb'
]);
$list = $db
    ->query("SELECT id FROM test")
    ->fetchAssocAll();

Feature list

Every DBALInterface descendant do: * named placeholders without ":" sign, so you can do, _(*3)

    $db->query($sql, compact('name', 'city', 'ids'))

array substitution for IN(:ids)
auto NULL substitution for nulls or empty arrays
method chaining like

    $db
        ->beginTransaction
            ->query($insertSql1)
            ->query($insertSql2)
            ->query($insertSql3)
        ->commit();

License

The DBAL is open-source software, licensed under the MIT license, _(*4)

22/02 2015

dev-master

9999999-dev

DataBase Abstraction Layer

Sources Download

MIT

The Requires

php >=5.4.0

The Development Requires

phpunit/phpunit 4.0.*

by artoodetoo

database dbal db package connection

library dbal