Methods

Set the table for a update.

__construct(mixed $table) : void

Parameters

$table

mixed

table name or array($table, $alias) or object

Adds "AND ON .

and_on(mixed $c1, string $op, mixed $c2) : \Fuel\Core\Database_Query_Builder_Update

.." conditions for the last created JOIN statement.

fluent This method is part of a fluent interface and will return the same instance

Parameters

$c1

mixed

column name or array($column, $alias) or object

$op

string

logic operator

$c2

mixed

column name or array($column, $alias) or object

Returns

Compile the SQL query and return it.

compile(mixed $db) : string

Parameters

$db

mixed

Database instance or instance name

Returns

string

Adds addition tables to "JOIN .

join(mixed $table, string $type) : \Fuel\Core\Database_Query_Builder_Update

..".

fluent This method is part of a fluent interface and will return the same instance

Parameters

$table

mixed

column name or array($column, $alias) or object

$type

string

join type (LEFT, RIGHT, INNER, etc)

Returns

Adds "ON .

on(mixed $c1, string $op, mixed $c2) : \Fuel\Core\Database_Query_Builder_Update

.." conditions for the last created JOIN statement.

fluent This method is part of a fluent interface and will return the same instance

Parameters

$c1

mixed

column name or array($column, $alias) or object

$op

string

logic operator

$c2

mixed

column name or array($column, $alias) or object

Returns

Adds a closing bracket for the last created JOIN statement.

on_close() : \Fuel\Core\Database_Query_Builder_Update

fluent This method is part of a fluent interface and will return the same instance

Returns

Adds an opening bracket the last created JOIN statement.

on_open() : \Fuel\Core\Database_Query_Builder_Update

fluent This method is part of a fluent interface and will return the same instance

Returns

Adds "OR ON .

or_on(mixed $c1, string $op, mixed $c2) : \Fuel\Core\Database_Query_Builder_Update

.." conditions for the last created JOIN statement.

fluent This method is part of a fluent interface and will return the same instance

Parameters

$c1

mixed

column name or array($column, $alias) or object

$op

string

logic operator

$c2

mixed

column name or array($column, $alias) or object

Returns

Reset the query parameters

reset() : \Fuel\Core\Database_Query_Builder_Update

fluent This method is part of a fluent interface and will return the same instance

Returns

Set the values to update with an associative array.

set(array $pairs) : \Fuel\Core\Database_Query_Builder_Update

fluent This method is part of a fluent interface and will return the same instance

Parameters

$pairs

array

associative (column => value) list

Returns

Sets the table to update.

table(mixed $table) : \Fuel\Core\Database_Query_Builder_Update

fluent This method is part of a fluent interface and will return the same instance

Parameters

$table

mixed

table name or array($table, $alias)

Returns

Set the value of a single column.

value(mixed $column, mixed $value) : \Fuel\Core\Database_Query_Builder_Update

fluent This method is part of a fluent interface and will return the same instance

Parameters

$column

mixed

table name or array($table, $alias) or object

$value

mixed

column value

Returns

 Properties

 

<p>join statements</p>

$_join : array

 

<p>last join statement</p>

$_last_join : \Fuel\Core\Database_Query_Builder_Join

 

<p>update values</p>

$_set : array

 

<p>table name</p>

$_table : string