ISelectStatement
extends
IStatement
in
Tags
Table of Contents
Constants
- MODIFIER_ALL = 1
- MODIFIER_DISTINCT = 2
- MODIFIER_DISTINCT_ROW = 2
- MODIFIER_HIGH_PRIORITY = 4
- MODIFIER_SQL_BIG_RESULT = 32
- MODIFIER_SQL_BUFFER_RESULT = 64
- MODIFIER_SQL_CALC_FOUND_ROWS = 128
- MODIFIER_SQL_SMALL_RESULT = 16
- MODIFIER_STRAIGHT_JOIN = 8
Methods
- addGroupBy() : mixed
- addOrderBy() : mixed
- addSelectColumn() : mixed
- andHaving() : mixed
- andWhere() : mixed
- getFromClause() : IFromClause
- getGroupByClause() : IGroupByClause
- getHavingClause() : IHavingClause
- getLimitClause() : ILimitClause
- getOrderByClause() : IOrderByClause
- getSelectClause() : ISelectClause
- getWhereClause() : IWhereClause
- groupBy() : mixed
- having() : mixed
- limit() : mixed
- orderBy() : mixed
- orHaving() : mixed
- orWhere() : mixed
- where() : ISelectStatement
Constants
MODIFIER_ALL
public
mixed
MODIFIER_ALL
= 1
MODIFIER_DISTINCT
public
mixed
MODIFIER_DISTINCT
= 2
MODIFIER_DISTINCT_ROW
public
mixed
MODIFIER_DISTINCT_ROW
= 2
MODIFIER_HIGH_PRIORITY
public
mixed
MODIFIER_HIGH_PRIORITY
= 4
MODIFIER_SQL_BIG_RESULT
public
mixed
MODIFIER_SQL_BIG_RESULT
= 32
MODIFIER_SQL_BUFFER_RESULT
public
mixed
MODIFIER_SQL_BUFFER_RESULT
= 64
MODIFIER_SQL_CALC_FOUND_ROWS
public
mixed
MODIFIER_SQL_CALC_FOUND_ROWS
= 128
MODIFIER_SQL_SMALL_RESULT
public
mixed
MODIFIER_SQL_SMALL_RESULT
= 16
MODIFIER_STRAIGHT_JOIN
public
mixed
MODIFIER_STRAIGHT_JOIN
= 8
Methods
addGroupBy()
public
addGroupBy(array<string|int, mixed> $group_by) : mixed
Parameters
- $group_by : array<string|int, mixed>
addOrderBy()
public
addOrderBy(string $field[, int $order = IOrderByClause::ORDER_ASC ]) : mixed
Parameters
- $field : string
- $order : int = IOrderByClause::ORDER_ASC
addSelectColumn()
public
addSelectColumn(string $column[, string $alias = null ]) : mixed
Parameters
- $column : string
- $alias : string = null
andHaving()
public
andHaving(array<string|int, mixed>|IConditionalExpression $having) : mixed
Parameters
- $having : array<string|int, mixed>|IConditionalExpression
andWhere()
public
andWhere(array<string|int, mixed>|callable $where) : mixed
Parameters
- $where : array<string|int, mixed>|callable
getFromClause()
public
getFromClause() : IFromClause
Return values
IFromClausegetGroupByClause()
public
getGroupByClause() : IGroupByClause
Return values
IGroupByClausegetHavingClause()
public
getHavingClause() : IHavingClause
Return values
IHavingClausegetLimitClause()
public
getLimitClause() : ILimitClause
Return values
ILimitClausegetOrderByClause()
public
getOrderByClause() : IOrderByClause
Return values
IOrderByClausegetSelectClause()
public
getSelectClause() : ISelectClause
Return values
ISelectClausegetWhereClause()
public
getWhereClause() : IWhereClause
Return values
IWhereClausegroupBy()
public
groupBy(array<string|int, mixed> $group_by) : mixed
Parameters
- $group_by : array<string|int, mixed>
having()
public
having(array<string|int, mixed>|IConditionalExpression $having) : mixed
Parameters
- $having : array<string|int, mixed>|IConditionalExpression
limit()
public
limit(int|array<string|int, mixed> $limit) : mixed
Parameters
- $limit : int|array<string|int, mixed>
orderBy()
public
orderBy(string $field[, int $order = IOrderByClause::ORDER_ASC ]) : mixed
Parameters
- $field : string
- $order : int = IOrderByClause::ORDER_ASC
orHaving()
public
orHaving(array<string|int, mixed>|IConditionalExpression $having) : mixed
Parameters
- $having : array<string|int, mixed>|IConditionalExpression
orWhere()
public
orWhere(array<string|int, mixed>|callable $where) : mixed
Parameters
- $where : array<string|int, mixed>|callable
where()
public
where(array<string|int, mixed>|callable $where) : ISelectStatement
Parameters
- $where : array<string|int, mixed>|callable