Methods

__clone

__clone() : void
Inherited

Resets the where object each time the Select is cloned.

inherited_from \Zend\Db\Sql\Select::__clone()

Constructor

__construct(null | string | array | \Zend\Db\Sql\TableIdentifier $table) 
Inherited

inherited_from \Zend\Db\Sql\Select::__construct()

Parameters

$table

nullstringarray\Zend\Db\Sql\TableIdentifier

Variable overloading

__get(string $name) : mixed
Inherited

inherited_from \Zend\Db\Sql\Select::__get()

Parameters

$name

string

Exceptions

\Zend\Db\Sql\Exception\InvalidArgumentException

Returns

mixed

Specify columns from which to select

columns(array $columns, bool $prefixColumnsWithTable) : \Zend\Db\Sql\Select
Inherited

Possible valid states:

array(*)

array(value, ...) value can be strings or Expression objects

array(string => value, ...) key string will be use as alias, value can be string or Expression objects

inherited_from \Zend\Db\Sql\Select::columns()

Parameters

$columns

array

$prefixColumnsWithTable

bool

Returns

combine()

combine(\Zend\Db\Sql\Select $select, string $type, string $modifier) : \Zend\Db\Sql\Select
Inherited

inherited_from \Zend\Db\Sql\Select::combine()

Parameters

$type

string

$modifier

string

Exceptions

\Zend\Db\Sql\Exception\InvalidArgumentException

Returns

Create from clause

from(string | array | \Zend\Db\Sql\TableIdentifier $table) : \Zend\Db\Sql\Select
Inherited

inherited_from \Zend\Db\Sql\Select::from()

Parameters

$table

stringarray\Zend\Db\Sql\TableIdentifier

Exceptions

\Zend\Db\Sql\Exception\InvalidArgumentException

Returns

getRawState()

getRawState($key) 
Inherited

inherited_from \Zend\Db\Sql\Select::getRawState()

Parameters

$key

Get SQL string for statement

getSqlString(\Zend\Db\Adapter\Platform\PlatformInterface $adapterPlatform) : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::getSqlString()
inherited_from \Zend\Db\Sql\AbstractPreparableSql::getSqlString()
inherited_from \Zend\Db\Sql\Select::getSqlString()

Parameters

Returns

string

group()

group($group) 
Inherited

inherited_from \Zend\Db\Sql\Select::group()

Parameters

$group

Create where clause

having(\Zend\Db\Sql\Where | \Closure | string | array $predicate, string $combination) : \Zend\Db\Sql\Select
Inherited

inherited_from \Zend\Db\Sql\Select::having()

Parameters

$predicate

\Zend\Db\Sql\Where\Closurestringarray

$combination

string

One of the OP_* constants from Predicate\PredicateSet

Returns

Returns whether the table is read only or not.

isTableReadOnly() : bool
Inherited

inherited_from \Zend\Db\Sql\Select::isTableReadOnly()

Returns

bool

Create join clause

join(string | array $name, string $on, string | array $columns, string $type) : \Zend\Db\Sql\Select
Inherited

inherited_from \Zend\Db\Sql\Select::join()

Parameters

$name

stringarray

$on

string

$columns

stringarray

$type

string

one of the JOIN_* constants

Exceptions

\Zend\Db\Sql\Exception\InvalidArgumentException

Returns

limit()

limit(int $limit) : \Zend\Db\Sql\Select
Inherited

inherited_from \Zend\Db\Sql\Select::limit()

Parameters

$limit

int

Returns

offset()

offset(int $offset) : \Zend\Db\Sql\Select
Inherited

inherited_from \Zend\Db\Sql\Select::offset()

Parameters

$offset

int

Returns

order()

order(string | array $order) : \Zend\Db\Sql\Select
Inherited

inherited_from \Zend\Db\Sql\Select::order()

Parameters

$order

stringarray

Returns

prepareStatement()

prepareStatement(\Zend\Db\Adapter\AdapterInterface $adapter, \Zend\Db\Adapter\StatementContainerInterface $statementContainer) : \Zend\Db\Adapter\StatementContainerInterface
Inherited

