library clearpdo

clearpdo/clearpdo

ClearPDO makes connecting with databases and running queries extremely simple.

ClearPDO

ClearPDO makes connecting with databases and running queries extremely simple., _(*1)

Usage Instructions

ClearPDO extends PDO so all the things you can do with vanilla PDO your can do with ClearPDO. For example:, _(*2)

$db = new ClearPDO\PDO("mysql:host=$host;dbname=$database;charset=UTF8", $username, $password);

$db->prepare("SELECT * FROM provinces WHERE population > ?");
$db->execute(array(500000));

$provinces = $db->fetchAll();

But you can also use the many convenience methods that ClearPDO provides., _(*3)

Creating a MySQL Connect, _(*4)

Instead of wasting time manually creating a DSN string you can use the following helper method to create a connection using a configuration array., _(*5)

$db = ClearPDO\PDO::createMysqlConnection([
    'host'      => 'localhost',
    'port'      => '3396',
    'database'  => 'blog',
    'username'  => 'root',
    'password'  => '3GwZFRjbGezY',
    'charset'   => 'utf8',
    'collation' => 'utf8_unicode_ci',
]);

Or alternative using a socket connection., _(*6)

$db = ClearPDO\PDO::createMysqlConnection([
    'unix_socket' => '/var/run/mysqld/mysqld.sock',
    'database'    => 'blog',
    'username'    => 'root',
    'password'    => '3GwZFRjbGezY',
    'charset'     => 'utf8',
    'collation'   => 'utf8_unicode_ci',
]);

Using the Select Method, _(*7)

$statement = $db->select('SELECT content FROM posts WHERE status = :status', [':status' => 'published']);
while ($post = $statement->fetch()) {
    print $post->content;
}

Using the Results Method, _(*8)

$posts = $db->results('SELECT content FROM posts WHERE status = :status', [':status' => 'published']);
foreach ($posts as $post) {
    print $post->content;
}

Using the Lists Method, _(*9)

$posts = $db->lists('SELECT id, content FROM posts WHERE status = :status', [':status' => 'published']);
foreach ($posts as $id => $content) {
    print $content;
}

Using the Result Method, _(*10)

$post = $db->result('SELECT content FROM posts WHERE id = :id', [':id' => 4]);
print $post->content;

Using the Column Method, _(*11)

$content = $db->column('SELECT content FROM posts WHERE id = :id', [':id' => 4]);
print $content;

Using the Insert Method, _(*12)

$db->insert('posts', [
    'status'  => 'draft'
    'content' => 'Vestibulum dictum, nunc vel pulvinar.',
    'created' => new DateTime,
]);

Using the Update Method, _(*13)

$data = [
    'status'  => 'published',
    'updated' => new DateTime,
];

$db->insert('posts', $data, 'id = :postID', [':postID' => 4]);