Db/Adapter/Pdo/Sqlite.php
Zend Framework
LICENSE
This source file is subject to the new BSD license that is bundled with this package in the file LICENSE.txt. It is also available through the world-wide-web at this URL: http://framework.zend.com/license/new-bsd If you did not receive a copy of the license and are unable to obtain it through the world-wide-web, please send an email to [email protected] so we can send you a copy immediately.
- Category
- Zend
- Copyright
- Copyright (c) 2005-2012 Zend Technologies USA Inc. (http://www.zend.com)
- License
- New BSD License
- Package
- Zend_Db
- Subpackage
- Adapter
- Version
- $Id: Sqlite.php 24593 2012-01-05 20:35:02Z matthew $
\Zend_Db_Adapter_Pdo_Sqlite
Class for connecting to SQLite2 and SQLite3 databases and performing common operations.
- Parent(s)
- \Zend_Db_Adapter_Pdo_Abstract < \Zend_Db_Adapter_Abstract
- Category
- Zend
- Copyright
- Copyright (c) 2005-2012 Zend Technologies USA Inc. (http://www.zend.com)
- License
- New BSD License
Properties


bool $_allowSerialization = true
Weither or not that object can get serialized
Inherited from: \Zend_Db_Adapter_Abstract::$$_allowSerialization\Zend_Db_Adapter_Pdo_Abstract::$$_allowSerializationtrue
Details- Type
- bool
- Inherited_from
- \Zend_Db_Adapter_Abstract::$$_allowSerialization
- Inherited_from
- \Zend_Db_Adapter_Pdo_Abstract::$$_allowSerialization


bool $_autoQuoteIdentifiers = true
Specifies whether the adapter automatically quotes identifiers.
Inherited from: \Zend_Db_Adapter_Abstract::$$_autoQuoteIdentifiers\Zend_Db_Adapter_Pdo_Abstract::$$_autoQuoteIdentifiersIf true, most SQL generated by Zend_Db classes applies identifier quoting automatically. If false, developer must quote identifiers themselves by calling quoteIdentifier().
true
Details- Type
- bool
- Inherited_from
- \Zend_Db_Adapter_Abstract::$$_autoQuoteIdentifiers
- Inherited_from
- \Zend_Db_Adapter_Pdo_Abstract::$$_autoQuoteIdentifiers


bool $_autoReconnectOnUnserialize = false
Weither or not the database should be reconnected to that adapter when waking up
Inherited from: \Zend_Db_Adapter_Abstract::$$_autoReconnectOnUnserialize\Zend_Db_Adapter_Pdo_Abstract::$$_autoReconnectOnUnserializefalse
Details- Type
- bool
- Inherited_from
- \Zend_Db_Adapter_Abstract::$$_autoReconnectOnUnserialize
- Inherited_from
- \Zend_Db_Adapter_Pdo_Abstract::$$_autoReconnectOnUnserialize


integer $_caseFolding = \Zend_Db::CASE_NATURAL
Specifies the case of column names retrieved in queries Options Zend_Db::CASE_NATURAL (default) Zend_Db::CASE_LOWER Zend_Db::CASE_UPPER
Inherited from: \Zend_Db_Adapter_Abstract::$$_caseFolding\Zend_Db_Adapter_Pdo_Abstract::$$_caseFolding\Zend_Db::CASE_NATURAL
Details- Type
- integer
- Inherited_from
- \Zend_Db_Adapter_Abstract::$$_caseFolding
- Inherited_from
- \Zend_Db_Adapter_Pdo_Abstract::$$_caseFolding


array $_config = array()
User-provided configuration
Inherited from: \Zend_Db_Adapter_Abstract::$$_config\Zend_Db_Adapter_Pdo_Abstract::$$_configarray()
Details- Type
- array
- Inherited_from
- \Zend_Db_Adapter_Abstract::$$_config
- Inherited_from
- \Zend_Db_Adapter_Pdo_Abstract::$$_config


object|resource|null $_connection = null
Database connection
Inherited from: \Zend_Db_Adapter_Abstract::$$_connection\Zend_Db_Adapter_Pdo_Abstract::$$_connectionnull
Details- Type
- object | resource | null
- Inherited_from
- \Zend_Db_Adapter_Abstract::$$_connection
- Inherited_from
- \Zend_Db_Adapter_Pdo_Abstract::$$_connection


string $_defaultProfilerClass = 'Zend_Db_Profiler'
Default class name for the profiler object.
Inherited from: \Zend_Db_Adapter_Abstract::$$_defaultProfilerClass\Zend_Db_Adapter_Pdo_Abstract::$$_defaultProfilerClass'Zend_Db_Profiler'
Details- Type
- string
- Inherited_from
- \Zend_Db_Adapter_Abstract::$$_defaultProfilerClass
- Inherited_from
- \Zend_Db_Adapter_Pdo_Abstract::$$_defaultProfilerClass


string $_defaultStmtClass = 'Zend_Db_Statement_Pdo'
Default class name for a DB statement.
Inherited from: \Zend_Db_Adapter_Pdo_Abstract::$$_defaultStmtClass'Zend_Db_Statement_Pdo'
Details- Type
- string
- Inherited_from
- \Zend_Db_Adapter_Pdo_Abstract::$$_defaultStmtClass


integer $_fetchMode = \Zend_Db::FETCH_ASSOC
Fetch mode
Inherited from: \Zend_Db_Adapter_Abstract::$$_fetchMode\Zend_Db_Adapter_Pdo_Abstract::$$_fetchMode\Zend_Db::FETCH_ASSOC
Details- Type
- integer
- Inherited_from
- \Zend_Db_Adapter_Abstract::$$_fetchMode
- Inherited_from
- \Zend_Db_Adapter_Pdo_Abstract::$$_fetchMode


array $_numericDataTypes = array(\Zend_Db::INT_TYPE => \Zend_Db::INT_TYPE, \Zend_Db::BIGINT_TYPE => \Zend_Db::BIGINT_TYPE, \Zend_Db::FLOAT_TYPE => \Zend_Db::FLOAT_TYPE, 'INTEGER' => \Zend_Db::BIGINT_TYPE, 'REAL' => \Zend_Db::FLOAT_TYPE)
Keys are UPPERCASE SQL datatypes or the constants Zend_Db::INT_TYPE, Zend_Db::BIGINT_TYPE, or Zend_Db::FLOAT_TYPE.
<p>Associative array of datatypes to values 0, 1, or 2.</p>Values are: 0 = 32-bit integer 1 = 64-bit integer 2 = float or decimal
array(\Zend_Db::INT_TYPE => \Zend_Db::INT_TYPE, \Zend_Db::BIGINT_TYPE => \Zend_Db::BIGINT_TYPE, \Zend_Db::FLOAT_TYPE => \Zend_Db::FLOAT_TYPE, 'INTEGER' => \Zend_Db::BIGINT_TYPE, 'REAL' => \Zend_Db::FLOAT_TYPE)
Details- Type
- array


\Zend_Db_Profiler $_profiler =
Query profiler object, of type Zend_Db_Profiler or a subclass of that.
Inherited from: \Zend_Db_Adapter_Abstract::$$_profiler\Zend_Db_Adapter_Pdo_Abstract::$$_profiler- Type
- \Zend_Db_Profiler
- Inherited_from
- \Zend_Db_Adapter_Abstract::$$_profiler
- Inherited_from
- \Zend_Db_Adapter_Pdo_Abstract::$$_profiler
Methods


__construct(array $config = array()) : void
Constructor.
$config is an array of key/value pairs containing configuration options. Note that the SQLite options are different than most of the other PDO adapters in that no username or password are needed. Also, an extra config key "sqlite2" specifies compatibility mode.
dbname => (string) The name of the database to user (required, use :memory: for memory-based database)
sqlite2 => (boolean) PDO_SQLITE defaults to SQLite 3. For compatibility with an older SQLite 2 database, set this to TRUE.
Name | Type | Description |
---|---|---|
$config | array | An array of configuration keys. |
Exception | Description |
---|---|
\Zend_Db_Adapter_Exception |


__sleep() : array
called when object is getting serialized This disconnects the DB object that cant be serialized
Inherited from: \Zend_Db_Adapter_Abstract::__sleep()\Zend_Db_Adapter_Pdo_Abstract::__sleep()Type | Description |
---|---|
array |
Exception | Description |
---|---|
\Zend_Db_Adapter_Exception |


__wakeup() : void
called when object is getting unserialized
Inherited from: \Zend_Db_Adapter_Abstract::__wakeup()\Zend_Db_Adapter_Pdo_Abstract::__wakeup()

_checkRequiredOptions(array $config) : void
Check for config options that are mandatory.
Throw exceptions if any are missing.
Name | Type | Description |
---|---|---|
$config | array |
Exception | Description |
---|---|
\Zend_Db_Adapter_Exception |


_connect() : void
Special configuration for SQLite behavior: make sure that result sets contain keys like 'column' instead of 'table.column'.
Exception | Description |
---|---|
\Zend_Db_Adapter_Exception |


_quote(string $value) : string
Name | Type | Description |
---|---|---|
$value | string | Raw string |
Type | Description |
---|---|
string | Quoted string |


_quoteIdentifier(string $value, boolean $auto = false) : string
Quote an identifier.
Inherited from: \Zend_Db_Adapter_Abstract::_quoteIdentifier()\Zend_Db_Adapter_Pdo_Abstract::_quoteIdentifier()Name | Type | Description |
---|---|---|
$value | string | The identifier or expression. |
$auto | boolean | If true, heed the AUTO_QUOTE_IDENTIFIERS config option. |
Type | Description |
---|---|
string | The quoted identifier and alias. |


_quoteIdentifierAs(string | array | \Zend_Db_Expr $ident, string $alias = null, boolean $auto = false, string $as = ' AS ') : string
Quote an identifier and an optional alias.
Inherited from: \Zend_Db_Adapter_Abstract::_quoteIdentifierAs()\Zend_Db_Adapter_Pdo_Abstract::_quoteIdentifierAs()Name | Type | Description |
---|---|---|
$ident | string | array | \Zend_Db_Expr | The identifier or expression. |
$alias | string | An optional alias. |
$auto | boolean | If true, heed the AUTO_QUOTE_IDENTIFIERS config option. |
$as | string | The string to add between the identifier/expression and the alias. |
Type | Description |
---|---|
string | The quoted identifier and alias. |


_whereExpr(mixed $where) : string
Convert an array, string, or Zend_Db_Expr object into a string to put in a WHERE clause.
Inherited from: \Zend_Db_Adapter_Abstract::_whereExpr()\Zend_Db_Adapter_Pdo_Abstract::_whereExpr()Name | Type | Description |
---|---|---|
$where | mixed |
Type | Description |
---|---|
string |


beginTransaction() : \Zend_Db_Adapter_Abstract
Leave autocommit mode and begin a transaction.
Inherited from: \Zend_Db_Adapter_Abstract::beginTransaction()\Zend_Db_Adapter_Pdo_Abstract::beginTransaction()Type | Description |
---|---|
\Zend_Db_Adapter_Abstract |


closeConnection() : void
Force the connection to close.
Inherited from: \Zend_Db_Adapter_Pdo_Abstract::closeConnection()

commit() : \Zend_Db_Adapter_Abstract
Commit a transaction and return to autocommit mode.
Inherited from: \Zend_Db_Adapter_Abstract::commit()\Zend_Db_Adapter_Pdo_Abstract::commit()Type | Description |
---|---|
\Zend_Db_Adapter_Abstract |


delete(mixed $table, mixed $where = '') : int
Deletes table rows based on a WHERE clause.
Inherited from: \Zend_Db_Adapter_Abstract::delete()\Zend_Db_Adapter_Pdo_Abstract::delete()Name | Type | Description |
---|---|---|
$table | mixed | The table to update. |
$where | mixed | DELETE WHERE clause(s). |
Type | Description |
---|---|
int | The number of affected rows. |


describeTable(string $tableName, string $schemaName = null) : array
Returns the column descriptions for a table.
The return value is an associative array keyed by the column name, as returned by the RDBMS.
The value of each array element is an associative array with the following keys:
SCHEMA_NAME => string; name of database or schema TABLE_NAME => string; COLUMN_NAME => string; column name COLUMN_POSITION => number; ordinal position of column in table DATA_TYPE => string; SQL datatype name of column DEFAULT => string; default expression of column, null if none NULLABLE => boolean; true if column can have nulls LENGTH => number; length of CHAR/VARCHAR SCALE => number; scale of NUMERIC/DECIMAL PRECISION => number; precision of NUMERIC/DECIMAL UNSIGNED => boolean; unsigned property of an integer type PRIMARY => boolean; true if column is part of the primary key PRIMARY_POSITION => integer; position of column in primary key IDENTITY => integer; true if column is auto-generated with unique values
Name | Type | Description |
---|---|---|
$tableName | string | |
$schemaName | string | OPTIONAL |
Type | Description |
---|---|
array |


exec(mixed $sql) : integer
Executes an SQL statement and return the number of affected rows
Inherited from: \Zend_Db_Adapter_Pdo_Abstract::exec()Name | Type | Description |
---|---|---|
$sql | mixed | The SQL statement with placeholders. May be a string or Zend_Db_Select. |
Type | Description |
---|---|
integer | Number of rows that were modified or deleted by the SQL statement |


fetchAll(string | \Zend_Db_Select $sql, mixed $bind = array(), mixed $fetchMode = null) : array
Fetches all SQL result rows as a sequential array.
Inherited from: \Zend_Db_Adapter_Abstract::fetchAll()\Zend_Db_Adapter_Pdo_Abstract::fetchAll()Uses the current fetchMode for the adapter.
Name | Type | Description |
---|---|---|
$sql | string | \Zend_Db_Select | An SQL SELECT statement. |
$bind | mixed | Data to bind into SELECT placeholders. |
$fetchMode | mixed | Override current fetch mode. |
Type | Description |
---|---|
array |


fetchAssoc(string | \Zend_Db_Select $sql, mixed $bind = array()) : array
Fetches all SQL result rows as an associative array.
Inherited from: \Zend_Db_Adapter_Abstract::fetchAssoc()\Zend_Db_Adapter_Pdo_Abstract::fetchAssoc()The first column is the key, the entire row array is the value. You should construct the query to be sure that the first column contains unique values, or else rows with duplicate values in the first column will overwrite previous data.
Name | Type | Description |
---|---|---|
$sql | string | \Zend_Db_Select | An SQL SELECT statement. |
$bind | mixed | Data to bind into SELECT placeholders. |
Type | Description |
---|---|
array |


fetchCol(string | \Zend_Db_Select $sql, mixed $bind = array()) : array
Fetches the first column of all SQL result rows as an array.
Inherited from: \Zend_Db_Adapter_Abstract::fetchCol()\Zend_Db_Adapter_Pdo_Abstract::fetchCol()Name | Type | Description |
---|---|---|
$sql | string | \Zend_Db_Select | An SQL SELECT statement. |
$bind | mixed | Data to bind into SELECT placeholders. |
Type | Description |
---|---|
array |


fetchOne(string | \Zend_Db_Select $sql, mixed $bind = array()) : string
Fetches the first column of the first row of the SQL result.
Inherited from: \Zend_Db_Adapter_Abstract::fetchOne()\Zend_Db_Adapter_Pdo_Abstract::fetchOne()Name | Type | Description |
---|---|---|
$sql | string | \Zend_Db_Select | An SQL SELECT statement. |
$bind | mixed | Data to bind into SELECT placeholders. |
Type | Description |
---|---|
string |


fetchPairs(string | \Zend_Db_Select $sql, mixed $bind = array()) : array
Fetches all SQL result rows as an array of key-value pairs.
Inherited from: \Zend_Db_Adapter_Abstract::fetchPairs()\Zend_Db_Adapter_Pdo_Abstract::fetchPairs()The first column is the key, the second column is the value.
Name | Type | Description |
---|---|---|
$sql | string | \Zend_Db_Select | An SQL SELECT statement. |
$bind | mixed | Data to bind into SELECT placeholders. |
Type | Description |
---|---|
array |


fetchRow(string | \Zend_Db_Select $sql, mixed $bind = array(), mixed $fetchMode = null) : mixed
Fetches the first row of the SQL result.
Inherited from: \Zend_Db_Adapter_Abstract::fetchRow()\Zend_Db_Adapter_Pdo_Abstract::fetchRow()Uses the current fetchMode for the adapter.
Name | Type | Description |
---|---|---|
$sql | string | \Zend_Db_Select | An SQL SELECT statement. |
$bind | mixed | Data to bind into SELECT placeholders. |
$fetchMode | mixed | Override current fetch mode. |
Type | Description |
---|---|
mixed | Array, object, or scalar depending on fetch mode. |


foldCase(string $key) : string
Helper method to change the case of the strings used when returning result sets in FETCH_ASSOC and FETCH_BOTH modes.
Inherited from: \Zend_Db_Adapter_Abstract::foldCase()\Zend_Db_Adapter_Pdo_Abstract::foldCase()This is not intended to be used by application code, but the method must be public so the Statement class can invoke it.
Name | Type | Description |
---|---|---|
$key | string |
Type | Description |
---|---|
string |


getConfig() : array
Returns the configuration variables in this adapter.
Inherited from: \Zend_Db_Adapter_Abstract::getConfig()\Zend_Db_Adapter_Pdo_Abstract::getConfig()Type | Description |
---|---|
array |


getConnection() : object | resource | null
Returns the underlying database connection object or resource.
Inherited from: \Zend_Db_Adapter_Abstract::getConnection()\Zend_Db_Adapter_Pdo_Abstract::getConnection()If not presently connected, this initiates the connection.
Type | Description |
---|---|
object | resource | null |


getFetchMode() : int
Get the fetch mode.
Inherited from: \Zend_Db_Adapter_Abstract::getFetchMode()\Zend_Db_Adapter_Pdo_Abstract::getFetchMode()Type | Description |
---|---|
int |


getProfiler() : \Zend_Db_Profiler
Returns the profiler for this adapter.
Inherited from: \Zend_Db_Adapter_Abstract::getProfiler()\Zend_Db_Adapter_Pdo_Abstract::getProfiler()Type | Description |
---|---|
\Zend_Db_Profiler |


getQuoteIdentifierSymbol() : string
Returns the symbol the adapter uses for delimited identifiers.
Inherited from: \Zend_Db_Adapter_Abstract::getQuoteIdentifierSymbol()\Zend_Db_Adapter_Pdo_Abstract::getQuoteIdentifierSymbol()Type | Description |
---|---|
string |


getServerVersion() : string
Retrieve server version in PHP style
Inherited from: \Zend_Db_Adapter_Pdo_Abstract::getServerVersion()Type | Description |
---|---|
string |


getStatementClass() : string
Get the default statement class.
Inherited from: \Zend_Db_Adapter_Abstract::getStatementClass()\Zend_Db_Adapter_Pdo_Abstract::getStatementClass()Type | Description |
---|---|
string |


insert(mixed $table, array $bind) : int
Inserts a table row with specified data.
Inherited from: \Zend_Db_Adapter_Abstract::insert()\Zend_Db_Adapter_Pdo_Abstract::insert()Name | Type | Description |
---|---|---|
$table | mixed | The table to insert data into. |
$bind | array | Column-value pairs. |
Type | Description |
---|---|
int | The number of affected rows. |
Exception | Description |
---|---|
\Zend_Db_Adapter_Exception |


isConnected() : boolean
Test if a connection is active
Inherited from: \Zend_Db_Adapter_Pdo_Abstract::isConnected()Type | Description |
---|---|
boolean |


lastInsertId(string $tableName = null, string $primaryKey = null) : string
Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.
Inherited from: \Zend_Db_Adapter_Pdo_Abstract::lastInsertId()As a convention, on RDBMS brands that support sequences (e.g. Oracle, PostgreSQL, DB2), this method forms the name of a sequence from the arguments and returns the last id generated by that sequence. On RDBMS brands that support IDENTITY/AUTOINCREMENT columns, this method returns the last value generated for such a column, and the table name argument is disregarded.
On RDBMS brands that don't support sequences, $tableName and $primaryKey are ignored.
Name | Type | Description |
---|---|---|
$tableName | string | OPTIONAL Name of table. |
$primaryKey | string | OPTIONAL Name of primary key column. |
Type | Description |
---|---|
string |


lastSequenceId(string $sequenceName) : string
Return the most recent value from the specified sequence in the database.
Inherited from: \Zend_Db_Adapter_Abstract::lastSequenceId()\Zend_Db_Adapter_Pdo_Abstract::lastSequenceId()This is supported only on RDBMS brands that support sequences (e.g. Oracle, PostgreSQL, DB2). Other RDBMS brands return null.
Name | Type | Description |
---|---|---|
$sequenceName | string |
Type | Description |
---|---|
string |


limit(string $sql, integer $count, integer $offset = 0) : string
Adds an adapter-specific LIMIT clause to the SELECT statement.
Name | Type | Description |
---|---|---|
$sql | string | |
$count | integer | |
$offset | integer | OPTIONAL |
Type | Description |
---|---|
string |


nextSequenceId(string $sequenceName) : string
Generate a new value from the specified sequence in the database, and return it.
Inherited from: \Zend_Db_Adapter_Abstract::nextSequenceId()\Zend_Db_Adapter_Pdo_Abstract::nextSequenceId()This is supported only on RDBMS brands that support sequences (e.g. Oracle, PostgreSQL, DB2). Other RDBMS brands return null.
Name | Type | Description |
---|---|---|
$sequenceName | string |
Type | Description |
---|---|
string |


prepare(string $sql) : \PDOStatement
Name | Type | Description |
---|---|---|
$sql | string | The SQL statement with placeholders. |
Type | Description |
---|---|
\PDOStatement |


query(string | \Zend_Db_Select $sql, array $bind = array()) : \Zend_Db_Statement_Pdo
All bind parameter names must begin with ':'
Name | Type | Description |
---|---|---|
$sql | string | \Zend_Db_Select | The SQL statement with placeholders. |
$bind | array | An array of data to bind to the placeholders. |
Type | Description |
---|---|
\Zend_Db_Statement_Pdo |
Exception | Description |
---|---|
\Zend_Db_Adapter_Exception | To re-throw PDOException. |


quote(mixed $value, mixed $type = null) : mixed
Safely quotes a value for an SQL statement.
Inherited from: \Zend_Db_Adapter_Abstract::quote()\Zend_Db_Adapter_Pdo_Abstract::quote()If an array is passed as the value, the array values are quoted and then returned as a comma-separated string.
Name | Type | Description |
---|---|---|
$value | mixed | The value to quote. |
$type | mixed | OPTIONAL the SQL datatype name, or constant, or null. |
Type | Description |
---|---|
mixed | An SQL-safe quoted value (or string of separated values). |


quoteColumnAs(string | array | \Zend_Db_Expr $ident, string $alias, boolean $auto = false) : string
Quote a column identifier and alias.
Inherited from: \Zend_Db_Adapter_Abstract::quoteColumnAs()\Zend_Db_Adapter_Pdo_Abstract::quoteColumnAs()Name | Type | Description |
---|---|---|
$ident | string | array | \Zend_Db_Expr | The identifier or expression. |
$alias | string | An alias for the column. |
$auto | boolean | If true, heed the AUTO_QUOTE_IDENTIFIERS config option. |
Type | Description |
---|---|
string | The quoted identifier and alias. |


quoteIdentifier(string | array | \Zend_Db_Expr $ident, boolean $auto = false) : string
Quotes an identifier.
Inherited from: \Zend_Db_Adapter_Abstract::quoteIdentifier()\Zend_Db_Adapter_Pdo_Abstract::quoteIdentifier()Accepts a string representing a qualified indentifier. For Example:
$adapter->quoteIdentifier('myschema.mytable')
Returns: "myschema"."mytable"
Or, an array of one or more identifiers that may form a qualified identifier:
$adapter->quoteIdentifier(array('myschema','my.table'))
Returns: "myschema"."my.table"
The actual quote character surrounding the identifiers may vary depending on the adapter.
Name | Type | Description |
---|---|---|
$ident | string | array | \Zend_Db_Expr | The identifier. |
$auto | boolean | If true, heed the AUTO_QUOTE_IDENTIFIERS config option. |
Type | Description |
---|---|
string | The quoted identifier. |


quoteInto(string $text, mixed $value, string $type = null, integer $count = null) : string
Quotes a value and places into a piece of text at a placeholder.
Inherited from: \Zend_Db_Adapter_Abstract::quoteInto()\Zend_Db_Adapter_Pdo_Abstract::quoteInto()The placeholder is a question-mark; all placeholders will be replaced with the quoted value. For example:
$text = "WHERE date < ?";
$date = "2005-01-02";
$safe = $sql->quoteInto($text, $date);
// $safe = "WHERE date < '2005-01-02'"
Name | Type | Description |
---|---|---|
$text | string | The text with a placeholder. |
$value | mixed | The value to quote. |
$type | string | OPTIONAL SQL datatype |
$count | integer | OPTIONAL count of placeholders to replace |
Type | Description |
---|---|
string | An SQL-safe quoted value placed into the original text. |


quoteTableAs(string | array | \Zend_Db_Expr $ident, string $alias = null, boolean $auto = false) : string
Quote a table identifier and alias.
Inherited from: \Zend_Db_Adapter_Abstract::quoteTableAs()\Zend_Db_Adapter_Pdo_Abstract::quoteTableAs()Name | Type | Description |
---|---|---|
$ident | string | array | \Zend_Db_Expr | The identifier or expression. |
$alias | string | An alias for the table. |
$auto | boolean | If true, heed the AUTO_QUOTE_IDENTIFIERS config option. |
Type | Description |
---|---|
string | The quoted identifier and alias. |


rollBack() : \Zend_Db_Adapter_Abstract
Roll back a transaction and return to autocommit mode.
Inherited from: \Zend_Db_Adapter_Abstract::rollBack()\Zend_Db_Adapter_Pdo_Abstract::rollBack()Type | Description |
---|---|
\Zend_Db_Adapter_Abstract |


select() : \Zend_Db_Select
Creates and returns a new Zend_Db_Select object for this adapter.
Inherited from: \Zend_Db_Adapter_Abstract::select()\Zend_Db_Adapter_Pdo_Abstract::select()Type | Description |
---|---|
\Zend_Db_Select |


setFetchMode(int $mode) : void
Name | Type | Description |
---|---|---|
$mode | int | A PDO fetch mode. |
Exception | Description |
---|---|
\Zend_Db_Adapter_Exception |


setProfiler(\Zend_Db_Profiler | \Zend_Config | array | boolean $profiler) : \Zend_Db_Adapter_Abstract
Set the adapter's profiler object.
Inherited from: \Zend_Db_Adapter_Abstract::setProfiler()\Zend_Db_Adapter_Pdo_Abstract::setProfiler()The argument may be a boolean, an associative array, an instance of Zend_Db_Profiler, or an instance of Zend_Config.
A boolean argument sets the profiler to enabled if true, or disabled if false. The profiler class is the adapter's default profiler class, Zend_Db_Profiler.
An instance of Zend_Db_Profiler sets the adapter's instance to that object. The profiler is enabled and disabled separately.
An associative array argument may contain any of the keys 'enabled', 'class', and 'instance'. The 'enabled' and 'instance' keys correspond to the boolean and object types documented above. The 'class' key is used to name a class to use for a custom profiler. The class must be Zend_Db_Profiler or a subclass. The class is instantiated with no constructor arguments. The 'class' option is ignored when the 'instance' option is supplied.
An object of type Zend_Config may contain the properties 'enabled', 'class', and 'instance', just as if an associative array had been passed instead.
Name | Type | Description |
---|---|---|
$profiler | \Zend_Db_Profiler | \Zend_Config | array | boolean |
Type | Description |
---|---|
\Zend_Db_Adapter_Abstract | Provides a fluent interface |
Exception | Description |
---|---|
\Zend_Db_Profiler_Exception | if the object instance or class specified is not Zend_Db_Profiler or an extension of that class. |


setStatementClass( $class) : \Zend_Db_Adapter_Abstract
Set the default statement class.
Inherited from: \Zend_Db_Adapter_Abstract::setStatementClass()\Zend_Db_Adapter_Pdo_Abstract::setStatementClass()Name | Type | Description |
---|---|---|
$class |
Type | Description |
---|---|
\Zend_Db_Adapter_Abstract | Fluent interface |


supportsParameters(string $type) : bool
Check if the adapter supports real SQL parameters.
Inherited from: \Zend_Db_Adapter_Pdo_Abstract::supportsParameters()Name | Type | Description |
---|---|---|
$type | string | 'positional' or 'named' |
Type | Description |
---|---|
bool |


update(mixed $table, array $bind, mixed $where = '') : int
Updates table rows with specified data based on a WHERE clause.
Inherited from: \Zend_Db_Adapter_Abstract::update()\Zend_Db_Adapter_Pdo_Abstract::update()Name | Type | Description |
---|---|---|
$table | mixed | The table to update. |
$bind | array | Column-value pairs. |
$where | mixed | UPDATE WHERE clause(s). |
Type | Description |
---|---|
int | The number of affected rows. |
Exception | Description |
---|---|
\Zend_Db_Adapter_Exception |