category Zend
package Zend_Db
subpackage Sql

 Methods

__clone

__clone() : void

Resets the where object each time the Update is cloned.

Constructor

__construct(null | string $table) 

Parameters

$table

nullstring

Variable overloading

__get(string $name) : mixed

Proxies to "where" only

Parameters

$name

string

Returns

mixed

getRawState()

getRawState($key) 

Parameters

$key

Get SQL string for statement

getSqlString(\Zend\Db\Adapter\Platform\PlatformInterface $adapterPlatform) : string

Parameters

$adapterPlatform

null\Zend\Db\Adapter\Platform\PlatformInterface

If null, defaults to Sql92

Returns

string

Prepare statement

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

Set key/value pairs to update

set(array $values, string $flag) : \Zend\Db\Sql\Update

Parameters

$values

array

Associative array of key values

$flag

string

One of the VALUES_* constants

Exceptions

\Zend\Db\Sql\Exception\InvalidArgumentException

Returns

Specify table for statement

table(string $table) : \Zend\Db\Sql\Update

Parameters

$table

string

Returns

Create where clause

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

Parameters

$predicate

\Zend\Db\Sql\Where\Closurestringarray

$combination

string

One of the OP_* constants from Predicate\PredicateSet

Exceptions

\Zend\Db\Sql\Exception\InvalidArgumentException

Returns

createSqlFromSpecificationAndParameters()

createSqlFromSpecificationAndParameters($specification, $parameters) : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::createSqlFromSpecificationAndParameters()

Parameters

$specification

$parameters

Exceptions

\Zend\Db\Sql\Exception\RuntimeException

Returns

string

processExpression()

processExpression(\Zend\Db\Sql\ExpressionInterface $expression, \Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Adapter $adapter, $namedParameterPrefix) 
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::processExpression()

Parameters

$expression

$platform

$adapter

$namedParameterPrefix

processSubSelect()

processSubSelect(\Zend\Db\Sql\Select $subselect, \Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Adapter $adapter, \Zend\Db\Adapter\ParameterContainer $parameterContainer) 
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::processSubSelect()

Parameters

$subselect

$platform

$adapter

$parameterContainer

 Properties

 

$where

$where : \Zend\Db\Sql\Where

magic
property
 

$emptyWhereProtection

$emptyWhereProtection : bool

 

$processInfo

$processInfo : string
Inherited

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

$set

$set : array

 

$specifications

$specifications : array

 

$table

$table : string

 

$where

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

 Constants

 

SPECIFICATION_UPDATE

SPECIFICATION_UPDATE 

 

SPECIFICATION_WHERE

SPECIFICATION_WHERE 

 

VALUES_MERGE

VALUES_MERGE 

 

VALUES_SET

VALUES_SET