umonkey / php-dbal
Simple database abstraction layer
1.0.3
2020-06-19 06:27 UTC
Requires
- php: >=7.2
This package is auto-updated.
Last update: 2024-10-19 16:08:30 UTC
README
Database abstraction for personal projects.
Wraps around PDO. No ORM or anything, just some handy methods.
Usage:
$db = new \Umonkey\Database([
'name' => 'mysql:dbname=foobar',
'user' => 'alice',
'password' => 'secret',
]);
$rows = $db->fetch('SELECT * FROM rows');
$db->insert('rows', [
'name' => 'foobar',
]);
$db->update('rows', [
'name' => 'foobar',
], [
'id' => 1,
]);
$users = $db->fetchkv('SELECT id, name FROM users');