SelectStatement
extends Statement
in package
implements
ISelectStatement
FinalYes
Tags
Table of Contents
Interfaces
Properties
- $dml_statement_syntax_pregs : array<string|int, mixed>
- $from_clause : IFromClause
- $group_by_clause : IGroupByClause
- $having_clause : IHavingClause
- $limit_clause : ILimitClause
- $modifiers : int
- $order_by_clause : IOrderByClause
- $parent : ISelectStatement
- $schemas : array<string|int, mixed>
- $select_clause : ISelectClause
- $statement_syntax_pregs : array<string|int, mixed>
- $where_clause : IWhereClause
- $hashCode : int
- $hashCounter : int
Methods
- __call() : mixed
- __callStatic() : mixed
- __construct() : mixed
- __destruct() : mixed
- __get() : mixed
- __toString() : mixed
- {@inheritdoc}
- addGroupBy() : mixed
- addOrderBy() : mixed
- addSelectColumn() : mixed
- andHaving() : mixed
- andWhere() : mixed
- extends() : bool
- fromString() : IStatement|null
- getFromClause() : IFromClause
- getGroupByClause() : IGroupByClause
- getHavingClause() : IHavingClause
- getLimitClause() : ILimitClause
- getOrderByClause() : IOrderByClause
- getReflection() : ReflectionClass
- getSelectClause() : ISelectClause
- getSelectColumns() : array<string|int, mixed>
- getWhereClause() : IWhereClause
- groupBy() : mixed
- having() : mixed
- isOff() : bool
- isOn() : bool
- limit() : mixed
- off() : mixed
- on() : mixed
- orderBy() : mixed
- orHaving() : mixed
- orWhere() : mixed
- where() : ISelectStatement
- init() : mixed
- {@inheritdoc}
- setSchemas() : mixed
- _groupBy() : mixed
- _having() : mixed
- _where() : mixed
Properties
$dml_statement_syntax_pregs
protected
static array<string|int, mixed>
$dml_statement_syntax_pregs
= ["select" => "/^(SELECT )/i"]
$from_clause
protected
IFromClause
$from_clause
$group_by_clause
protected
IGroupByClause
$group_by_clause
$having_clause
protected
IHavingClause
$having_clause
$limit_clause
protected
ILimitClause
$limit_clause
$modifiers
protected
int
$modifiers
$order_by_clause
protected
IOrderByClause
$order_by_clause
$parent
protected
ISelectStatement
$parent
$schemas
protected
array<string|int, mixed>
$schemas
= []
$select_clause
protected
ISelectClause
$select_clause
$statement_syntax_pregs
protected
static array<string|int, mixed>
$statement_syntax_pregs
= ["ddl" => "", "dml" => "/^(CALL|DELETE|DO|HANDLE|IMPORT TABLE|INSERT|LOAD DATA INFILE|LOAD XML|REPLACE|SELECT|WITH)/i", "tcl" => "", "utility" => "/^(DESCRIBE|DESC|EXPLAIN|HELP|USE)/i"]
$where_clause
protected
IWhereClause
$where_clause
$hashCode
private
int
$hashCode
$hashCounter
private
static int
$hashCounter
= 0
Methods
__call()
public
__call(string $method, array<string|int, mixed> $arguments) : mixed
Parameters
- $method : string
- $arguments : array<string|int, mixed>
Tags
__callStatic()
public
static __callStatic(mixed $method, array<string|int, mixed> $arguments) : mixed
Parameters
- $method : mixed
- $arguments : array<string|int, mixed>
__construct()
public
__construct(ITable $table) : mixed
Parameters
- $table : ITable
__destruct()
public
__destruct() : mixed
__get()
public
__get(string $property) : mixed
Parameters
- $property : string
__toString()
{@inheritdoc}
public
__toString() : mixed
Tags
addGroupBy()
public
addGroupBy(array<string|int, mixed> $group_by) : mixed
Parameters
- $group_by : array<string|int, mixed>
Tags
addOrderBy()
public
addOrderBy(mixed $expression[, mixed $order = IOrderByClause::ORDER_ASC ]) : mixed
Parameters
- $expression : mixed
- $order : mixed = IOrderByClause::ORDER_ASC
Tags
addSelectColumn()
public
addSelectColumn(mixed $column[, mixed $alias = null ]) : mixed
Parameters
- $column : mixed
- $alias : mixed = null
Tags
andHaving()
public
andHaving(mixed $having) : mixed
Parameters
- $having : mixed
Tags
andWhere()
public
andWhere(mixed $where) : mixed
Parameters
- $where : mixed
Tags
extends()
public
extends(ReflectionClass $reflector) : bool
Parameters
- $reflector : ReflectionClass
Return values
boolfromString()
public
static fromString(string $statement, array<string|int, mixed> $schemas) : IStatement|null
Parameters
- $statement : string
- $schemas : array<string|int, mixed>
-
The schemas the statement is to be created for and to/will be executed on
Tags
Return values
IStatement|nullgetFromClause()
public
getFromClause() : IFromClause
Tags
Return values
IFromClausegetGroupByClause()
public
getGroupByClause() : IGroupByClause
Tags
Return values
IGroupByClausegetHavingClause()
public
getHavingClause() : IHavingClause
Tags
Return values
IHavingClausegetLimitClause()
public
getLimitClause() : ILimitClause
Tags
Return values
ILimitClausegetOrderByClause()
public
getOrderByClause() : IOrderByClause
Tags
Return values
IOrderByClausegetReflection()
public
getReflection() : ReflectionClass
Return values
ReflectionClassgetSelectClause()
public
getSelectClause() : ISelectClause
Tags
Return values
ISelectClausegetSelectColumns()
public
getSelectColumns() : array<string|int, mixed>
Return values
array<string|int, mixed>getWhereClause()
public
getWhereClause() : IWhereClause
Tags
Return values
IWhereClausegroupBy()
public
groupBy(array<string|int, mixed> $group_by) : mixed
Parameters
- $group_by : array<string|int, mixed>
Tags
having()
public
having(mixed $having) : mixed
Parameters
- $having : mixed
Tags
isOff()
public
isOff(int $bit) : bool
Parameters
- $bit : int
Tags
Return values
boolisOn()
public
isOn(int $bit) : bool
Parameters
- $bit : int
Tags
Return values
boollimit()
public
limit(mixed $limit) : mixed
Parameters
- $limit : mixed
Tags
off()
public
off(int $bit) : mixed
Parameters
- $bit : int
Tags
on()
public
on(int $bit) : mixed
Parameters
- $bit : int
Tags
orderBy()
public
orderBy(mixed $expression[, mixed $order = IOrderByClause::ORDER_ASC ]) : mixed
Parameters
- $expression : mixed
- $order : mixed = IOrderByClause::ORDER_ASC
Tags
orHaving()
public
orHaving(mixed $having) : mixed
Parameters
- $having : mixed
Tags
orWhere()
public
orWhere(mixed $where) : mixed
Parameters
- $where : mixed
Tags
where()
public
where(mixed $where) : ISelectStatement
Parameters
- $where : mixed
Tags
Return values
ISelectStatementinit()
{@inheritdoc}
protected
init() : mixed
setSchemas()
protected
setSchemas(array<string|int, mixed> $schemas) : mixed
Parameters
- $schemas : array<string|int, mixed>
_groupBy()
private
_groupBy(array<string|int, mixed> $group_by) : mixed
Parameters
- $group_by : array<string|int, mixed>
_having()
private
_having(array<string|int, mixed>|callable $having[, mixed $operator = IConditionalExpression::LOGICAL_OPERATOR_AND ]) : mixed
Parameters
- $having : array<string|int, mixed>|callable
- $operator : mixed = IConditionalExpression::LOGICAL_OPERATOR_AND
Tags
_where()
private
_where(array<string|int, mixed>|callable $where[, mixed $logical_operator = IConditionalExpression::LOGICAL_OPERATOR_AND ]) : mixed
Parameters
- $where : array<string|int, mixed>|callable
- $logical_operator : mixed = IConditionalExpression::LOGICAL_OPERATOR_AND