Class QueryBuilder

static

where(array('U.id', 1))->andWhere(array())->text() [==] " WHERE U.id = 1"
where(array('U.id', 1))->andWhere(array('U.id', 2))->text() [==] " WHERE (U.id = 1) AND (U.id = 2)"
where(array('U.id', 1))->andWhere(array(Sql::BETWEEN('id', 0, 1), Sql::BETWEEN('id', 0, 1)), 'OR')->text() [==] " WHERE (U.id = 1) AND (id BETWEEN 0 AND 1 OR id BETWEEN 0 AND 1)"

static

static

static

integer

static

delete('user', array(array('id', 1), array('name', 'test')))->text() [==] "DELETE FROM user WHERE id = 1 AND name = 'test'"

array

static

select()->from('user U')->exists('useronline', array('member_id', 'U.id'))->text() [==] 'SELECT * FROM user AS U WHERE EXISTS (SELECT * FROM useronline WHERE member_id = U.id)'
select()->from('user U')->where(array('U.id', 1))->exists('useronline', array('member_id', 'U.id'))->text() [==] 'SELECT * FROM user AS U WHERE U.id = 1 AND EXISTS (SELECT * FROM useronline WHERE member_id = U.id)'

static

object|array|boolean

static

select()->from('user')->text() [==] "SELECT * FROM user"
select()->from('user a', 'user b')->text() [==] "SELECT * FROM user AS a, user AS b"

array

static

select()->from('user')->groupBy('MONTH(date)', 'YEAR(date)')->text() [==] 'SELECT * FROM user GROUP BY MONTH(date), YEAR(date)'
select()->from('user')->groupBy('U.id')->text() [==] 'SELECT * FROM user GROUP BY U.id'
select()->from('user')->groupBy(array('id', 'username'))->text() [==] 'SELECT * FROM user GROUP BY id, username'

static

static

insert('user', array('id' => 1, 'name' => 'test'))->text() [==] "INSERT INTO user (id, name) VALUES (1, 'test')"

static

insertOrUpdate('user', array('id' => 1, 'name' => 'test'))->text() [==] "INSERT INTO user (id, name) VALUES (1, 'test') ON DUPLICATE KEY UPDATE id=VALUES(id), name=VALUES(name)"

static

join('user U', 'INNER', 1)->text() [==] " INNER JOIN user AS U ON id = 1"
join('user U', 'INNER', array('U.id', 'A.id'))->text() [==] " INNER JOIN user AS U ON U.id = A.id"
join('user U', 'INNER', array('U.id', '=', 'A.id'))->text() [==] " INNER JOIN user AS U ON U.id = A.id"
join('user U', 'INNER', array('id', '=', 1))->text() [==] " INNER JOIN user AS U ON id = 1"
join('user U', 'INNER', array(array('U.id', 'A.id'), array('U.id', 'A.id')))->text() [==] " INNER JOIN user AS U ON U.id = A.id AND U.id = A.id"

static

limit(10)->text() [==] " LIMIT 10"
limit(10, 1)->text() [==] " LIMIT 1,10"

static

static

where(array('U.id', 1))->orWhere(array())->text() [==] " WHERE U.id = 1"
where(array('U.id', 1))->orWhere(array('U.id', 2))->text() [==] " WHERE (U.id = 1) OR (U.id = 2)"
where(array('U.id', 1))->orWhere(array(Sql::BETWEEN('id', 0, 1), Sql::BETWEEN('id', 0, 1)), 'OR')->text() [==] " WHERE (U.id = 1) OR (id BETWEEN 0 AND 1 OR id BETWEEN 0 AND 1)"

static

order('id', 'id ASC')->text() [==] " ORDER BY id, id ASC"
order('id ASC')->text() [==] " ORDER BY id ASC"
order('user.id DESC')->text() [==] " ORDER BY user.id DESC"
order('id ASCD')->text() [==] ""

static

