Kohana_DB
Provides a shortcut to get Database related objects for making queries.
You pass the same parameters to these functions as you pass to the objects they return.
Constants
- None
Properties
- None
Methods
public static delete([ string $table = NULL ] ) (defined in Kohana_DB)
Create a new Database_Query_Builder_Delete.
// DELETE FROM users
$query = DB::delete('users');
Parameters
- string $table = NULL - Table to delete from
Return Values
- Database_Query_Builder_Delete
Source Code
public static function delete($table = NULL)
{
return new Database_Query_Builder_Delete($table);
}
public static expr(string $string [, array $parameters = array(0) ] ) (defined in Kohana_DB)
Create a new Database_Expression which is not escaped. An expression is the only way to use SQL functions within query builders.
$expression = DB::expr('COUNT(users.id)');
$query = DB::update('users')->set(array('login_count' => DB::expr('login_count + 1')))->where('id', '=', $id);
$users = ORM::factory('user')->where(DB::expr("BINARY `hash`"), '=', $hash)->find();
Parameters
- string $string required - Expression
- array $parameters = array(0) - Parameters
Return Values
- Database_Expression
Source Code
public static function expr($string, $parameters = [])
{
return new Database_Expression($string, $parameters);
}
public static insert([ string $table = NULL , array $columns = NULL ] ) (defined in Kohana_DB)
Create a new Database_Query_Builder_Insert.
// INSERT INTO users (id, username)
$query = DB::insert('users', array('id', 'username'));
Parameters
- string $table = NULL - Table to insert into
- array $columns = NULL - List of column names or array($column, $alias) or object
Return Values
- Database_Query_Builder_Insert
Source Code
public static function insert($table = NULL, array $columns = NULL)
{
return new Database_Query_Builder_Insert($table, $columns);
}
public static query(integer $type , string $sql ) (defined in Kohana_DB)
Create a new Database_Query of the given type.
// Create a new SELECT query
$query = DB::query(Database::SELECT, 'SELECT * FROM users');
// Create a new DELETE query
$query = DB::query(Database::DELETE, 'DELETE FROM users WHERE id = 5');
Specifying the type changes the returned result. When using
Database::SELECT, a Database_Query_Result will be returned.
Database::INSERT queries will return the insert id and number of rows.
For all other queries, the number of affected rows is returned.
Parameters
- integer $type required - Type: Database::SELECT, Database::UPDATE, etc
- string $sql required - SQL statement
Return Values
- Database_Query
Source Code
public static function query($type, $sql)
{
return new Database_Query($type, $sql);
}
public static select([ mixed $columns = NULL ] ) (defined in Kohana_DB)
Create a new Database_Query_Builder_Select. Each argument will be
treated as a column. To generate a foo AS bar alias, use an array.
// SELECT id, username
$query = DB::select('id', 'username');
// SELECT id AS user_id
$query = DB::select(array('id', 'user_id'));
Parameters
- mixed $columns = NULL - Column name or array($column, $alias) or object
Return Values
- Database_Query_Builder_Select
Source Code
public static function select($columns = NULL)
{
return new Database_Query_Builder_Select(func_get_args());
}
public static select_array([ array $columns = NULL ] ) (defined in Kohana_DB)
Create a new Database_Query_Builder_Select from an array of columns.
// SELECT id, username
$query = DB::select_array(array('id', 'username'));
Parameters
- array $columns = NULL - Columns to select
Return Values
- Database_Query_Builder_Select
Source Code
public static function select_array(array $columns = NULL)
{
return new Database_Query_Builder_Select($columns);
}
public static update([ string $table = NULL ] ) (defined in Kohana_DB)
Create a new Database_Query_Builder_Update.
// UPDATE users
$query = DB::update('users');
Parameters
- string $table = NULL - Table to update
Return Values
- Database_Query_Builder_Update
Source Code
public static function update($table = NULL)
{
return new Database_Query_Builder_Update($table);
}
