qpdb / query-builder

2.0.5 2019-12-02 22:38 UTC

Requires

• php: >=5.6
• qpdb/common: ^1.0
• qpdb/pdo-wrapper: ^1.0

MIT

• Adrian Dumitru

• php
• mysql
• pdo
• querybuilder

Published on Packagist.org on 2019-12-02 22:41 UTC

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.

Old versions documentation

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