alksily / database
Database is PDO wrapper
1.1
2019-10-10 13:05 UTC
Requires
- php: >=7.0
- ext-pdo: *
README
It allows you connect the database to a project using a wrapper around the PDO.
Requirements
- PHP >= 7.0
Installation
Run the following command in the root directory of your web project:
composer require alksily/database
Usage
Alksily\Database\Db::initialize([ [ 'dsn' => 'mysql:host=HOST;dbname=DB_NAME', 'username' => 'DB_USER', 'password' => 'DB_PASS', // additional can be passed options, server-role and pool name: // 'option' => [ // PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'UTF8'", // PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, // ], // 'role' => 'master', // or slave // 'pool_name' => 'default', // pool list of connections ], // possible another connection config // for the implementation of master-slave ]);
Query execution
$stm = Alksily\Database\Db::query('SELECT * FROM `user` WHERE `age` > 23'); while ($a = $stm->fetch(PDO::FETCH_ASSOC)) { // some action var_dump($a); }
Aliases
Select rows
$list = $db->select('SELECT * FROM `products` WHERE `price` >= 150');
Select first element of array from select
method
$first = $db->selectOne('SELECT * FROM `products` WHERE `price` >= 150');
Affect row and return count of affected
$affected = $db->affect('INSERT INTO `products` SET `name` = "Socks with owls", `price` = 200');
Contributing
Please see CONTRIBUTING for details.
License
The Alksily Database is licensed under the MIT license. See License File for more information.