PDO supplements
PHP
Switch branches/tags
Nothing to show
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
.travis.yml
PDO2.php
PDO2Test.php
README.markdown
composer.json

README.markdown

PDO2

Lightweight (5.6KB) PDO wrapper to accelerate database development.

Usage

$db = new PDO2($yourPdoInstance)

All PDO methods are still available directly, but the instance is augmented with six extra methods.

  1. execute(string $statement, array $input_parameters = []) : PDOStatement

    $stm = $db->execute("SELECT * FROM wat WHERE id = ?", [12]);
    // shortcut of
    $stm = $this->prepare("SELECT * FROM wat WHERE id = ?");
    $stm->execute([12]);
  2. select($table, $params = [], $extra = '', $values = []) : PDOStatement

    $db->select('actors');
    $db->select('actors', ['first_name' => 'Al']);
    $db->select('actors', ['age > ?' => 52]);
    $db->select('id,age,name from actors', ['age > ?' => 52]);
    // Associative array creates AND, list array creates OR.
    $db->select('actors', ['a' => 1, [['b' => 2], ['c' => 3]]])
    // SELECT * FROM actors WHERE a = ? AND ((b = ?) OR (c = ?))
  3. insert($table, array $params) : PDOStatement

    $db->insert('actors', ['first_name' => 'Humphrey', 'last_name' => 'Bogart', 'age' => 57]);
  4. update($table, array $params, array $where) : PDOStatement

    $db->update('actors', ['first_name' => 'Tommy'], ['id' => 3])
  5. delete($table, array $params) : PDOStatement

    $db->delete('actors', ['id' => 3]);
    $db->delete('actors', []); // empty where part cannot be omitted.
  6. count($table, array $params = null) : int

    $db->count('actors', ['first_name' => 'Tom'])