2017 © Pedro Peláez
 

library query-builder

Small SQL query builder

image

kekos/query-builder

Small SQL query builder

  • Sunday, December 31, 2017
  • by Kekos
  • Repository
  • 1 Watchers
  • 0 Stars
  • 258 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 0 Forks
  • 0 Open issues
  • 8 Versions
  • 1 % Grown

The README.md

Query Builder for PHP

A fork of Muhammad Usman's Pixie, a lightweight query builder for PHP. This library only supports a subset of Pixie's fetures:, (*1)

  • Nested criterias (WHERE, HAVING and ON for joins)
  • Raw queries

Query Builder is not able to open database connections or execute the built queries., (*2)

Install

You can install Query Builder via Composer:, (*3)

composer require kekos/query-builder

API

Start by configure Query Builder with an adapter:, (*4)

QueryBuilder::setAdapter(new MySqlAdapter());

The adapter sets the correct sanitizer character. At this moment MySqlAdapter is provided with the library., (*5)

All builders have a toSql() method, which returns the SQL query and all parameters to be bound to the query, to be used with prepared statements., (*6)

Select

$result = QueryBuilder::select(['user', 'u'])
  ->columns(['u.id', 'uname' => 'username'])
  ->joinOn(['user_permission', 'p'], 'p.user_id', 'u.id')
  ->limit(5, 0)
  ->groupby(['u.id'])
  ->orderby(['username ASC', 'firstname ASC'])
  ->where('firstname', '=', 'Christoffer')
  ->whereNot('u.id', 'IN', array(2))
  ->toSql();

$result will be an object of type QueryBuilder\QueryBuilders\Raw., (*7)

Nested where or having

$result = QueryBuilder::select('user')
  ->orderby('id')
  ->where(function($qb) {
    $qb->where('name', 'LIKE', '%chris%')
      ->whereOr('username', 'LIKE', '%chris%');
  })
  ->where('active', '=', 1)
  ->toSql();

Insert

$result = QueryBuilder::insert('user')
  ->values([
      'username' => 'Kekos',
      'firstname' => 'Christoffer'
    ])
  ->toSql();

Update

$result = QueryBuilder::update('user')
  ->set([
      'username' => 'new_username',
      'firstname' => 'New firstname'
    ])
  ->where('id', '=', 2)
  ->toSql();

Delete

$result = QueryBuilder::delete('user')
  ->where('id', '=', 2)
  ->toSql();

Bugs and improvements

Report bugs in GitHub issues or feel free to make a pull request :-), (*8)

License

MIT, (*9)

The Versions

31/12 2017

dev-master

9999999-dev https://github.com/Kekos/query-builder

Small SQL query builder

  Sources   Download

MIT

The Requires

  • php >= 5.3.0

 

database sql query pdo builder

31/12 2017

v1.2.1

1.2.1.0 https://github.com/Kekos/query-builder

Small SQL query builder

  Sources   Download

MIT

The Requires

  • php >= 5.3.0

 

database sql query pdo builder

30/12 2015

dev-dev

dev-dev https://github.com/Kekos/query-builder

Small SQL query builder

  Sources   Download

MIT

The Requires

  • php >= 5.3.0

 

database sql query pdo builder

30/12 2015

v1.2.0

1.2.0.0 https://github.com/Kekos/query-builder

Small SQL query builder

  Sources   Download

MIT

The Requires

  • php >= 5.3.0

 

database sql query pdo builder

29/12 2015

v1.1.0

1.1.0.0 https://github.com/Kekos/query-builder

Small SQL query builder

  Sources   Download

MIT

The Requires

  • php >= 5.3.0

 

database sql query pdo builder

13/12 2015

v1.0.2

1.0.2.0 https://github.com/Kekos/query-builder

Small SQL query builder

  Sources   Download

MIT

The Requires

  • php >= 5.3.0

 

database sql query pdo builder

13/12 2015

v1.0.1

1.0.1.0 https://github.com/Kekos/query-builder

Small SQL query builder

  Sources   Download

MIT

The Requires

  • php >= 5.3.0

 

database sql query pdo builder

07/12 2015

v1.0.0

1.0.0.0

  Sources   Download

The Requires

  • php >= 5.3.0