Methods

Creates a new "AND WHERE" condition for the query.

and_where(mixed $column, string $op, mixed $value) : \Fuel\Core\Database_Query_Builder_Where

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

Parameters

$column

mixed

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

$op

string

logic operator

$value

mixed

column value

Returns

Closes an open "AND WHERE (.

and_where_close() : \Fuel\Core\Database_Query_Builder_Where

..)" grouping.

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

Returns

Opens a new "AND WHERE (.

and_where_open() : \Fuel\Core\Database_Query_Builder_Where

..)" grouping.

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

Returns

Return up to "LIMIT .

limit(integer $number) : \Fuel\Core\Database_Query_Builder_Where

.." results

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

Parameters

$number

integer

maximum results to return

Returns

Creates a new "OR WHERE" condition for the query.

or_where(mixed $column, string $op, mixed $value) : \Fuel\Core\Database_Query_Builder_Where

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

Parameters

$column

mixed

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

$op

string

logic operator

$value

mixed

column value

Returns

Closes an open "OR WHERE (.

or_where_close() : \Fuel\Core\Database_Query_Builder_Where

..)" grouping.

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

Returns

Opens a new "OR WHERE (.

or_where_open() : \Fuel\Core\Database_Query_Builder_Where

..)" grouping.

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

Returns

Applies sorting with "ORDER BY .

order_by(mixed $column, string $direction) : \Fuel\Core\Database_Query_Builder_Where

.."

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

Parameters

$column

mixed

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

$direction

string

direction of sorting

Returns

Alias of and_where()

where() : \Fuel\Core\Database_Query_Builder_Where

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

Returns

Closes an open "AND WHERE (.

where_close() : \Fuel\Core\Database_Query_Builder_Where

..)" grouping.

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

Returns

Alias of and_where_open()

where_open() : \Fuel\Core\Database_Query_Builder_Where

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

Returns

 Properties

 

$_limit

$_limit : integer

 

<p>order by clause</p>

$_order_by : array

 

<p>where statements</p>

$_where : array