inherited_from \Zend\Db\Sql\AbstractPreparableSql::prepareStatement()
inherited_from \Zend\Db\Sql\Select::prepareStatement()

Parameters

Returns

quantifier()

quantifier(string | \Zend\Db\Sql\Expression $quantifier) : \Zend\Db\Sql\Select
Inherited

inherited_from \Zend\Db\Sql\Select::quantifier()

Parameters

$quantifier

string\Zend\Db\Sql\Expression

DISTINCT|ALL

Returns

reset()

reset(string $part) : \Zend\Db\Sql\Select
Inherited

inherited_from \Zend\Db\Sql\Select::reset()

Parameters

$part

string

Exceptions

\Zend\Db\Sql\Exception\InvalidArgumentException

Returns

setSpecification()

setSpecification($index, $specification) 
Inherited

inherited_from \Zend\Db\Sql\Select::setSpecification()

Parameters

$index

$specification

setSubject()

setSubject(\Zend\Db\Sql\Select $select) : \Zend\Db\Sql\Platform\self

Parameters

Returns

\Zend\Db\Sql\Platform\self

Create where clause

where(\Zend\Db\Sql\Where | \Closure | string | array | \Zend\Db\Sql\Predicate\PredicateInterface $predicate, string $combination) : \Zend\Db\Sql\Select
Inherited

inherited_from \Zend\Db\Sql\Select::where()

Parameters

$combination

string

One of the OP_* constants from Predicate\PredicateSet

Exceptions

\Zend\Db\Sql\Exception\InvalidArgumentException

Returns

buildSqlString()

