__construct()
and_having()
and_having_close()
and_having_open()
and_on()
compile()
distinct()
from()
group_by()
having()
having_close()
having_open()
join()
offset()
on()
on_close()
on_open()
or_having()
or_having_close()
or_having_open()
or_on()
reset()
select()
select_array()
$_distinct
$_from
$_group_by
$_having
$_join
$_last_join
$_offset
$_select
__construct(array $columns)
arraycolumn list
and_having(mixed $column, string $op, mixed $value) : \Fuel\Core\Database_Query_Builder_Select
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
mixedcolumn name or array($column, $alias) or object
stringlogic operator
mixedcolumn value
and_having_close() : \Fuel\Core\Database_Query_Builder_Select
..)" grouping.
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
and_having_open() : \Fuel\Core\Database_Query_Builder_Select
..)" grouping.
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
and_on(mixed $c1, string $op, mixed $c2) : \Fuel\Core\Database_Query_Builder_Select
.." conditions for the last created JOIN statement.
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
mixedcolumn name or array($column, $alias) or object
stringlogic operator
mixedcolumn name or array($column, $alias) or object
compile(mixed $db) : string
mixedDatabase_Connection instance or instance name
stringdistinct(boolean $value) : \Fuel\Core\Database_Query_Builder_Select
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
booleanenable or disable distinct columns
from(mixed $tables) : \Fuel\Core\Database_Query_Builder_Select
.."
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
mixedtable name or array($table, $alias)
group_by(mixed $columns) : \Fuel\Core\Database_Query_Builder_Select
.." filter.
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
mixedcolumn name or array($column, $column) or object
having(mixed $column, string $op, mixed $value) : \Fuel\Core\Database_Query_Builder_Select
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
mixedcolumn name or array($column, $alias) or object
stringlogic operator
mixedcolumn value
having_close() : \Fuel\Core\Database_Query_Builder_Select
..)" grouping.
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
having_open() : \Fuel\Core\Database_Query_Builder_Select
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
join(mixed $table, string $type) : \Fuel\Core\Database_Query_Builder_Select
..".
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
mixedcolumn name or array($column, $alias)
stringjoin type (LEFT, RIGHT, INNER, etc)
offset(integer $number) : \Fuel\Core\Database_Query_Builder_Select
.."
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
integerstarting result number
on(mixed $c1, string $op, mixed $c2) : \Fuel\Core\Database_Query_Builder_Select
.." conditions for the last created JOIN statement.
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
mixedcolumn name or array($column, $alias) or object
stringlogic operator
mixedcolumn name or array($column, $alias) or object
on_close() : \Fuel\Core\Database_Query_Builder_Select
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
on_open() : \Fuel\Core\Database_Query_Builder_Select
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
or_having(mixed $column, string $op, mixed $value) : \Fuel\Core\Database_Query_Builder_Select
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
mixedcolumn name or array($column, $alias) or object
stringlogic operator
mixedcolumn value
or_having_close() : \Fuel\Core\Database_Query_Builder_Select
..)" grouping.
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
or_having_open() : \Fuel\Core\Database_Query_Builder_Select
..)" grouping.
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
or_on(mixed $c1, string $op, mixed $c2) : \Fuel\Core\Database_Query_Builder_Select
.." conditions for the last created JOIN statement.
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
mixedcolumn name or array($column, $alias) or object
stringlogic operator
mixedcolumn name or array($column, $alias) or object
reset() : \Fuel\Core\Database_Query_Builder_Select
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
select(mixed $columns) : \Fuel\Core\Database_Query_Builder_Select
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
mixedcolumn name or array($column, $alias) or object
select_array(array $columns, bool $reset) : \Fuel\Core\Database_Query_Builder_Select
| fluent | This method is part of a fluent interface and will return the same instance |
|---|
arraylist of column names or aliases
boolif true, don't merge but overwrite
$_distinct : bool
$_from : array
$_group_by : array
$_having : array
$_join : array
$_offset : integer
$_select : array
