library dbconnect

kolserdav/dbconnect

Module for simple connect to DataBase

This is a simple module that returns an object of the PDO class. MySql., _(*1)

Dependecies
require php : ^7.0, symfony/yaml : ^4.0
reguire-dev: phpunit/phpunit : ^7.0
"phpunit/dbunit": "^4.0", _(*2)

Instalation
-$ composer require kolserdav/dbconnect
-$ composer update, _(*3)

{ -rename file database-example.yaml to database.yaml
-copy folder config in root of your project
-add in file database.yaml self variables }
or call: -$php vendor/kolserdav/dbconnect/install, _(*4)

Using, _(*5)

use Avir\Database\Modules\DB;, _(*6)

$db = new DB;, _(*7)

In order to get PDO:, _(*8)

$pdo = $db->getPDO();, _(*9)

To get STMT:, _(*10)

$db->getStmt($query,[$values] = array());, _(*11)

To send a request:, _(*12)

$db->stmtCall($stmt, $fetchRule, $fetchOption);, _(*13)

Or insert your queries in to /config/queries.php and use:, _(*14)

$db->callDB($queryName, [$values] = array(), $fetchOption = 0, $fetchRule = 'fetch'), _(*15)

To fine-tune the selection rules: need call to FetchRule::class methods, _(*16)

hisFetch(),hisFetchColumn()..., _(*17)

By results of work, I will improve this module..., _(*18)