keiii/pdo-wrapper

This package is abandoned and no longer maintained. No replacement package was suggested.

Wrapper of PHP PDO class.

0.3 2016-09-15 17:53 UTC

Requires

• php: >=5.5|^7.0

Requires (Dev)

• friendsofphp/php-cs-fixer: ^1.0
• phpunit/dbunit: ^1.0|^2.0
• phpunit/phpunit: ^4.0|^5.0

MIT

• KEIII

• database
• pdo

README

Provides wrapper of PHP PDO class to solve verbosity problem.

Installation

composer require keiii/pdo-wrapper

Example

<?php

use KEIII\PdoWrapper\PdoWrapper;
use KEIII\PdoWrapper\PdoQuery;

$db = new PdoWrapper('sqlite::memory:');

// write
$sql = 'INSERT INTO people (name) VALUES (:name);';
$parameters = [':name' => 'John'];
$db->write(new PdoQuery($sql, $parameters));

// read one
$sql = 'SELECT * FROM people WHERE name = :name;';
$parameters = [':name' => 'John'];
$john = $db->read(new PdoQuery($sql, $parameters))->getFirst();

// as generator
$sql = 'SELECT * FROM people;';
$people = $db->read(new PdoQuery($sql))->asGenerator();
foreach ($people as $human) {
    // ...
}