bool $_autoQuoteIdentifiers = true (line 109)

Specifies whether the adapter automatically quotes identifiers.

If true, most SQL generated by Zend_Db classes applies identifier quoting automatically. If false, developer must quote identifiers themselves by calling quoteIdentifier().

• access: protected

integer $_caseFolding = Zend_Db::CASE_NATURAL (line 98)

Specifies the case of column names retrieved in queries

Options Zend_Db::CASE_NATURAL (default) Zend_Db::CASE_LOWER Zend_Db::CASE_UPPER

• access: protected

object|resource|null $_connection = null (line 87)

Database connection

• access: protected

string $_defaultStmtClass = 'Zend_Db_Statement' (line 73)

Default class name for a DB statement.

• access: protected

• Zend_Db_Adapter_Pdo_Abstract::$_defaultStmtClass : Default class name for a DB statement.
• Zend_Db_Adapter_Pdo_Oci::$_defaultStmtClass : Default class name for a DB statement.
• Zend_Db_Adapter_Db2::$_defaultStmtClass : Default class name for a DB statement.
• Zend_Db_Adapter_Mysqli::$_defaultStmtClass : Default class name for a DB statement.
• Zend_Db_Adapter_Sqlsrv::$_defaultStmtClass : Default class name for a DB statement.
• Zend_Db_Adapter_Oracle::$_defaultStmtClass : Default class name for a DB statement.

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

Keys are UPPERCASE SQL datatypes or the constants Zend_Db::INT_TYPE, Zend_Db::BIGINT_TYPE, or Zend_Db::FLOAT_TYPE.

Values are:

1. = 32-bit integer
2. = 64-bit integer
3. = float or decimal

• var: Associative array of datatypes to values 0, 1, or 2.
• access: protected

• Zend_Db_Adapter_Pdo_Mysql::$_numericDataTypes : Keys are UPPERCASE SQL datatypes or the constants Zend_Db::INT_TYPE, Zend_Db::BIGINT_TYPE, or Zend_Db::FLOAT_TYPE.
• Zend_Db_Adapter_Pdo_Mssql::$_numericDataTypes : Keys are UPPERCASE SQL datatypes or the constants Zend_Db::INT_TYPE, Zend_Db::BIGINT_TYPE, or Zend_Db::FLOAT_TYPE.
• Zend_Db_Adapter_Pdo_Pgsql::$_numericDataTypes : Keys are UPPERCASE SQL datatypes or the constants Zend_Db::INT_TYPE, Zend_Db::BIGINT_TYPE, or Zend_Db::FLOAT_TYPE.
• Zend_Db_Adapter_Pdo_Sqlite::$_numericDataTypes : Keys are UPPERCASE SQL datatypes or the constants Zend_Db::INT_TYPE, Zend_Db::BIGINT_TYPE, or Zend_Db::FLOAT_TYPE.
• Zend_Db_Adapter_Pdo_Ibm::$_numericDataTypes : Keys are UPPERCASE SQL datatypes or the constants Zend_Db::INT_TYPE, Zend_Db::BIGINT_TYPE, or Zend_Db::FLOAT_TYPE.
• Zend_Db_Adapter_Pdo_Oci::$_numericDataTypes : Keys are UPPERCASE SQL datatypes or the constants Zend_Db::INT_TYPE, Zend_Db::BIGINT_TYPE, or Zend_Db::FLOAT_TYPE.
• Zend_Db_Adapter_Db2::$_numericDataTypes : Keys are UPPERCASE SQL datatypes or the constants Zend_Db::INT_TYPE, Zend_Db::BIGINT_TYPE, or Zend_Db::FLOAT_TYPE.
• Zend_Db_Adapter_Mysqli::$_numericDataTypes : Keys are UPPERCASE SQL datatypes or the constants Zend_Db::INT_TYPE, Zend_Db::BIGINT_TYPE, or Zend_Db::FLOAT_TYPE.
• Zend_Db_Adapter_Sqlsrv::$_numericDataTypes : Keys are UPPERCASE SQL datatypes or the constants Zend_Db::INT_TYPE, Zend_Db::BIGINT_TYPE, or Zend_Db::FLOAT_TYPE.
• Zend_Db_Adapter_Oracle::$_numericDataTypes : Keys are UPPERCASE SQL datatypes or the constants Zend_Db::INT_TYPE, Zend_Db::BIGINT_TYPE, or Zend_Db::FLOAT_TYPE.

