PHPackages                             monochromegane/query-builder - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. monochromegane/query-builder

ActiveLibrary

monochromegane/query-builder
============================

Simple query builder

1.0.1(12y ago)5102MITPHP

Since Jun 1Pushed 12y ago1 watchersCompare

[ Source](https://github.com/monochromegane/QueryBuilder)[ Packagist](https://packagist.org/packages/monochromegane/query-builder)[ Docs](https://github.com/monochromegane/QueryBuilder)[ RSS](/packages/monochromegane-query-builder/feed)WikiDiscussions master Synced 2mo ago

READMEChangelogDependenciesVersions (3)Used By (0)

QueryBuilder
============

[](#querybuilder)

`QueryBuilder` is very simple query builder. It helps building query and binding values.

Install
=======

[](#install)

```
composer.phar require monochromegane/query-builder:dev-master
```

Usage
=====

[](#usage)

Get query and binding values
----------------------------

[](#get-query-and-binding-values)

Binding value format like a PDO format. i.e `column = ?`

```
use Monochromegane\QueryBuilder\Query;

// SELECT
list($query, $bind) = Query::select("table", array("column1", "column2"));
                    ->where(array("column1" => "value1"));
                    ->build();

// INSERT
list($query, $bind) = Query::insert("table", array("column1" => "value1"))
                    ->build();

// UPDATE
list($query, $bind) = Query::update("table", array("column1" => "value1"))
                    ->where(array("column1" => "value1"));
                    ->build();

// DELETE
list($query, $bind) = Query::delete("table")
                    ->where(array("column1" => "value1"));
                    ->build();

// Execute
$dbh  = new PDO($dsn, $user, $password);
$stmt = $dbh->prepare($query);
$stmt->execute($bind);
```

Set Conditions
--------------

[](#set-conditions)

```
$conditions = array(
    // column1 IS NULL
    "column1" => null,
    // column2 = ? (and bind "value2")
    "column2" => "value2",
    // column3  array("