leven-framework / dba-common
There is no license information available for the latest version (1.1.0) of this package.
1.1.0
2022-07-12 10:29 UTC
Suggests
- leven-framework/dba-mock: Mock a database using an array
- leven-framework/dba-mysql: PDO MySQL adapter
This package is auto-updated.
Last update: 2024-10-14 12:52:26 UTC
README
Features
- ๐งช abstract access to the database
- ๐ simple query builder with nested conditions support
- ๐ automatic escaping of table and column names and values
Usage examples
Select
$result = $db->select('foo_table') ->columns('id', 'name') // optional, defaults to all columns ->where('id', '>', 1)->orWhere('age', '>', 22) ->orWhere(fn(\Leven\DBA\Common\BuilderPart\WhereGroup $w) => $w ->where('name', 'IN', ['Foo', 'Bar']) ->andWhere('description', 'LIKE', '%foo%') ) ->orderDesc('id')->orderAsc('name') ->limit(1)->offset(1) ->execute(); foreach($result as $row) {} // you can iterate over the rows $result->rows; // or access the rows as an array $result->count; // count of rows returned
Insert
$result = $db->insert('foo_table', ['name' => 'Foo']); $result->lastId; // last inserted id (auto increment) or null
Update
$db->update('foo_table') ->set('name', 'Foo') ->where('id', '!=', 3) ->limit(10) ->execute();
Delete
$db->delete('foo_table') ->where('id', 5) ->limit(11) ->execute();
Implementations
๐ฆ MySQL
composer require leven-framework/dba-mysql
require 'vendor/autoload.php'; // all arguments are optional except for database $db = new \Leven\DBA\MySQL\MySQLAdapter( database: 'example', user: 'username', password: 'password', host: 'localhost', port: 3306, charset: 'utf8', tablePrefix: 'prefix_' ); // or use an existing PDO instance $db = new \Leven\DBA\MySQL\MySQLAdapter($pdo);
๐ฆ Mock
composer require leven-framework/dba-mock
require 'vendor/autoload.php'; // saving and loading the database in JSON is slow but useful for development $db = new \Leven\DBA\Mock\MockAdapter( fn() => json_decode(file_get_contents('db.json'), true), fn(\Leven\DBA\Mock\Structure\Database $db) => file_put_contents('db.json', json_encode($db->toArray(), JSON_PRETTY_PRINT)) ); // first argument can also be an array representing the database $dbArray = [ 'foo_table' => [ ['id' => 'int', 'name' => 'varchar'], [1, 'Foo'], [2, 'Bar'], ], ];