Query builder makes it easier to working with SQL statements.
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
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
]);
TODO
<?php
$db->builder()
->insert('user', array(
'userame' => 'test',
'email' => 'test@example.com',
));
<?php
$db->builder()
->update(
'user',
array(
'email' => 'test1@example.com',
), // columns to be updated
'username = :username', // conditions
array(':username' => $username) // params
);
$db->builder()
->delete(
'user',
'username = :username',
array(':username' => $username)
);