php sql query builder
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
source
tests
.gitignore
.travis.yml
GPL-LICENSE.txt
MIT-LICENSE.txt
README.md
composer.json
composer.lock
phpunit.xml

README.md

Build Status Code coverage

Requirements

  • PHP 5.3 +

TODO

  • PHP 5.2 branch

Examples

$q->table('test')
->column('test_2', 'test')
->table('test_3', 'test_2');
//=> SELECT test_2 as test FROM test, test_3 AS test_2

$q->table('table')
->begin_and()
->andWhere('col_1', 1)
->orWhere('col_2', 2)
->endAnd()
->orWhere('col_3', 3, '!=');
//=>SELECT * FROM table WHERE ( col_1 = '1'  OR col_2 = '2' ) or col_3 != '3'

$q->table('table')
->beginAnd()
->beginAnd()
->andWhere('col_1', 1)
->orWhere('col_2', 2)
->endAnd()
->endAnd()
->orWhere('col_3', 3, '!=');

//=>SELECT * FROM table WHERE ( ( col_1 = '1' OR col_2 = '2' ) ) OR col_3 != '3'