Database Component

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.