Recommend this page to a friend! |
![]() ![]() |
Info | ![]() |
![]() |
![]() ![]() |
Reputation | Support forum | Blog | Links |
Last Updated | Ratings | Unique User Downloads | Download Rankings | |||||
2022-05-31 (1 month ago) ![]() | Not yet rated by the users | Total: 64 This week: 3 | All time: 10,075 This week: 47![]() |
Version | License | PHP version | Categories | |||
db-query-builder 1.0.0 | MIT/X Consortium ... | 5 | PHP 5, Databases, Configuration |
Description | Author | |||
This package can execute database queries from configuration files. Innovation Award
|
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...
![]() |
File | Role | Description | ||
---|---|---|---|---|
![]() |
||||
![]() |
||||
![]() |
||||
![]() |
Data | Auxiliary data | ||
![]() |
Data | Auxiliary data | ||
![]() |
Aux. | Installation script | ||
![]() |
Doc. | Documentation |
![]() |
/ | config |
File | Role | Description |
---|---|---|
![]() |
Data | Auxiliary data |
![]() |
Aux. | Auxiliary script |
![]() |
/ | src | / | Modules |
File | Role | Description |
---|---|---|
![]() |
Class | Class source |
![]() |
Class | Class source |
![]() |
Class | Class source |
![]() |
Class | Class source |
Version Control | Unique User Downloads | Download Rankings | |||||||||||||||
100% |
|
|
Applications that use this package |
If you know an application of this package, send a message to the author to add a link here.