\Pop\Db\SqlSelect

setTable()

setTable(mixed  $table) : \Pop\Db\Sql\AbstractSql

Set the table

Parameters

Returns

hasAlias()

hasAlias() : boolean

Determine if there is an alias

Returns

getAlias()

getAlias() : string

Get the alias

Returns

setAlias()

setAlias(string  $alias) : \Pop\Db\Sql\AbstractSql

Set the alias

Parameters

Returns

getTable()

getTable() : string

Get the table

Returns

setValues()

setValues(array  $values) : \Pop\Db\Sql\AbstractSql

Set the values

Parameters

Returns

addValue()

addValue(mixed  $value) : \Pop\Db\Sql\AbstractSql

Add a value

Parameters

Returns

addNamedValue()

addNamedValue(string  $name, mixed  $value) : \Pop\Db\Sql\AbstractSql

Add a named value

Parameters

Returns

getValues()

getValues() : array

Get the values

Returns

getValue()

getValue(string  $name) : mixed

Get a value

Parameters

Returns

render()

render() : string

Render the SELECT statement

Throws

\Pop\Db\Sql\Exception

Returns

__construct()

__construct(\Pop\Db\Adapter\AbstractAdapter  $db) 

Constructor

Instantiate the SQL object

Parameters

isMysql()

isMysql() : boolean

Determine if the DB type is MySQL

Returns

isPgsql()

isPgsql() : boolean

Determine if the DB type is PostgreSQL

Returns

isSqlsrv()

isSqlsrv() : boolean

Determine if the DB type is SQL Server

Returns

isSqlite()

isSqlite() : boolean

Determine if the DB type is SQLite

Returns

db()

db() : \Pop\Db\Adapter\AbstractAdapter

Get the current database adapter object (alias method)

Returns

getDb()

getDb() : \Pop\Db\Adapter\AbstractAdapter

Get the current database adapter object

Returns

setIdQuoteType()

setIdQuoteType(string  $type = self::NO_QUOTE) : \Pop\Db\Sql\AbstractSql

Set the quote ID type

Parameters

Returns

setPlaceholder()

setPlaceholder(string  $placeholder) : \Pop\Db\Sql\AbstractSql

Set the placeholder

Parameters

Returns

getDbType()

getDbType() : integer

Get the current database type

Returns

getIdQuoteType()

getIdQuoteType() : integer

Get the quote ID type

Returns

getPlaceholder()

getPlaceholder() : string

Get the SQL placeholder

Returns

quoteId()

quoteId(string  $identifier) : string

Quote the identifier

Parameters

Returns

quote()

quote(string  $value) : string

Quote the value (if it is not a numeric value)

Parameters

Returns

distinct()

distinct(boolean  $distinct = true) : \Pop\Db\Sql\Select

Select distinct

Parameters

Returns

from()

from(mixed  $table) : \Pop\Db\Sql\Select

Set from table

Parameters

Returns

asAlias()

asAlias(mixed  $table) : \Pop\Db\Sql\Select

Set table AS alias name

Parameters

Returns

join()

join(mixed  $foreignTable, array  $columns, string  $join = 'JOIN') : \Pop\Db\Sql\Select

Add a JOIN clause

Parameters

Returns

leftJoin()

leftJoin(mixed  $foreignTable, array  $columns) : \Pop\Db\Sql\Select

Add a LEFT JOIN clause

Parameters

Returns

rightJoin()

rightJoin(mixed  $foreignTable, array  $columns) : \Pop\Db\Sql\Select

Add a RIGHT JOIN clause

Parameters

Returns

fullJoin()

fullJoin(mixed  $foreignTable, array  $columns) : \Pop\Db\Sql\Select

Add a FULL JOIN clause

Parameters

Returns

outerJoin()

outerJoin(mixed  $foreignTable, array  $columns) : \Pop\Db\Sql\Select

Add a OUTER JOIN clause

Parameters

Returns

leftOuterJoin()

leftOuterJoin(mixed  $foreignTable, array  $columns) : \Pop\Db\Sql\Select

Add a LEFT OUTER JOIN clause

Parameters

Returns

rightOuterJoin()

rightOuterJoin(mixed  $foreignTable, array  $columns) : \Pop\Db\Sql\Select

Add a RIGHT OUTER JOIN clause

Parameters

Returns

fullOuterJoin()

fullOuterJoin(mixed  $foreignTable, array  $columns) : \Pop\Db\Sql\Select

Add a FULL OUTER JOIN clause

Parameters

Returns

innerJoin()

innerJoin(mixed  $foreignTable, array  $columns) : \Pop\Db\Sql\Select

Add a INNER JOIN clause

Parameters

Returns

leftInnerJoin()

leftInnerJoin(mixed  $foreignTable, array  $columns) : \Pop\Db\Sql\Select

Add a LEFT INNER JOIN clause

Parameters

Returns

rightInnerJoin()

rightInnerJoin(mixed  $foreignTable, array  $columns) : \Pop\Db\Sql\Select

Add a RIGHT INNER JOIN clause

Parameters

Returns

fullInnerJoin()

fullInnerJoin(mixed  $foreignTable, array  $columns) : \Pop\Db\Sql\Select

Add a FULL INNER JOIN clause

Parameters

Returns

where()

where(mixed  $where = null) : \Pop\Db\Sql\Select

Access the WHERE clause

Parameters

Returns

andWhere()

andWhere(mixed  $where = null) : \Pop\Db\Sql\Select

Access the WHERE clause with AND

Parameters

Returns

orWhere()

orWhere(mixed  $where = null) : \Pop\Db\Sql\Select

Access the WHERE clause with OR

Parameters

Returns

having()

having(mixed  $having = null) : \Pop\Db\Sql\Select

Access the HAVING clause

Parameters

Returns

andHaving()

andHaving(mixed  $having = null) : \Pop\Db\Sql\Select

Access the HAVING clause with AND

Parameters

Returns

orHaving()

orHaving(mixed  $having = null) : \Pop\Db\Sql\Select

Access the HAVING clause with OR

Parameters

Returns

groupBy()

groupBy(mixed  $by) : \Pop\Db\Sql\Select

Set the GROUP BY value

Parameters

Returns

orderBy()

orderBy(mixed  $by, string  $order = 'ASC') : \Pop\Db\Sql\Select

Set the ORDER BY value

Parameters

Returns

limit()

limit(mixed  $limit) : \Pop\Db\Sql\Select

Set the LIMIT value

Parameters

Returns

offset()

offset(integer  $offset) : \Pop\Db\Sql\Select

Set the OFFSET value

Parameters

Returns

__toString()

__toString() : string

Render the SELECT statement

Returns

__get()

__get(string  $name) : mixed

Magic method to access $where and $having properties

Parameters

Throws

\Pop\Db\Sql\Exception

Returns

getLimitAndOffset()

getLimitAndOffset() : array

Method to get the limit and offset

Returns

buildSqlSrvLimitAndOffset()

buildSqlSrvLimitAndOffset() : string

Method to build SQL Server limit and offset sub-clause

Returns