liquidbox/pdo-extension

PHP PDO Extension

This is a PHP PDO extension class with a basic set of insert, select, update and delete (CRUD) query helpers. Aimed at being intuitive, robust and multifunctional., _(*1)

Usage

Database connection remains the same., _(*2)

Connection

Create a common ODBC database connection., _(*3)

$db = new PDO('odbc:dbname=hollywood;host=127.0.0.1', 'root');

Create a secure MySQL database connection., _(*4)

$db = new PDO(
    'mysql:dbname=hollywood;host=127.0.0.1',
    $config['db.username'],
    $config['db.password'],
    [
        PDO::MYSQL_ATTR_SSL_KEY  => '/path/to/client-key.pem',
        PDO::MYSQL_ATTR_SSL_CERT => '/path/to/client-cert.pem',
        PDO::MYSQL_ATTR_SSL_CA   => '/path/to/ca-cert.pem'
    ]
);

query() Method Override

This extension overrides the query method to use the power of printf formatting. Use an array in place of a string for the first argument. The order of values are the same as printf starting with the format followed by as many arguments as needed., _(*5)

$res = $db->query(['UPDATE actor SET oscars = oscars + 1 WHERE id = %d', 4600]);

Passing a string remains functional as before., _(*6)

Query Helpers

The query helpers are designed to be intuitive by mirroring their SQL counterparts in syntax., _(*7)

Creating Records

Create a single record by passing the table name and an associative array of the column-value pair(s) to set., _(*8)

$db->insert(
    'actor',
    [
        'name' => "Anna Kendrick",
        'gender' => "female",
        'born' => (new DateTime("August 9, 1985"))->format('Y-m-d')
    ]
);

Create multiple records by passing an array of associative arrays., _(*9)

Reading Records

Note: Short-circuited the ORDER BY clause., _(*10)

if ($page > 1) {
    $offset = ($page - 1) * $limit
}

$res = $db->select(
    ['name', 'picture'],
    'actor',
    'name LIKE "%' . $middleName . '%" AND gender = "male"',
    isset($offset) ? [$offset, $limit] : $limit
);

$actors = $res->fetchAll();

Updating Records

$db->update(
    'actor',
    ['oscars' => 'oscars + 1'],
    'name = "Michael Thomas Green"'
);

$db->update(
    'actor',
    [
        ['latest_role' => "Moe",   'name' => "Moses Harry Horwitz"],
        ['latest_role' => "Larry", 'name' => "Louis Feinberg"],
        ['latest_role' => "Curly", 'name' => "Jerome Lester Horwitz"]
    ]
);

Deleting Records

$db->delete('actor', 'name = "Joey Tribbiani"');

License

See the LICENSE file for license rights and limitations (MIT)., _(*11)