Recommend this page to a friend! |
Download .zip |
Info | Documentation | View files (11) | Download .zip | 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...
Files |
File | Role | Description | ||
---|---|---|---|---|
config (2 files) | ||||
src (1 directory) | ||||
tests (1 directory) | ||||
composer.json | Data | Auxiliary data | ||
composer.lock | Data | Auxiliary data | ||
install | Aux. | Installation script | ||
README.md | Doc. | Documentation |
Files | / | config |
File | Role | Description |
---|---|---|
database-example.yaml | Data | Auxiliary data |
queries.php | Aux. | Auxiliary script |
Files | / | src | / | Modules |
File | Role | Description |
---|---|---|
DB.php | Class | Class source |
DbConnect.php | Class | Class source |
FetchRules.php | Class | Class source |
QueryPrepare.php | 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.