buildSqlString(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::buildSqlString()
inherited_from \Zend\Db\Sql\AbstractPreparableSql::buildSqlString()
inherited_from \Zend\Db\Sql\Select::buildSqlString()

Parameters

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

Returns

string

createSqlFromSpecificationAndParameters()

createSqlFromSpecificationAndParameters(string | array $specifications, string | array $parameters) : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::createSqlFromSpecificationAndParameters()
inherited_from \Zend\Db\Sql\AbstractPreparableSql::createSqlFromSpecificationAndParameters()
inherited_from \Zend\Db\Sql\Select::createSqlFromSpecificationAndParameters()

Parameters

$specifications

stringarray

$parameters

stringarray

Exceptions

\Zend\Db\Sql\Exception\RuntimeException

Returns

string

Copy variables from the subject into the local properties

localizeVariables() 

processCombine()

processCombine(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) 
Inherited

inherited_from \Zend\Db\Sql\Select::processCombine()

Parameters

$platform

$driver

$parameterContainer

processExpression()

processExpression(\Zend\Db\Sql\ExpressionInterface $expression, \Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer, null | string $namedParameterPrefix) : string
Inherited

staticvar int $runtimeExpressionPrefix
inherited_from \Zend\Db\Sql\AbstractSql::processExpression()
inherited_from \Zend\Db\Sql\AbstractPreparableSql::processExpression()
inherited_from \Zend\Db\Sql\Select::processExpression()

Parameters

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

$namedParameterPrefix

nullstring

Exceptions

\Zend\Db\Sql\Exception\RuntimeException

Returns

string

processGroup()

processGroup(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) 
Inherited

inherited_from \Zend\Db\Sql\Select::processGroup()

Parameters

$platform

$driver

$parameterContainer

processHaving()

processHaving(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) 
Inherited

inherited_from \Zend\Db\Sql\Select::processHaving()

Parameters

$platform

$driver

$parameterContainer

processJoins()

processJoins(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) 
Inherited

inherited_from \Zend\Db\Sql\Select::processJoins()

Parameters

$platform

$driver

$parameterContainer

processLimit()

processLimit(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) 
Inherited

inherited_from \Zend\Db\Sql\Select::processLimit()

Parameters

$platform

$driver

$parameterContainer

processLimitOffset()

processLimitOffset(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer, $sqls, $parameters) : null

Parameters

$sqls

$parameters

Returns

null

processOffset()

processOffset(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) 
Inherited

inherited_from \Zend\Db\Sql\Select::processOffset()

Parameters

$platform

$driver

$parameterContainer

processOrder()

processOrder(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) 
Inherited

inherited_from \Zend\Db\Sql\Select::processOrder()

Parameters

$platform

$driver

$parameterContainer

Process the select part

processSelect(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) : null | array
Inherited

inherited_from \Zend\Db\Sql\Select::processSelect()

Parameters

Returns

nullarray

processStatementEnd()

processStatementEnd(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) 
Inherited

inherited_from \Zend\Db\Sql\Select::processStatementEnd()

Parameters

$platform

$driver

$parameterContainer

processStatementStart()

processStatementStart(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) 
Inherited

inherited_from \Zend\Db\Sql\Select::processStatementStart()

Parameters

$platform

$driver

$parameterContainer

processSubSelect()

processSubSelect(\Zend\Db\Sql\Select $subselect, \Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::processSubSelect()
inherited_from \Zend\Db\Sql\AbstractPreparableSql::processSubSelect()
inherited_from \Zend\Db\Sql\Select::processSubSelect()

Parameters

$subselect

\Zend\Db\Sql\Select

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

Returns

string

processWhere()

processWhere(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) 
Inherited

inherited_from \Zend\Db\Sql\Select::processWhere()

Parameters

$platform

$driver

$parameterContainer

Render table with alias in from/join parts

renderTable(string $table, string $alias) : string

see \Zend\Db\Sql\Select::renderTable

Parameters

$table

string

$alias

string

Returns

string

resolveColumnValue()

resolveColumnValue(null | array | \Zend\Db\Sql\ExpressionInterface | \Zend\Db\Sql\Select $column, \Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer, null | string $namedParameterPrefix) : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::resolveColumnValue()
inherited_from \Zend\Db\Sql\AbstractPreparableSql::resolveColumnValue()
inherited_from \Zend\Db\Sql\Select::resolveColumnValue()

Parameters

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

$namedParameterPrefix

nullstring

Returns

string

resolveTable()

resolveTable(string | \Zend\Db\Sql\TableIdentifier | \Zend\Db\Sql\Select $table, \Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) : string
Inherited

inherited_from \Zend\Db\Sql\Select::resolveTable()

Parameters

Returns

string

 Properties

 

$columns

$columns : array
Inherited

inherited_from \Zend\Db\Sql\Select::$$columns
 

$combine

$combine : array
Inherited

inherited_from \Zend\Db\Sql\Select::$$combine
 

$group

$group : null | array
Inherited

inherited_from \Zend\Db\Sql\Select::$$group
 

$having

$having : null | string | array
Inherited

inherited_from \Zend\Db\Sql\Select::$$having
 

$instanceParameterIndex

$instanceParameterIndex : array
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::$$instanceParameterIndex
inherited_from \Zend\Db\Sql\AbstractPreparableSql::$$instanceParameterIndex
inherited_from \Zend\Db\Sql\Select::$$instanceParameterIndex
 

$joins

$joins : array
Inherited

inherited_from \Zend\Db\Sql\Select::$$joins
 

$limit

$limit : int | null
Inherited

inherited_from \Zend\Db\Sql\Select::$$limit
 

$offset

$offset : int | null
Inherited

inherited_from \Zend\Db\Sql\Select::$$offset
 

$order

$order : array
Inherited

inherited_from \Zend\Db\Sql\Select::$$order
 

$prefixColumnsWithTable

$prefixColumnsWithTable : bool
Inherited

inherited_from \Zend\Db\Sql\Select::$$prefixColumnsWithTable
 

$processInfo

$processInfo : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::$$processInfo
inherited_from \Zend\Db\Sql\AbstractPreparableSql::$$processInfo
inherited_from \Zend\Db\Sql\Select::$$processInfo
 

$quantifier

$quantifier : null | string | \Zend\Db\Sql\Expression
Inherited

inherited_from \Zend\Db\Sql\Select::$$quantifier
 

Specifications for Sql String generation

$specifications : array
Inherited

inherited_from \Zend\Db\Sql\Select::$$specifications
 

$subject

$subject : \Zend\Db\Sql\Select

 

$table

$table : string | array | \Zend\Db\Sql\TableIdentifier
Inherited

inherited_from \Zend\Db\Sql\Select::$$table
 

$tableReadOnly

$tableReadOnly : bool
Inherited

inherited_from \Zend\Db\Sql\Select::$$tableReadOnly
 

$where

$where : \Zend\Db\Sql\Where
Inherited

inherited_from \Zend\Db\Sql\Select::$$where

 Constants

 

COLUMNS

COLUMNS 
Inherited

inherited_from \Zend\Db\Sql\Select::COLUMNS
 

COMBINE

COMBINE 
Inherited

inherited_from \Zend\Db\Sql\Select::COMBINE
 

COMBINE_EXCEPT

COMBINE_EXCEPT 
Inherited

inherited_from \Zend\Db\Sql\Select::COMBINE_EXCEPT
 

COMBINE_INTERSECT

COMBINE_INTERSECT 
Inherited

inherited_from \Zend\Db\Sql\Select::COMBINE_INTERSECT
 

COMBINE_UNION

COMBINE_UNION 
Inherited

inherited_from \Zend\Db\Sql\Select::COMBINE_UNION
 

GROUP

GROUP 
Inherited

inherited_from \Zend\Db\Sql\Select::GROUP
 

HAVING

HAVING 
Inherited

inherited_from \Zend\Db\Sql\Select::HAVING
 

JOINS

JOINS 
Inherited

inherited_from \Zend\Db\Sql\Select::JOINS
 

JOIN_INNER

JOIN_INNER 
Inherited

inherited_from \Zend\Db\Sql\Select::JOIN_INNER
 

JOIN_LEFT

JOIN_LEFT 
Inherited

inherited_from \Zend\Db\Sql\Select::JOIN_LEFT
 

JOIN_OUTER

JOIN_OUTER 
Inherited

inherited_from \Zend\Db\Sql\Select::JOIN_OUTER
 

JOIN_OUTER_LEFT

JOIN_OUTER_LEFT 
Inherited

inherited_from \Zend\Db\Sql\Select::JOIN_OUTER_LEFT
 

JOIN_OUTER_RIGHT

JOIN_OUTER_RIGHT 
Inherited

inherited_from \Zend\Db\Sql\Select::JOIN_OUTER_RIGHT
 

JOIN_RIGHT

JOIN_RIGHT 
Inherited

inherited_from \Zend\Db\Sql\Select::JOIN_RIGHT
 

LIMIT

LIMIT 
Inherited

inherited_from \Zend\Db\Sql\Select::LIMIT
 

OFFSET

OFFSET 
Inherited

inherited_from \Zend\Db\Sql\Select::OFFSET
 

ORDER

ORDER 
Inherited

inherited_from \Zend\Db\Sql\Select::ORDER
 

ORDER_ASCENDING

ORDER_ASCENDING 
Inherited

inherited_from \Zend\Db\Sql\Select::ORDER_ASCENDING
 

ORDER_DESCENDING

ORDER_DESCENDING 
Inherited

inherited_from \Zend\Db\Sql\Select::ORDER_DESCENDING
 

QUANTIFIER

QUANTIFIER 
Inherited

inherited_from \Zend\Db\Sql\Select::QUANTIFIER
 

QUANTIFIER_ALL

QUANTIFIER_ALL 
Inherited

inherited_from \Zend\Db\Sql\Select::QUANTIFIER_ALL
 

QUANTIFIER_DISTINCT

QUANTIFIER_DISTINCT 
Inherited

inherited_from \Zend\Db\Sql\Select::QUANTIFIER_DISTINCT
 

SELECT

SELECT 
Inherited

inherited_from \Zend\Db\Sql\Select::SELECT
 

SQL_STAR

SQL_STAR 
Inherited

inherited_from \Zend\Db\Sql\Select::SQL_STAR
 

TABLE

TABLE 
Inherited

inherited_from \Zend\Db\Sql\Select::TABLE
 

WHERE

WHERE 
Inherited

inherited_from \Zend\Db\Sql\Select::WHERE