qpdb / query-builder
php class for build MySql queries that prevents mysql injections
2.0.5
2019-12-02 22:38 UTC
Requires
- php: >=5.6
- qpdb/common: ^1.0
- qpdb/pdo-wrapper: ^1.0
README
QueryBuilder is a user friendly php class for build MySql queries that prevents mysql injections and it takes care of table prefixing. This same can also replication support for use master and slave.
Requirements
- Php 5.6+
- Enable PDO (php.ini)
- MySql 5.5 / 5.6 / 5.7 / MariaDB
- Partial tested for MySql 8
Installation
composer require qpdb/query-builder
Configuration
It is enough to configure the pdoWrapper dependence.
How do we use?
include_once 'path/to/vendor/autoload.php'; use Qpdb\QueryBuilder\QueryBuild; $query = QueryBuild::select( 'employees' ) ->fields('lastName, jobTitle, officeCode') ->whereEqual( 'jobTitle', "Sales Rep" ) ->whereIn( 'officeCode', [ 2, 3, 4 ] ); $query->execute() /** return array */ Array ( [0] => Array ( [lastName] => Firrelli [jobTitle] => Sales Rep [officeCode] => 2 ) [1] => Array ( [lastName] => Patterson [jobTitle] => Sales Rep [officeCode] => 2 ) ... )