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.
- Php 5.6+
- Enable PDO (php.ini)
- MySql 5.5 / 5.6 / 5.7 / MariaDB
- Partial tested for MySql 8
composer require qpdb/query-builder
It is enough to configure the pdoWrapper dependence.
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
)
...
)