vstaran/query-builder

There is no license information available for the latest version (dev-main) of this package.

dev-main 2021-11-26 14:19 UTC

Requires

• aigletter/interfaces: ^1.0

Unknown License

• Victor Staranchuk

README

Implement builder pattern, use PDO.

Installation

You can install the package via composer:

composer require vstaran/query-builder

Basic usage

$builder = new QueryBuilder();
$query = $builder->table('users')
    ->select(['first_name', 'age'])
    ->where(['status' => 'active'])
    ->order(['id' => 'ASC'])
    ->limit(20)
    ->offset(40)
    ->build();

Road map

• Add methods JOIN, GROUPBY, HAVING etc...
• Create INSERT, UPDATE and DETELE statement

Dependencies

• require packagist aigletter/interfaces

License

The MIT License (MIT).