Zend Framework
Back to top  

 Methods

Constructor

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

Parameters

$table

nullstring\Zend\Db\Sql\TableIdentifier

Property overloading

__get(string $name) : \Zend\Db\Sql\Where | null

Overloads "where" only.

Parameters

$name

string

Returns

\Zend\Db\Sql\Wherenull

Create from statement

from(string | \Zend\Db\Sql\TableIdentifier $table) : \Zend\Db\Sql\Delete

Parameters

$table

string\Zend\Db\Sql\TableIdentifier

Returns

\Zend\Db\Sql\Delete

getRawState() 

getRawState(null $key) : mixed

Parameters

$key

null

Returns

mixed

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()

Parameters

$adapterPlatform

null\Zend\Db\Adapter\Platform\PlatformInterface

Returns

string

prepareStatement() 

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

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

Parameters

$adapter

\Zend\Db\Adapter\AdapterInterface

$statementContainer

\Zend\Db\Adapter\StatementContainerInterface

Returns

\Zend\Db\Adapter\StatementContainerInterface

Create where clause

where(\Zend\Db\Sql\Where | \Closure | string | array $predicate, string $combination) : \Zend\Db\Sql\Delete

Parameters

$predicate

\Zend\Db\Sql\Where\Closurestringarray

$combination

string

One of the OP_* constants from Predicate\PredicateSet

Returns

\Zend\Db\Sql\Delete

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()

Parameters

$platform

\Zend\Db\Adapter\Platform\PlatformInterface

$driver

null\Zend\Db\Adapter\Driver\DriverInterface

$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()

Parameters

$specifications

stringarray

$parameters

stringarray

Exceptions

\Zend\Db\Sql\Exception\RuntimeException

Returns

string

Copy variables from the subject into the local properties

localizeVariables() 
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::localizeVariables()
inherited_from \Zend\Db\Sql\AbstractPreparableSql::localizeVariables()

processDelete() 

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

Parameters

$platform

\Zend\Db\Adapter\Platform\PlatformInterface

$driver

\Zend\Db\Adapter\Driver\DriverInterfacenull

$parameterContainer

\Zend\Db\Adapter\ParameterContainernull

Returns

string

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()

Parameters

$expression

\Zend\Db\Sql\ExpressionInterface

$platform

\Zend\Db\Adapter\Platform\PlatformInterface

$driver

null\Zend\Db\Adapter\Driver\DriverInterface

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

$namedParameterPrefix

nullstring

Exceptions

\Zend\Db\Sql\Exception\RuntimeException

Returns

string

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()

Parameters

$subselect

\Zend\Db\Sql\Select

$platform

\Zend\Db\Adapter\Platform\PlatformInterface

$driver

null\Zend\Db\Adapter\Driver\DriverInterface

$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) : null | string

Parameters

$platform

\Zend\Db\Adapter\Platform\PlatformInterface

$driver

\Zend\Db\Adapter\Driver\DriverInterfacenull

$parameterContainer

\Zend\Db\Adapter\ParameterContainernull

Returns

nullstring

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()

Parameters

$column

nullarray\Zend\Db\Sql\ExpressionInterface\Zend\Db\Sql\Select

$platform

\Zend\Db\Adapter\Platform\PlatformInterface

$driver

null\Zend\Db\Adapter\Driver\DriverInterface

$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\AbstractSql::resolveTable()
inherited_from \Zend\Db\Sql\AbstractPreparableSql::resolveTable()

Parameters

$table

string\Zend\Db\Sql\TableIdentifier\Zend\Db\Sql\Select

$platform

\Zend\Db\Adapter\Platform\PlatformInterface

$driver

\Zend\Db\Adapter\Driver\DriverInterface

$parameterContainer

\Zend\Db\Adapter\ParameterContainer

Returns

string

 Properties

 

$where

$where : \Zend\Db\Sql\Where

magic
property
 

$emptyWhereProtection

$emptyWhereProtection : bool

 

$instanceParameterIndex

$instanceParameterIndex : array
Inherited

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

$processInfo

$processInfo : string
Inherited

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

$set

$set : array

 

Specifications for Sql String generation

$specifications : string[] | array[]

 

$table

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

 

$where

$where : null | string | \Zend\Db\Sql\Where

 Constants

 

SPECIFICATION_DELETE

SPECIFICATION_DELETE 

 

SPECIFICATION_WHERE

SPECIFICATION_WHERE