kolserdav/dbconnect

Module for simple connect to DataBase

v2.0.10 2018-05-15 12:35 UTC

Requires

• php: ^7.0
• symfony/yaml: ^4.0

Requires (Dev)

• phpunit/dbunit: ^4.0
• phpunit/phpunit: ^7.0

MIT

• kolserdav

README

This is a simple module that returns an object of the PDO class. MySql.

Dependecies
require php : ^7.0, symfony/yaml : ^4.0
reguire-dev: phpunit/phpunit : ^7.0
"phpunit/dbunit": "^4.0"

Instalation
-$ composer require kolserdav/dbconnect
-$ composer update

{ -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

Using

use Avir\Database\Modules\DB;

$db = new DB;

In order to get PDO:

$pdo = $db->getPDO();

To get STMT:

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

To send a request:

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

Or insert your queries in to /config/queries.php and use:

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

To fine-tune the selection rules: need call to FetchRule::class methods

hisFetch(),hisFetchColumn()...

By results of work, I will improve this module...