qpdb/query-builder

php class for build MySql queries that prevents mysql injections

QueryBuilder v2

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., _(*1)

, _(*2)

Old versions documentation, _(*3)

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., _(*4)

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
        )
    ...
)