Constructor __construct (line 163)

Constructor.

$config is an array of key/value pairs or an instance of Zend_Config containing configuration options. These options are common to most adapters:

dbname => (string) The name of the database to user username => (string) Connect to the database as this username. password => (string) Password associated with the username. host => (string) What host to connect to, defaults to localhost

Some options are used on a case-by-case basis by adapters:

port => (string) The port of the database persistent => (boolean) Whether to use a persistent connection or not, defaults to false protocol => (string) The network protocol, defaults to TCPIP caseFolding => (int) style of case-alteration used for identifiers

• throws: Zend_Db_Adapter_Exception
• access: public

• array|Zend_Config $config: An array or instance of Zend_Config having configuration data

• Zend_Db_Adapter_Pdo_Sqlite::__construct() : Constructor.
• Zend_Test_DbAdapter::__construct() : Empty constructor to make it parameterless.

closeConnection (line 1178)

Force the connection to close.

• abstract:
• access: public

• Zend_Db_Adapter_Pdo_Abstract::closeConnection() : Force the connection to close.
• Zend_Db_Adapter_Db2::closeConnection() : Force the connection to close.
• Zend_Db_Adapter_Mysqli::closeConnection() : Force the connection to close.
• Zend_Db_Adapter_Sqlsrv::closeConnection() : Force the connection to close.
• Zend_Db_Adapter_Oracle::closeConnection() : Force the connection to close.
• Zend_Test_DbAdapter::closeConnection() : Force the connection to close.

delete (line 619)

Deletes table rows based on a WHERE clause.

• return: The number of affected rows.
• access: public

• mixed $table: The table to update.
• mixed $where: DELETE WHERE clause(s).

fetchAll (line 701)

Fetches all SQL result rows as a sequential array.

Uses the current fetchMode for the adapter.

• access: public

• string|Zend_Db_Select $sql: An SQL SELECT statement.
• mixed $bind: Data to bind into SELECT placeholders.
• mixed $fetchMode: Override current fetch mode.

fetchCol (line 763)

Fetches the first column of all SQL result rows as an array.

The first column in each row is used as the array key.

• access: public

• string|Zend_Db_Select $sql: An SQL SELECT statement.
• mixed $bind: Data to bind into SELECT placeholders.

fetchPairs (line 780)

Fetches all SQL result rows as an array of key-value pairs.

The first column is the key, the second column is the value.

• access: public

• string|Zend_Db_Select $sql: An SQL SELECT statement.
• mixed $bind: Data to bind into SELECT placeholders.

foldCase (line 1073)

Helper method to change the case of the strings used when returning result sets in FETCH_ASSOC and FETCH_BOTH modes.

This is not intended to be used by application code, but the method must be public so the Statement class can invoke it.

• access: public

• string $key

getConnection (line 302)

Returns the underlying database connection object or resource.

If not presently connected, this initiates the connection.

• access: public

getProfiler (line 411)

Returns the profiler for this adapter.

• access: public

getServerVersion (line 1251)

Retrieve server version in PHP style

• abstract:
• access: public

• Zend_Db_Adapter_Pdo_Abstract::getServerVersion() : Retrieve server version in PHP style
• Zend_Db_Adapter_Pdo_Mssql::getServerVersion() : Retrieve server version in PHP style
• Zend_Db_Adapter_Pdo_Ibm::getServerVersion() : Retrieve server version in PHP style
• Zend_Db_Adapter_Db2::getServerVersion() : Retrieve server version in PHP style
• Zend_Db_Adapter_Mysqli::getServerVersion() : Retrieve server version in PHP style
• Zend_Db_Adapter_Sqlsrv::getServerVersion() : Retrieve server version in PHP style
• Zend_Db_Adapter_Oracle::getServerVersion() : Retrieve server version in PHP style
• Zend_Test_DbAdapter::getServerVersion() : Retrieve server version in PHP style

insert (line 524)

Inserts a table row with specified data.

• return: The number of affected rows.
• access: public

• mixed $table: The table to insert data into.
• array $bind: Column-value pairs.

• Zend_Db_Adapter_Pdo_Ibm::insert() : Inserts a table row with specified data.
• Zend_Db_Adapter_Sqlsrv::insert() : Inserts a table row with specified data.
• Zend_Db_Adapter_Oracle::insert() : Inserts a table row with specified data.

