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) {
    // ...
}