Modules

DB
extends Kohana_DB

Provides a shortcut to get Database related objects for making queries.

Shortcut Returned Object
DB::query() Database_Query
DB::insert() Database_Query_Builder_Insert
DB::select(),
DB::select_array()
Database_Query_Builder_Select
DB::update() Database_Query_Builder_Update
DB::delete() Database_Query_Builder_Delete
DB::expr() Database_Expression

You pass the same parameters to these functions as you pass to the objects they return.

package
Kohana/Database
category
Base
author
Kohana Team
copyright
© 2009 Kohana Team
license
http://kohanaphp.com/license

Class declared in MODPATH/database/classes/db.php on line 3.

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 = array())
{
	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);
}