Class for connecting to SQL databases and performing common operations.

category Zend
package Zend_Db
copyright Copyright (c) 2005-2015 Zend Technologies USA Inc. (http://www.zend.com)
license New BSD License

 Methods

Factory for Zend_Db_Adapter_Abstract classes.

factory(mixed $adapter, mixed $config = array()) : \Zend_Db_Adapter_Abstract
Static

First argument may be a string containing the base of the adapter class name, e.g. 'Mysqli' corresponds to class Zend_Db_Adapter_Mysqli. This name is currently case-insensitive, but is not ideal to rely on this behavior. If your class is named 'My_Company_Pdo_Mysql', where 'My_Company' is the namespace and 'Pdo_Mysql' is the adapter name, it is best to use the name exactly as it is defined in the class. This will ensure proper use of the factory API.

First argument may alternatively be an object of type Zend_Config. The adapter class base name is read from the 'adapter' property. The adapter config parameters are read from the 'params' property.

Second argument is optional and may be an associative array of key-value pairs. This is used as the argument to the adapter constructor.

If the first argument is of type Zend_Config, it is assumed to contain all parameters, and the second argument is ignored.

Parameters

$adapter

mixed

String name of base adapter class, or Zend_Config object.

$config

mixed

OPTIONAL; an array or Zend_Config object with adapter parameters.

Exceptions

\Zend_Db_Exception

Returns

\Zend_Db_Adapter_Abstract

 Constants

 

Use the ALLOW_SERIALIZATION constant in the config of a Zend_Db_Adapter.

ALLOW_SERIALIZATION = 'allowSerialization' 
 

PDO constant values discovered by this script result:

ATTR_AUTOCOMMIT = 0 

$list = array( 'PARAM_BOOL', 'PARAM_NULL', 'PARAM_INT', 'PARAM_STR', 'PARAM_LOB', 'PARAM_STMT', 'PARAM_INPUT_OUTPUT', 'FETCH_LAZY', 'FETCH_ASSOC', 'FETCH_NUM', 'FETCH_BOTH', 'FETCH_OBJ', 'FETCH_BOUND', 'FETCH_COLUMN', 'FETCH_CLASS', 'FETCH_INTO', 'FETCH_FUNC', 'FETCH_GROUP', 'FETCH_UNIQUE', 'FETCH_CLASSTYPE', 'FETCH_SERIALIZE', 'FETCH_NAMED', 'ATTR_AUTOCOMMIT', 'ATTR_PREFETCH', 'ATTR_TIMEOUT', 'ATTR_ERRMODE', 'ATTR_SERVER_VERSION', 'ATTR_CLIENT_VERSION', 'ATTR_SERVER_INFO', 'ATTR_CONNECTION_STATUS', 'ATTR_CASE', 'ATTR_CURSOR_NAME', 'ATTR_CURSOR', 'ATTR_ORACLE_NULLS', 'ATTR_PERSISTENT', 'ATTR_STATEMENT_CLASS', 'ATTR_FETCH_TABLE_NAMES', 'ATTR_FETCH_CATALOG_NAMES', 'ATTR_DRIVER_NAME', 'ATTR_STRINGIFY_FETCHES', 'ATTR_MAX_COLUMN_LEN', 'ERRMODE_SILENT', 'ERRMODE_WARNING', 'ERRMODE_EXCEPTION', 'CASE_NATURAL', 'CASE_LOWER', 'CASE_UPPER', 'NULL_NATURAL', 'NULL_EMPTY_STRING', 'NULL_TO_STRING', 'ERR_NONE', 'FETCH_ORI_NEXT', 'FETCH_ORI_PRIOR', 'FETCH_ORI_FIRST', 'FETCH_ORI_LAST', 'FETCH_ORI_ABS', 'FETCH_ORI_REL', 'CURSOR_FWDONLY', 'CURSOR_SCROLL', 'ERR_CANT_MAP', 'ERR_SYNTAX', 'ERR_CONSTRAINT', 'ERR_NOT_FOUND', 'ERR_ALREADY_EXISTS', 'ERR_NOT_IMPLEMENTED', 'ERR_MISMATCH', 'ERR_TRUNCATED', 'ERR_DISCONNECTED', 'ERR_NO_PERM', );

$const = array(); foreach ($list as $name) { $const[$name] = constant("PDO::$name"); } var_export($const);

 

ATTR_CASE

ATTR_CASE = 8 
 

ATTR_CLIENT_VERSION

ATTR_CLIENT_VERSION = 5 
 

ATTR_CONNECTION_STATUS

ATTR_CONNECTION_STATUS = 7 
 

ATTR_CURSOR

ATTR_CURSOR = 10 
 

ATTR_CURSOR_NAME

ATTR_CURSOR_NAME = 9 
 

ATTR_DRIVER_NAME

ATTR_DRIVER_NAME = 16 
 

ATTR_ERRMODE

ATTR_ERRMODE = 3 
 

ATTR_FETCH_CATALOG_NAMES

ATTR_FETCH_CATALOG_NAMES = 15 
 

ATTR_FETCH_TABLE_NAMES

ATTR_FETCH_TABLE_NAMES = 14 
 

ATTR_MAX_COLUMN_LEN

ATTR_MAX_COLUMN_LEN = 18 
 

ATTR_ORACLE_NULLS

ATTR_ORACLE_NULLS = 11 
 

ATTR_PERSISTENT

ATTR_PERSISTENT = 12 
 

ATTR_PREFETCH

ATTR_PREFETCH = 1 
 

ATTR_SERVER_INFO

ATTR_SERVER_INFO = 6 
 

ATTR_SERVER_VERSION

ATTR_SERVER_VERSION = 4 
 

ATTR_STATEMENT_CLASS

ATTR_STATEMENT_CLASS = 13 
 

ATTR_STRINGIFY_FETCHES

ATTR_STRINGIFY_FETCHES = 17 
 

ATTR_TIMEOUT

ATTR_TIMEOUT = 2 
 

Use the AUTO_QUOTE_IDENTIFIERS constant in the config of a Zend_Db_Adapter.

AUTO_QUOTE_IDENTIFIERS = 'autoQuoteIdentifiers' 
 

Use the AUTO_RECONNECT_ON_UNSERIALIZE constant in the config of a Zend_Db_Adapter.

AUTO_RECONNECT_ON_UNSERIALIZE = 'autoReconnectOnUnserialize' 
 

BIGINT_TYPE

BIGINT_TYPE = 1 
 

Use the CASE_FOLDING constant in the config of a Zend_Db_Adapter.

CASE_FOLDING = 'caseFolding' 
 

CASE_LOWER

CASE_LOWER = 2 
 

CASE_NATURAL

CASE_NATURAL = 0 
 

CASE_UPPER

CASE_UPPER = 1 
 

CURSOR_FWDONLY

CURSOR_FWDONLY = 0 
 

CURSOR_SCROLL

CURSOR_SCROLL = 1 
 

ERRMODE_EXCEPTION

ERRMODE_EXCEPTION = 2 
 

ERRMODE_SILENT

ERRMODE_SILENT = 0 
 

ERRMODE_WARNING

ERRMODE_WARNING = 1 
 

ERR_ALREADY_EXISTS

ERR_ALREADY_EXISTS = NULL 
 

ERR_CANT_MAP

ERR_CANT_MAP = NULL 
 

ERR_CONSTRAINT

ERR_CONSTRAINT = NULL 
 

ERR_DISCONNECTED

ERR_DISCONNECTED = NULL 
 

ERR_MISMATCH

ERR_MISMATCH = NULL 
 

ERR_NONE

ERR_NONE = '00000' 
 

ERR_NOT_FOUND

ERR_NOT_FOUND = NULL 
 

ERR_NOT_IMPLEMENTED

ERR_NOT_IMPLEMENTED = NULL 
 

ERR_NO_PERM

ERR_NO_PERM = NULL 
 

ERR_SYNTAX

ERR_SYNTAX = NULL 
 

ERR_TRUNCATED

ERR_TRUNCATED = NULL 
 

FETCH_ASSOC

FETCH_ASSOC = 2 
 

FETCH_BOTH

FETCH_BOTH = 4 
 

FETCH_BOUND

FETCH_BOUND = 6 
 

FETCH_CLASS

FETCH_CLASS = 8 
 

FETCH_CLASSTYPE

FETCH_CLASSTYPE = 262144 
 

FETCH_COLUMN

FETCH_COLUMN = 7 
 

FETCH_FUNC

FETCH_FUNC = 10 
 

FETCH_GROUP

FETCH_GROUP = 65536 
 

FETCH_INTO

FETCH_INTO = 9 
 

FETCH_LAZY

FETCH_LAZY = 1 
 

Use the FETCH_MODE constant in the config of a Zend_Db_Adapter.

FETCH_MODE = 'fetchMode' 
 

FETCH_NAMED

FETCH_NAMED = 11 
 

FETCH_NUM

FETCH_NUM = 3 
 

FETCH_OBJ

FETCH_OBJ = 5 
 

FETCH_ORI_ABS

FETCH_ORI_ABS = 4 
 

FETCH_ORI_FIRST

FETCH_ORI_FIRST = 2 
 

FETCH_ORI_LAST

FETCH_ORI_LAST = 3 
 

FETCH_ORI_NEXT

FETCH_ORI_NEXT = 0 
 

FETCH_ORI_PRIOR

FETCH_ORI_PRIOR = 1 
 

FETCH_ORI_REL

FETCH_ORI_REL = 5 
 

FETCH_SERIALIZE

FETCH_SERIALIZE = 524288 
 

FETCH_UNIQUE

FETCH_UNIQUE = 196608 
 

FLOAT_TYPE

FLOAT_TYPE = 2 
 

Use the INT_TYPE, BIGINT_TYPE, and FLOAT_TYPE with the quote() method.

INT_TYPE = 0 
 

NULL_EMPTY_STRING

NULL_EMPTY_STRING = 1 
 

NULL_NATURAL

NULL_NATURAL = 0 
 

NULL_TO_STRING

NULL_TO_STRING = NULL 
 

PARAM_BOOL

PARAM_BOOL = 5 
 

PARAM_INPUT_OUTPUT

PARAM_INPUT_OUTPUT = -2147483648 
 

PARAM_INT

PARAM_INT = 1 
 

PARAM_LOB

PARAM_LOB = 3 
 

PARAM_NULL

PARAM_NULL = 0 
 

PARAM_STMT

PARAM_STMT = 4 
 

PARAM_STR

PARAM_STR = 2 
 

Use the PROFILER constant in the config of a Zend_Db_Adapter.

PROFILER = 'profiler'