Zend Framework
Back to top  

 Methods

Constructor

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

Parameters

$table

nullstring\Zend\Db\Sql\TableIdentifier

Overloading: variable retrieval

__get(string $name) : mixed

Retrieves value by column name

Parameters

$name

string

Exceptions

\Zend\Db\Sql\Exception\InvalidArgumentException

Returns

mixed

Overloading: variable isset

__isset(string $name) : bool

Proxies to columns; does a column of that name exist?

Parameters

$name

string

Returns

bool

Overloading: variable setting

__set(string $name, mixed $value) : \Zend\Db\Sql\Insert

Proxies to values, using VALUES_MERGE strategy

Parameters

$name

string

$value

mixed

Returns

\Zend\Db\Sql\Insert

Overloading: variable unset

__unset(string $name) : void

Proxies to values and columns

Parameters

$name

string

Exceptions

\Zend\Db\Sql\Exception\InvalidArgumentException

Specify columns

columns(array $columns) : \Zend\Db\Sql\Insert

Parameters

$columns

array

Returns

\Zend\Db\Sql\Insert

getRawState() 

getRawState($key) 

Parameters

$key

Get SQL string for this statement

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

Parameters

$adapterPlatform

null\Zend\Db\Adapter\Platform\PlatformInterface

Defaults to Sql92 if none provided

Returns

string

Crete INTO clause

into(string | \Zend\Db\Sql\TableIdentifier $table) : \Zend\Db\Sql\Insert

Parameters

$table

string\Zend\Db\Sql\TableIdentifier

Returns

\Zend\Db\Sql\Insert

Prepare statement

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

Parameters

$adapter

\Zend\Db\Adapter\AdapterInterface

$statementContainer

\Zend\Db\Adapter\StatementContainerInterface

Specify values to insert

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

Parameters

$values

array

$flag

string

one of VALUES_MERGE or VALUES_SET; defaults to VALUES_SET

Exceptions

\Zend\Db\Sql\Exception\InvalidArgumentException

Returns

\Zend\Db\Sql\Insert

createSqlFromSpecificationAndParameters() 

createSqlFromSpecificationAndParameters($specifications, $parameters) : string
Inherited

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

Parameters

$specifications

$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\Driver\DriverInterface $driver, $namedParameterPrefix) 
Inherited

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

Parameters

$expression

$platform

$driver

$namedParameterPrefix

processSubSelect() 

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

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

Parameters

$subselect

$platform

$driver

$parameterContainer

 Properties

 

$columns

$columns 

 

$instanceParameterIndex

$instanceParameterIndex : array
Inherited

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

$processInfo

$processInfo : string
Inherited

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

<p>Specification array</p>

$specifications : array

 

$table

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

 

$values

$values : array

 Constants

 

SPECIFICATION_INSERT

SPECIFICATION_INSERT 

 

VALUES_MERGE

VALUES_MERGE 

 

VALUES_SET

VALUES_SET