Query Builder¶
Query builder makes it easier to working with SQL statements.
Select¶
Query builder provide a chainable API to build SQL query like a charm.
<?php
$users = $db->builder()
->select('username, email')
->from('user')
->where('level > :level', array(':level' => $level))
->limit(10)
->orderBy('username ASC')
->queryAll();
In addition to queryAll
to fetch all rows, you can use:
queryRow
to get the first rowqueryValue
to get the first column of first row (the value)queryColumn
to get the first column of all rows
Parameter Binding¶
Both named placeholder and question mark placeholder are supported:
<?php
$db->builder()
->where('username = ? and password = ?', [$name, $password]);
$db->builder()
->where('username = :name and password = :password', [
':name' => $name,
':password' => $password
]);
Condition¶
TODO
Insert¶
<?php
$db->builder()
->insert('user', array(
'userame' => 'test',
'email' => 'test@example.com',
));
Update¶
<?php
$db->builder()
->update(
'user',
array(
'email' => 'test1@example.com',
), // columns to be updated
'username = :username', // conditions
array(':username' => $username) // params
);
Delete¶
$db->builder()
->delete(
'user',
'username = :username',
array(':username' => $username)
);