select('U.id', 'email name', 'module')->text() [==] "SELECT U.id,email AS name,module"
select('"email" name', '0 id', '0 ไอดี')->text() [==] "SELECT 'email' AS name,0 AS id,0 AS ไอดี"
select("'email' name", '0 AS id', '0 AS ไอดี')->text() [==] "SELECT 'email' AS name,0 AS id,0 AS ไอดี"
select()->text() [==] "SELECT *"
select()->where(array('domain', Sql::strValue('kotchasan.com')))->text() [==] "SELECT * WHERE domain = 'kotchasan.com'"
select('name ชื่อ นามสกุล', 'U.idcard AS เลขประชาชน')->text() [==] "SELECT name AS ชื่อ นามสกุล,U.idcard AS เลขประชาชน"
select('table.field', 'table.field')->text() [==] "SELECT table.field,table.field"
select('table.field field', 'table.field field')->text() [==] "SELECT table.field AS field,table.field AS field"
select('table.field AS field', 'table.field AS field')->text() [==] "SELECT table.field AS field,table.field AS field"
select('U.field', 'U1.field', 'NULL id')->text() [==] "SELECT U.field,U1.field,NULL AS id"
select('U.field field', 'U1.field field')->text() [==] "SELECT U.field AS field,U1.field AS field"
select('U.field AS field', 'U1.field AS field')->text() [==] "SELECT U.field AS field,U1.field AS field"
select(Sql::YEAR('create_date', 'year'), Sql::MONTH('create_date', 'month'))->text() [==] "SELECT YEAR(create_date) AS year,MONTH(create_date) AS month"
select(array(Sql::YEAR('create_date', 'year'), Sql::MONTH('create_date', 'month')))->text() [==] "SELECT YEAR(create_date) AS year,MONTH(create_date) AS month"

static

selectCount()->from('user')->text() [==] "SELECT COUNT(*) AS count FROM user"
selectCount('id ids')->from('user')->text() [==] "SELECT COUNT(id) AS ids FROM user"
selectCount('id ids', 'field alias')->from('user')->text() [==] "SELECT COUNT(id) AS ids, COUNT(field) AS alias FROM user"

static

selectDistinct('id')->from('user')->text() [==] "SELECT DISTINCT id FROM user"

static

update('user')->set(array('key1' => 'value1', 'key2' => 2))->where(1)->text() [==] "UPDATE user SET key1=:Skey1, key2=:Skey2 WHERE id = 1"
update('user U')->set(array('U.key1' => 'value1', 'U.key2' => 2))->where(array('U.id', 1))->text() [==] "UPDATE user AS U SET U.key1=:SUkey1, U.key2=:SUkey2 WHERE U.id = 1"
update('user')->set(array('key1' => '(...)'))->text() [==] "UPDATE user SET key1=(...)"
update('user')->set(array('key1' => 'test (...)'))->text() [==] "UPDATE user SET key1=:Skey1"
update('user')->set('reply=reply+1')->text() [==] "UPDATE user SET reply=reply+1"
update('user')->set(array('id' => 1, 'reply=reply+1'))->text() [==] "UPDATE user SET id=:Sid, reply=reply+1"
update('user')->set(array('create_date' => Sql::NOW()))->text() [==] "UPDATE user SET create_date=NOW()"
update('user')->set(array('create_date' => Sql::create('SELECT * FROM a')))->text() [==] "UPDATE user SET create_date=SELECT * FROM a"
update('user')->set(array('create_date' => 'U.id'))->text() [==] "UPDATE user SET create_date=U.id"
update('user')->set(array('create_date' => '111.11'))->text() [==] "UPDATE user SET create_date=:Screatedate"
update('user')->set(array('create_date' => 'user.user'))->text() [==] "UPDATE user SET create_date=:Screatedate"

static

static

