Overview

Packages

  • Auth
  • Config
  • Controller
  • Date
  • Db
  • Feed
    • Abstract
    • Writers
  • File
    • Decorator
  • Form
    • Element
  • Image
  • Log
    • Writer
  • Net
    • Exception
    • REST
  • None
  • PHP
  • PHPMailer
  • Session
  • Util
  • Validate
    • Validator
  • Zend
    • Db
      • Adapter
      • Expr
      • Profiler
      • Select
      • Statement
      • Table
    • Loader
      • Autoloader
      • PluginLoader
    • Registry

Classes

  • Zend_Db_Table
  • Zend_Db_Table_Abstract
  • Zend_Db_Table_Definition
  • Zend_Db_Table_Row
  • Zend_Db_Table_Row_Abstract
  • Zend_Db_Table_Rowset
  • Zend_Db_Table_Rowset_Abstract
  • Zend_Db_Table_Select

Exceptions

  • Zend_Db_Table_Exception
  • Zend_Db_Table_Row_Exception
  • Zend_Db_Table_Rowset_Exception
  • Zend_Db_Table_Select_Exception
  • Overview
  • Package
  • Class
  • Tree

Class Zend_Db_Table_Select

Class for SQL SELECT query manipulation for the Zend_Db_Table component.

Zend_Db_Select
Extended by Zend_Db_Table_Select
Package: Zend\Db\Table
Category: Zend
Copyright: Copyright (c) 2005-2010 Zend Technologies USA Inc. (http://www.zend.com)
License: New BSD License
Located at Zend/Db/Table/Select.php
Methods summary
public
# __construct( Zend_Db_Table_Abstract $table )

Class constructor

Class constructor

Parameters

$table
Zend_Db_Table_Abstract
$adapter
public Zend_Db_Table_Abstract
# getTable( )

Return the table that created this select object

Return the table that created this select object

Returns

Zend_Db_Table_Abstract
public Zend_Db_Select
# setTable( Zend_Db_Table_Abstract $table )

Sets the primary table name and retrieves the table schema.

Sets the primary table name and retrieves the table schema.

Parameters

$table
Zend_Db_Table_Abstract
$adapter

Returns

Zend_Db_Select
This Zend_Db_Select object.
public Zend_Db_Select
# setIntegrityCheck( Zend_Db_Table_Abstract $flag = true )

Sets the integrity check flag.

Sets the integrity check flag.

Setting this flag to false skips the checks for table joins, allowing 'hybrid' table rows to be created.

Parameters

$flag
Zend_Db_Table_Abstract
$adapter

Returns

Zend_Db_Select
This Zend_Db_Select object.
public boolean
# isReadOnly( )

Tests query to determine if expressions or aliases columns exist.

Tests query to determine if expressions or aliases columns exist.

Returns

boolean
public Zend_Db_Table_Select
# from( array|string|Zend_Db_Expr|Zend_Db_Table_Abstract $name, array|string|Zend_Db_Expr $cols = Zend_Db_Select::SQL_WILDCARD, string $schema = null )

Adds a FROM table and optional columns to the query.

Adds a FROM table and optional columns to the query.

The table name can be expressed

Parameters

$name
array|string|Zend_Db_Expr|Zend_Db_Table_Abstract
The table name or an associative array relating table name to correlation name.
$cols
array|string|Zend_Db_Expr
The columns to select from this table.
$schema
string
The schema name to specify, if any.

Returns

Zend_Db_Table_Select
This Zend_Db_Table_Select object.
public string|null
# assemble( )

Performs a validation on the select query before passing back to the parent class. Ensures that only columns from the primary Zend_Db_Table are returned in the result.

Performs a validation on the select query before passing back to the parent class. Ensures that only columns from the primary Zend_Db_Table are returned in the result.

Returns

string|null
This object as a SELECT string (or null if a string cannot be produced)
Methods inherited from Zend_Db_Select
__call(), __toString(), _getDummyTable(), _getQuotedSchema(), _getQuotedTable(), _join(), _joinUsing(), _renderColumns(), _renderDistinct(), _renderForupdate(), _renderFrom(), _renderGroup(), _renderHaving(), _renderLimitoffset(), _renderOrder(), _renderUnion(), _renderWhere(), _tableCols(), _where(), bind(), columns(), distinct(), forUpdate(), getAdapter(), getBind(), getPart(), group(), having(), join(), joinCross(), joinFull(), joinInner(), joinLeft(), joinNatural(), joinRight(), limit(), limitPage(), orHaving(), orWhere(), order(), query(), reset(), union(), where()
Constants inherited from Zend_Db_Select
COLUMNS, CROSS_JOIN, DISTINCT, FOR_UPDATE, FROM, FULL_JOIN, GROUP, HAVING, INNER_JOIN, LEFT_JOIN, LIMIT_COUNT, LIMIT_OFFSET, NATURAL_JOIN, ORDER, RIGHT_JOIN, SQL_AND, SQL_AS, SQL_ASC, SQL_DESC, SQL_DISTINCT, SQL_FOR_UPDATE, SQL_FROM, SQL_GROUP_BY, SQL_HAVING, SQL_ON, SQL_OR, SQL_ORDER_BY, SQL_SELECT, SQL_UNION, SQL_UNION_ALL, SQL_WHERE, SQL_WILDCARD, UNION, WHERE
Properties summary
protected array $_info
#

Table schema for parent Zend_Db_Table.

Table schema for parent Zend_Db_Table.

protected array $_integrityCheck true
#

Table integrity override.

Table integrity override.

protected Zend_Db_Table_Abstract $_table
#

Table instance that created this select object

Table instance that created this select object

Properties inherited from Zend_Db_Select
$_adapter, $_bind, $_joinTypes, $_parts, $_partsInit, $_tableCols, $_unionTypes
Pry Framework API documentation generated by ApiGen 2.6.1