lastInsertId (line 1202)

Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.

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.

• abstract:
• access: public

• string $tableName: OPTIONAL Name of table.
• string $primaryKey: OPTIONAL Name of primary key column.

• Zend_Db_Adapter_Pdo_Abstract::lastInsertId() : Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.
• Zend_Db_Adapter_Pdo_Mssql::lastInsertId() : Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.
• Zend_Db_Adapter_Pdo_Pgsql::lastInsertId() : Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.
• Zend_Db_Adapter_Pdo_Ibm::lastInsertId() : Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.
• Zend_Db_Adapter_Pdo_Oci::lastInsertId() : Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.
• Zend_Db_Adapter_Db2::lastInsertId() : Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.
• Zend_Db_Adapter_Mysqli::lastInsertId() : Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.
• Zend_Db_Adapter_Sqlsrv::lastInsertId() : Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.
• Zend_Db_Adapter_Oracle::lastInsertId() : Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.
• Zend_Test_DbAdapter::lastInsertId() : Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.

limit (line 1236)

Adds an adapter-specific LIMIT clause to the SELECT statement.

• abstract:
• access: public

• mixed $sql
• integer $count
• integer $offset

• Zend_Db_Adapter_Pdo_Mysql::limit() : Adds an adapter-specific LIMIT clause to the SELECT statement.
• Zend_Db_Adapter_Pdo_Mssql::limit() : Adds an adapter-specific LIMIT clause to the SELECT statement.
• Zend_Db_Adapter_Pdo_Pgsql::limit() : Adds an adapter-specific LIMIT clause to the SELECT statement.
• Zend_Db_Adapter_Pdo_Sqlite::limit() : Adds an adapter-specific LIMIT clause to the SELECT statement.
• Zend_Db_Adapter_Pdo_Ibm::limit() : Adds an adapter-specific LIMIT clause to the SELECT statement.
• Zend_Db_Adapter_Pdo_Oci::limit() : Adds an adapter-specific LIMIT clause to the SELECT statement.
• Zend_Db_Adapter_Db2::limit() : Adds an adapter-specific LIMIT clause to the SELECT statement.
• Zend_Db_Adapter_Mysqli::limit() : Adds an adapter-specific LIMIT clause to the SELECT statement.
• Zend_Db_Adapter_Sqlsrv::limit() : Adds an adapter-specific LIMIT clause to the SELECT statement.
• Zend_Db_Adapter_Oracle::limit() : Adds an adapter-specific LIMIT clause to the SELECT statement.
• Zend_Test_DbAdapter::limit() : Adds an adapter-specific LIMIT clause to the SELECT statement.

nextSequenceId (line 1056)

Generate a new value from the specified sequence in the database, and return it.

This is supported only on RDBMS brands that support sequences (e.g. Oracle, PostgreSQL, DB2). Other RDBMS brands return null.

• access: public

• string $sequenceName

• Zend_Db_Adapter_Pdo_Pgsql::nextSequenceId() : Generate a new value from the specified sequence in the database, and return it.
• Zend_Db_Adapter_Pdo_Ibm::nextSequenceId() : Generate a new value from the specified sequence in the database, and return it.
• Zend_Db_Adapter_Pdo_Oci::nextSequenceId() : Generate a new value from the specified sequence in the database, and return it.
• Zend_Db_Adapter_Db2::nextSequenceId() : Generate a new value from the specified sequence in the database, and return it.
• Zend_Db_Adapter_Oracle::nextSequenceId() : Generate a new value from the specified sequence in the database, and return it.

query (line 445)

Prepares and executes an SQL statement with bound data.

• access: public

• mixed $sql: The SQL statement with placeholders. May be a string or Zend_Db_Select.
• mixed $bind: An array of data to bind to the placeholders.

• Zend_Db_Adapter_Pdo_Abstract::query() : Special handling for PDO query().

quoteColumnAs (line 949)

Quote a column identifier and alias.

• return: The quoted identifier and alias.
• access: public

• string|array|Zend_Db_Expr $ident: The identifier or expression.
• string $alias: An alias for the column.
• boolean $auto: If true, heed the AUTO_QUOTE_IDENTIFIERS config option.

quoteInto (line 899)

Quotes a value and places into a piece of text at a placeholder.