(Sql::create('SELECT * FROM a'), Sql::create('SELECT * FROM b'))->text() [==] "(SELECT * FROM a) UNION (SELECT * FROM b)"
(array(Sql::create('SELECT * FROM a'), Sql::create('SELECT * FROM b')))->text() [==] "(SELECT * FROM a) UNION (SELECT * FROM b)"

static

(Sql::create('SELECT * FROM a'), Sql::create('SELECT * FROM b'))->text() [==] "(SELECT * FROM a) UNION ALL (SELECT * FROM b)"
(array(Sql::create('SELECT * FROM a'), Sql::create('SELECT * FROM b')))->text() [==] "(SELECT * FROM a) UNION ALL (SELECT * FROM b)"

static

update('user')->set(array('key1'=>'value1', 'key2'=>2))->where(array(array('id', 1), array('id', 1)))->text() [==] "UPDATE user SET key1=:Skey1, key2=:Skey2 WHERE id = 1 AND id = 1"

static

where(array())->text() [==] ""
where(1)->text() [==] " WHERE id = 1"
where(array('id', 1))->text() [==] " WHERE id = 1"
where(array('id', '1'))->text() [==] " WHERE id = '1'"
where(array('domain', 'domain.tld'))->text() [==] " WHERE domain = 'domain.tld'"
where(array(1, 1))->text() [==] " WHERE 1 = 1"
where(array('U.id', 'G.id'))->text() [==] " WHERE U.id = G.id"
where(array('date', '2016-1-1 30:30'))->text() [==] " WHERE date = '2016-1-1 30:30'"
where(array('id', '=', 1))->text() [==] " WHERE id = 1"
where(Sql::create('id=1 OR (SELECT ....)'))->text() [==] " WHERE id=1 OR (SELECT ....)"
where(array('id', '=', 1))->text() [==] " WHERE id = 1"
where(array('id', 'IN', array(1, 2, '3')))->text() [==] " WHERE id IN (1, 2, '3')"
where(array(array('social', '0'), Sql::create('(...)')))->text() [==] " WHERE social = '0' AND (...)"
where(array(array(Sql::MONTH('create_date'), 1), array(Sql::YEAR('create_date'), 1)))->text() [==] " WHERE MONTH(create_date) = 1 AND YEAR(create_date) = 1"
where(array(array('id', array(1, 'a')), array('id', array('G.id', 'G.id2'))))->text() [==] " WHERE id IN (1, 'a') AND id IN (G.id, G.id2)"
where(array(array('id', array(1, 'a')), array('id', array('', 'th'))))->text() [==] " WHERE id IN (1, 'a') AND id IN ('', 'th')"
where(array('ip', 'NOT IN', array('', '192.168.1.104')))->text() [==] " WHERE ip NOT IN ('', '192.168.1.104')"
where(array('U.id', '(SELECT CASE END)'))->text() [==] " WHERE U.id = '(SELECT CASE END)'"
where(array(array(Sql::YEAR('create_date'), Sql::YEAR('S.create_date'))))->text() [==] " WHERE YEAR(create_date) = YEAR(S.create_date)"
where(array('U.id', Sql::strValue('G.id')))->text() [==] " WHERE U.id = 'G.id'"
where(Sql::ISNULL('U.id'))->text() [==] " WHERE U.id IS NULL"
where(array(array('create_date', 'A'), Sql::BETWEEN('id', 'ทดสอบ', 'ทดสอบ')))->text() [==] " WHERE create_date = 'A' AND id BETWEEN 'ทดสอบ' AND 'ทดสอบ'"
where(array(array(Sql::BETWEEN('id', 0, 1), 'OR', Sql::BETWEEN('id', 0, 1)), array(Sql::BETWEEN('id', 0, 1), 'OR', Sql::BETWEEN('id', 0, 1))), 'OR')->text() [==] " WHERE id BETWEEN 0 AND 1 OR id BETWEEN 0 AND 1 OR id BETWEEN 0 AND 1 OR id BETWEEN 0 AND 1"