4d47/pdo2

There is no license information available for the latest version (1.0.0) of this package.

PDO supplements

1.0.0 2013-11-27 02:02 UTC

README

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'])