1759. Class

1759.1. Zend\Db\Sql\Select

@property Where $where

1759.1.1. Methods

1759.1.1.1. __construct

__construct()

Constructor

Parameters:null|string –

1759.1.1.2. from

from()

Create from clause

Parameters:string|array|TableIdentifier – Throws ExceptionInvalidArgumentException:   Return type:Select

1759.1.1.3. columns

columns()

Specify columns from which to select

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

Parameters:

• array –
• bool –

Return type:

Select

1759.1.1.4. join

join()

Create join clause

Parameters:

• string|array –
• string –
• string|array –
• string – one of the JOIN_* constants

Throws ExceptionInvalidArgumentException:   Return type:

Select

1759.1.1.5. where

where()

Create where clause

Parameters:

• Where|Closure|string|array|PredicatePredicateInterface –
• string – One of the OP_* constants from PredicatePredicateSet

Return type:

Select

1759.1.1.6. group

group()

1759.1.1.7. having

having()

Create where clause

Parameters:

• Where|Closure|string|array –
• string – One of the OP_* constants from PredicatePredicateSet

Return type:

Select

1759.1.1.8. order

order()

@param string|array $order

Return type:Select

1759.1.1.9. limit

limit()

@param int $limit

Return type:Select

1759.1.1.10. offset

offset()

@param int $offset

Return type:Select

1759.1.1.11. reset

reset()

@param string $part

Return type:Select Throws :ExceptionInvalidArgumentException

1759.1.1.12. setSpecification

setSpecification()

1759.1.1.13. getRawState

getRawState()

1759.1.1.14. prepareStatement

prepareStatement()

Prepare statement

Parameters:

• AdapterInterface –
• StatementContainerInterface –

Return type:

void

1759.1.1.15. getSqlString

getSqlString()

Get SQL string for statement

Parameters:null|PlatformInterface – If null, defaults to Sql92 Return type:string

1759.1.1.16. isTableReadOnly

isTableReadOnly()

Returns whether the table is read only or not.

Return type:boolean

1759.1.1.17. processSelect

processSelect()

1759.1.1.18. processJoins

processJoins()

1759.1.1.19. processWhere

processWhere()

1759.1.1.20. processGroup

processGroup()

1759.1.1.21. processHaving

processHaving()

1759.1.1.22. processOrder

processOrder()

1759.1.1.23. processLimit

processLimit()

@var $orderParts ZendDbAdapterStatementContainer */

1759.1.1.24. processOffset

processOffset()

1759.1.1.25. __get

__get()

Variable overloading

Parameters:string – Throws ExceptionInvalidArgumentException:   Return type:mixed

1759.1.1.26. __clone

__clone()

__clone

Resets the where object each time the Select is cloned.

Return type:void

1759.1.2. Constants

1759.1.2.1. SELECT

1759.1.2.2. COLUMNS

1759.1.2.3. TABLE

1759.1.2.4. JOINS

1759.1.2.5. WHERE

1759.1.2.6. GROUP

1759.1.2.7. HAVING

1759.1.2.8. ORDER

1759.1.2.9. LIMIT

1759.1.2.10. OFFSET

1759.1.2.11. JOIN_INNER

1759.1.2.12. JOIN_OUTER

1759.1.2.13. JOIN_LEFT

1759.1.2.14. JOIN_RIGHT

1759.1.2.15. SQL_STAR

1759.1.2.16. ORDER_ASCENDING

1759.1.2.17. ORDER_DESCENDING