Summary

Fully Qualified Name:	Laminas\Db\Sql\Select
Extends:	AbstractPreparableSql

Description

Methods

Name	Description	Defined By
__clone()	__clone	Select
__construct()	Constructor	Select
__get()	Variable overloading	Select
columns()	Specify columns from which to select	Select
combine()		Select
from()	Create from clause	Select
getRawState()		Select
getSqlString()	{@inheritDoc}	AbstractSql
group()		Select
having()	Create having clause	Select
isTableReadOnly()	Returns whether the table is read only or not.	Select
join()	Create join clause	Select
limit()		Select
offset()		Select
order()		Select
prepareStatement()	{@inheritDoc}	AbstractPreparableSql
quantifier()		Select
reset()		Select
setSpecification()		Select
where()	Create where clause	Select

Method Details

__clone()

__clone

Resets the where object each time the Select is cloned.

Returns: void

__construct()

Constructor

Parameter Name	Type	Description
$table	null|string|array|\TableIdentifier

Returns:

__get()

Variable overloading

Parameter Name	Type	Description
$name	string

Returns: mixed

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

Parameter Name	Type	Description
$columns	array
$prefixColumnsWithTable	bool

Returns: self Provides a fluent interface

combine()

Parameter Name	Type	Description
$select	\Select
$type	string
$modifier	string

Returns: self Provides a fluent interface

from()

Create from clause

Parameter Name	Type	Description
$table	string|array|\TableIdentifier

Returns: self Provides a fluent interface

getRawState()

Parameter Name	Type	Description
$key

Returns: void

getSqlString()

{@inheritDoc}

Parameter Name	Type	Description
$adapterPlatform

Returns:

group()

Parameter Name	Type	Description
$group	mixed

Returns: self Provides a fluent interface

having()

Create having clause

Parameter Name	Type	Description
$predicate	\Where|\Closure|string|array
$combination	string	One

Returns: self Provides a fluent interface

isTableReadOnly()

Returns whether the table is read only or not.

Returns: bool

join()

Create join clause

Parameter Name	Type	Description
$name	string|array|\TableIdentifier
$on	string|\Predicate\Expression
$columns	string|array
$type	string	one

Returns: self Provides a fluent interface

limit()

Parameter Name	Type	Description
$limit	int

Returns: self Provides a fluent interface

offset()

Parameter Name	Type	Description
$offset	int

Returns: self Provides a fluent interface

order()

Parameter Name	Type	Description
$order	string|array|\Expression

Returns: self Provides a fluent interface

prepareStatement()

{@inheritDoc}

Parameter Name	Type	Description
$adapter
$statementContainer

Returns: \StatementContainerInterface

quantifier()

Parameter Name	Type	Description
$quantifier	string|\Expression	DISTINCT|ALL

Returns: self Provides a fluent interface

reset()

Parameter Name	Type	Description
$part	string

Returns: self Provides a fluent interface

setSpecification()

Parameter Name	Type	Description
	$specification
$index
$specification

Returns: self Provides a fluent interface

where()

Create where clause

Parameter Name	Type	Description
$predicate	\Where|\Closure|string|array|\Predicate\PredicateInterface
$combination	string	One

Returns: self Provides a fluent interface