Db.php

Show:

inherited

Classes
- \Zend_Db

Table of Contents

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 license@zend.com so we can send you a copy immediately.

Category: Zend
Copyright: Copyright (c) 2005-2014 Zend Technologies USA Inc. (http://www.zend.com)
License: New BSD License
Package: Zend_Db
Version: $Id$

\Zend_Db
jump to top

Package: Zend_Db

Class for connecting to SQL databases and performing common operations.

Category: Zend
Copyright: Copyright (c) 2005-2014 Zend Technologies USA Inc. (http://www.zend.com)
License: New BSD License

Constants

 
                PROFILER
                = 'profiler'

Use the PROFILER constant in the config of a Zend_Db_Adapter.

 
                CASE_FOLDING
                = 'caseFolding'

Use the CASE_FOLDING constant in the config of a Zend_Db_Adapter.

 
                FETCH_MODE
                = 'fetchMode'

Use the FETCH_MODE constant in the config of a Zend_Db_Adapter.

 
                AUTO_QUOTE_IDENTIFIERS
                = 'autoQuoteIdentifiers'

Use the AUTO_QUOTE_IDENTIFIERS constant in the config of a Zend_Db_Adapter.

 
                ALLOW_SERIALIZATION
                = 'allowSerialization'

Use the ALLOW_SERIALIZATION constant in the config of a Zend_Db_Adapter.

 
                AUTO_RECONNECT_ON_UNSERIALIZE
                = 'autoReconnectOnUnserialize'

Use the AUTO_RECONNECT_ON_UNSERIALIZE constant in the config of a Zend_Db_Adapter.

 
                INT_TYPE
                = 0

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

 
                BIGINT_TYPE
                = 1

 
                FLOAT_TYPE
                = 2

 
                ATTR_AUTOCOMMIT
                = 0

PDO constant values discovered by this script result:

$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
                = 8

 
                ATTR_CLIENT_VERSION
                = 5

 
                ATTR_CONNECTION_STATUS
                = 7

 
                ATTR_CURSOR
                = 10

 
                ATTR_CURSOR_NAME
                = 9

 
                ATTR_DRIVER_NAME
                = 16

 
                ATTR_ERRMODE
                = 3

 
                ATTR_FETCH_CATALOG_NAMES
                = 15

 
                ATTR_FETCH_TABLE_NAMES
                = 14

 
                ATTR_MAX_COLUMN_LEN
                = 18

 
                ATTR_ORACLE_NULLS
                = 11

 
                ATTR_PERSISTENT
                = 12

 
                ATTR_PREFETCH
                = 1

 
                ATTR_SERVER_INFO
                = 6

 
                ATTR_SERVER_VERSION
                = 4

 
                ATTR_STATEMENT_CLASS
                = 13

 
                ATTR_STRINGIFY_FETCHES
                = 17

 
                ATTR_TIMEOUT
                = 2

 
                CASE_LOWER
                = 2

 
                CASE_NATURAL
                = 0

 
                CASE_UPPER
                = 1

 
                CURSOR_FWDONLY
                = 0

 
                CURSOR_SCROLL
                = 1

 
                ERR_ALREADY_EXISTS
                = NULL

 
                ERR_CANT_MAP
                = NULL

 
                ERR_CONSTRAINT
                = NULL

 
                ERR_DISCONNECTED
                = NULL

 
                ERR_MISMATCH
                = NULL

 
                ERR_NO_PERM
                = NULL

 
                ERR_NONE
                = '00000'

 
                ERR_NOT_FOUND
                = NULL

 
                ERR_NOT_IMPLEMENTED
                = NULL

 
                ERR_SYNTAX
                = NULL

 
                ERR_TRUNCATED
                = NULL

 
                ERRMODE_EXCEPTION
                = 2

 
                ERRMODE_SILENT
                = 0

 
                ERRMODE_WARNING
                = 1

 
                FETCH_ASSOC
                = 2

 
                FETCH_BOTH
                = 4

 
                FETCH_BOUND
                = 6

 
                FETCH_CLASS
                = 8

 
                FETCH_CLASSTYPE
                = 262144

 
                FETCH_COLUMN
                = 7

 
                FETCH_FUNC
                = 10

 
                FETCH_GROUP
                = 65536

 
                FETCH_INTO
                = 9

 
                FETCH_LAZY
                = 1

 
                FETCH_NAMED
                = 11

 
                FETCH_NUM
                = 3

 
                FETCH_OBJ
                = 5

 
                FETCH_ORI_ABS
                = 4

 
                FETCH_ORI_FIRST
                = 2

 
                FETCH_ORI_LAST
                = 3

 
                FETCH_ORI_NEXT
                = 0

 
                FETCH_ORI_PRIOR
                = 1

 
                FETCH_ORI_REL
                = 5

 
                FETCH_SERIALIZE
                = 524288

 
                FETCH_UNIQUE
                = 196608

 
                NULL_EMPTY_STRING
                = 1

 
                NULL_NATURAL
                = 0

 
                NULL_TO_STRING
                = NULL

 
                PARAM_BOOL
                = 5

 
                PARAM_INPUT_OUTPUT
                = -2147483648

 
                PARAM_INT
                = 1

 
                PARAM_LOB
                = 3

 
                PARAM_NULL
                = 0

 
                PARAM_STMT
                = 4

 
                PARAM_STR
                = 2

Methods

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

static

Factory for Zend_Db_Adapter_Abstract classes.

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

Name	Type	Description
$adapter	mixed	String name of base adapter class, or Zend_Config object.
$config	mixed	OPTIONAL; an array or Zend_Config object with adapter parameters.

Returns

Type	Description
\Zend_Db_Adapter_Abstract

Throws

Exception	Description
\Zend_Db_Exception

Db.php

\Zend_Dbjump to top

Constants

Methods

\Zend_Db
jump to top