The placeholder is a question-mark; all placeholders will be replaced with the quoted value. For example:

• return: An SQL-safe quoted value placed into the original text.
• access: public

• string $text: The text with a placeholder.
• mixed $value: The value to quote.
• string $type: OPTIONAL SQL datatype
• integer $count: OPTIONAL count of placeholders to replace

rollBack (line 508)

Roll back a transaction and return to autocommit mode.

• access: public

setFetchMode (line 1226)

Set the fetch mode.

• abstract:
• throws: Zend_Db_Adapter_Exception
• access: public

• integer $mode

• Zend_Db_Adapter_Pdo_Abstract::setFetchMode() : Set the PDO fetch mode.
• Zend_Db_Adapter_Db2::setFetchMode() : Set the fetch mode.
• Zend_Db_Adapter_Mysqli::setFetchMode() : Set the fetch mode.
• Zend_Db_Adapter_Sqlsrv::setFetchMode() : Set the fetch mode.
• Zend_Db_Adapter_Oracle::setFetchMode() : Set the fetch mode.
• Zend_Test_DbAdapter::setFetchMode() : Set the fetch mode.

setStatementClass (line 431)

Set the default statement class.

• return: Fluent interface
• access: public

• $class

update (line 559)

Updates table rows with specified data based on a WHERE clause.

• return: The number of affected rows.
• access: public

• mixed $table: The table to update.
• array $bind: Column-value pairs.
• mixed $where: UPDATE WHERE clause(s).

_checkRequiredOptions (line 270)

Check for config options that are mandatory.

Throw exceptions if any are missing.

• throws: Zend_Db_Adapter_Exception
• access: protected

• array $config

• Zend_Db_Adapter_Pdo_Sqlite::_checkRequiredOptions() : Check for config options that are mandatory.
• Zend_Db_Adapter_Pdo_Ibm::_checkRequiredOptions() : Checks required options
• Zend_Db_Adapter_Sqlsrv::_checkRequiredOptions() : Check for config options that are mandatory.

_connect (line 1164)

Creates a connection to the database.

• abstract:
• access: protected

• Zend_Db_Adapter_Pdo_Abstract::_connect() : Creates a PDO object and connects to the database.
• Zend_Db_Adapter_Pdo_Mysql::_connect() : Creates a PDO object and connects to the database.
• Zend_Db_Adapter_Pdo_Mssql::_connect()
• Zend_Db_Adapter_Pdo_Pgsql::_connect() : Creates a PDO object and connects to the database.
• Zend_Db_Adapter_Pdo_Sqlite::_connect() : Special configuration for SQLite behavior: make sure that result sets contain keys like 'column' instead of 'table.column'.
• Zend_Db_Adapter_Pdo_Ibm::_connect() : Creates a PDO object and connects to the database.
• Zend_Db_Adapter_Db2::_connect() : Creates a connection resource.
• Zend_Db_Adapter_Mysqli::_connect() : Creates a connection to the database.
• Zend_Db_Adapter_Sqlsrv::_connect() : Creates a connection resource.
• Zend_Db_Adapter_Oracle::_connect() : Creates a connection resource.
• Zend_Test_DbAdapter::_connect() : Creates a connection to the database.

_quoteIdentifier (line 1016)

Quote an identifier.

• return: The quoted identifier and alias.
• access: protected

• string $value: The identifier or expression.
• boolean $auto: If true, heed the AUTO_QUOTE_IDENTIFIERS config option.

_rollBack (line 1217)

Roll-back a transaction.

• abstract:
• access: protected

• Zend_Db_Adapter_Pdo_Abstract::_rollBack() : Roll-back a transaction.
• Zend_Db_Adapter_Pdo_Mssql::_rollBack() : Roll-back a transaction.
• Zend_Db_Adapter_Db2::_rollBack() : Rollback a transaction.
• Zend_Db_Adapter_Mysqli::_rollBack() : Roll-back a transaction.
• Zend_Db_Adapter_Sqlsrv::_rollBack() : Roll back a transaction and return to autocommit mode.
• Zend_Db_Adapter_Oracle::_rollBack() : Roll back a transaction and return to autocommit mode.
• Zend_Test_DbAdapter::_rollBack() : Roll-back a transaction.

__sleep (line 1096)

called when object is getting serialized This disconnects the DB object that cant be serialized

• throws: Zend_Db_Adapter_Exception
• access: public