roolith / database
PHP database driver
1.0.3
2021-09-29 10:09 UTC
Requires
- ext-pdo: *
Requires (Dev)
- fzaninotto/faker: ^1.9
- phpunit/phpunit: ^9.2
This package is auto-updated.
Last update: 2024-10-29 06:18:38 UTC
README
PHP database driver
Install
composer require roolith/database
Usage
use Roolith\Store\Database; $db = new Database(); $db->connect([ 'host' => 'host', 'name' => 'dbname', 'user' => 'username', 'pass' => 'password', ]); // Get all users $users = $db->query("SELECT * FROM users")->get(); print_r($users); // Get all usernames $usernames = $db->table('users')->select([ 'field' => 'name', ])->get(); print_r($usernames); // Disconnect $db->disconnect();
Select
$db->query("SELECT * FROM users")->get();
$db->table('users')->select([ 'field' => ['name', 'email'], 'condition' => 'WHERE id > 0', 'limit' => '0, 10', 'orderBy' => 'name', 'groupBy' => 'name', ])->get();
Insert
$result = $db->table('users')->insert( ['name' => 'Brannon Bruen', 'email' => 'bschmeler@pacocha.net'] ); print_r($result->success());
Insert data when supplied email john@email.com
not exists in table users
:
$result = $db->table('users')->insert( ['name' => 'John doe', 'email' => 'john@email.com'], ['email'] );
Response:
$result->affectedRow(); $result->insertedId(); $result->isDuplicate(); $result->success();
Update
$result = $db->table('users')->update( ['name' => 'Habib Hadi', 'email' => 'john@email.com'], ['id' => 1] );
or
$result = $db->table('users')->update( ['name' => 'Habib Hadi', 'email' => 'john@email.com'], 'id = 1' );
update username if nobody else is using same username
$result = $db->table('users')->update( ['username' => 'johndoe'], ['id' => 4], ['username'] );
Response:
$result->affectedRow(); $result->isDuplicate(); $result->success();
Delete
$result = $db->table('users')->delete(['id' => 4]);
Response:
$result->affectedRow(); $result->success();
Connect
$db = new Database(); $db->connect([ 'host' => 'host', 'name' => 'dbname', 'user' => 'username', 'pass' => 'password', ]);
or
$db = new Database([ 'host' => 'host', 'name' => 'dbname', 'user' => 'username', 'pass' => 'password', ]);
Disconnect
$db->disconnect();
Others
Search users table with LIKE
operator
$db->table('users')->where('name', '%Hadi%', 'LIKE')->get();
Get user by id 1
$db->table('users')->find(1);
Pluck name and email from users table
$db->table('users')->pluck(['name', 'email']);
Get total record of users table
$db->query("SELECT id FROM users")->count();
Pagination
$total = $db->query("SELECT id FROM users")->count(); $result = $db->query("SELECT * FROM users")->paginate([ 'perPage' => 5, 'pageUrl' => 'http://domain.com', 'primaryColumn' => 'id', 'pageParam' => 'page', 'total' => $total, ]);
or
$total = $db->query("SELECT id FROM users")->count(); $result = $db->query("SELECT * FROM users")->paginate([ 'perPage' => 5, // default 20 'total' => $total, ]);
print_r($result->getDetails());
{
"total": 50,
"perPage": 15,
"currentPage": 1,
"lastPage": 4,
"firstPageUrl": "http://domain.com?page=1",
"lastPageUrl": "http://domain.com?page=4",
"nextPageUrl": "http://domain.com?page=2",
"prevPageUrl": null,
"path": "http://domain.com",
"from": 1,
"to": 15,
"data":[
// records
]
}
Debug mode
$db->debugMode()->table('users')->find(1);
Note: Once debug-mode is active then it will show query string!
Development
PHPUnit 9.3.7 by Sebastian Bergmann and contributors.
Database
✔ Should construct with config
✔ Should construct without config
✔ Should connect
✔ Should disconnect
✔ Should allow raw query
✔ Should return first result
✔ Should select
✔ Should insert
✔ Should insert if record not exists
✔ Should update
✔ Should update if record not exists
✔ Should delete
✔ Should get result based on where
✔ Should get result by find
✔ Should pluck by field name
✔ Should paginate
Paginate
✔ Should get count
✔ Should get total
✔ Should get total page
✔ Should get current page
✔ Should get first item
✔ Should get last item
✔ Should get items
✔ Should get first page url
✔ Should get last page url
✔ Should get next page url
✔ Should get prev page url
✔ Should get page numbers
✔ Should get limit
✔ Should get offset
✔ Should get details
Time: 00:00.144, Memory: 6.00 MB
OK (31 tests, 41 assertions)