API Documentation

Db.php

Classes 
category
Zend
copyright
Copyright (c) 2005-2010 Zend Technologies USA Inc. (http://www.zend.com)
license
http://framework.zend.com/license/new-bsd New BSD License
package
Zend_Db
version
$Id: Db.php 20096 2010-01-06 02:05:09Z bkarwin $
Classes
Zend_Db

Description

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.

Zend_Db
jump to top

category
Zend
copyright
Copyright (c) 2005-2010 Zend Technologies USA Inc. (http://www.zend.com)
license
http://framework.zend.com/license/new-bsd New BSD License
package
Zend_Db
Constants
PROFILER
CASE_FOLDING
AUTO_QUOTE_IDENTIFIERS
ALLOW_SERIALIZATION
AUTO_RECONNECT_ON_UNSERIALIZE
INT_TYPE
BIGINT_TYPE
FLOAT_TYPE
ATTR_AUTOCOMMIT
ATTR_CASE
ATTR_CLIENT_VERSION
ATTR_CONNECTION_STATUS
ATTR_CURSOR
ATTR_CURSOR_NAME
ATTR_DRIVER_NAME
ATTR_ERRMODE
ATTR_FETCH_CATALOG_NAMES
ATTR_FETCH_TABLE_NAMES
ATTR_MAX_COLUMN_LEN
ATTR_ORACLE_NULLS
ATTR_PERSISTENT
ATTR_PREFETCH
ATTR_SERVER_INFO
ATTR_SERVER_VERSION
ATTR_STATEMENT_CLASS
ATTR_STRINGIFY_FETCHES
ATTR_TIMEOUT
CASE_LOWER
CASE_NATURAL
CASE_UPPER
CURSOR_FWDONLY
CURSOR_SCROLL
ERR_ALREADY_EXISTS
ERR_CANT_MAP
ERR_CONSTRAINT
ERR_DISCONNECTED
ERR_MISMATCH
ERR_NO_PERM
ERR_NONE
ERR_NOT_FOUND
ERR_NOT_IMPLEMENTED
ERR_SYNTAX
ERR_TRUNCATED
ERRMODE_EXCEPTION
ERRMODE_SILENT
ERRMODE_WARNING
FETCH_ASSOC
FETCH_BOTH
FETCH_BOUND
FETCH_CLASS
FETCH_CLASSTYPE
FETCH_COLUMN
FETCH_FUNC
FETCH_GROUP
FETCH_INTO
FETCH_LAZY
FETCH_NAMED
FETCH_NUM
FETCH_OBJ
FETCH_ORI_ABS
FETCH_ORI_FIRST
FETCH_ORI_LAST
FETCH_ORI_NEXT
FETCH_ORI_PRIOR
FETCH_ORI_REL
FETCH_SERIALIZE
FETCH_UNIQUE
NULL_EMPTY_STRING
NULL_NATURAL
NULL_TO_STRING
PARAM_BOOL
PARAM_INPUT_OUTPUT
PARAM_INT
PARAM_LOB
PARAM_NULL
PARAM_STMT
PARAM_STR
Methods
factory

Description

Class for connecting to SQL databases and performing common operations.

Constants

PROFILER
jump to class

 PROFILER = 'profiler'

Use the PROFILER constant in the config of a Zend_Db_Adapter.

Details

value
profiler

CASE_FOLDING
jump to class

 CASE_FOLDING = 'caseFolding'

Use the CASE_FOLDING constant in the config of a Zend_Db_Adapter.

Details

value
caseFolding

AUTO_QUOTE_IDENTIFIERS
jump to class

 AUTO_QUOTE_IDENTIFIERS = 'autoQuoteIdentifiers'

Use the AUTO_QUOTE_IDENTIFIERS constant in the config of a Zend_Db_Adapter.

Details

value
autoQuoteIdentifiers

ALLOW_SERIALIZATION
jump to class

 ALLOW_SERIALIZATION = 'allowSerialization'

Use the ALLOW_SERIALIZATION constant in the config of a Zend_Db_Adapter.

Details

value
allowSerialization

AUTO_RECONNECT_ON_UNSERIALIZE
jump to class

 AUTO_RECONNECT_ON_UNSERIALIZE = 'autoReconnectOnUnserialize'

Use the AUTO_RECONNECT_ON_UNSERIALIZE constant in the config of a Zend_Db_Adapter.

Details

value
autoReconnectOnUnserialize

INT_TYPE
jump to class

 INT_TYPE = '0'

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

Details

value
0

BIGINT_TYPE
jump to class

 BIGINT_TYPE = '1'

Details

value
1

FLOAT_TYPE
jump to class

 FLOAT_TYPE = '2'

Details

value
2

ATTR_AUTOCOMMIT
jump to class

 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);

Details

value
0

ATTR_CASE
jump to class

 ATTR_CASE = '8'

Details

value
8

ATTR_CLIENT_VERSION
jump to class

 ATTR_CLIENT_VERSION = '5'

Details

value
5

ATTR_CONNECTION_STATUS
jump to class

 ATTR_CONNECTION_STATUS = '7'

Details

value
7

ATTR_CURSOR
jump to class

 ATTR_CURSOR = '10'

Details

value
10

ATTR_CURSOR_NAME
jump to class

 ATTR_CURSOR_NAME = '9'

Details

value
9

ATTR_DRIVER_NAME
jump to class

 ATTR_DRIVER_NAME = '16'

Details

value
16

ATTR_ERRMODE
jump to class

 ATTR_ERRMODE = '3'

Details

value
3

ATTR_FETCH_CATALOG_NAMES
jump to class

 ATTR_FETCH_CATALOG_NAMES = '15'

Details

value
15

ATTR_FETCH_TABLE_NAMES
jump to class

 ATTR_FETCH_TABLE_NAMES = '14'

Details

value
14

ATTR_MAX_COLUMN_LEN
jump to class

 ATTR_MAX_COLUMN_LEN = '18'

Details

value
18

ATTR_ORACLE_NULLS
jump to class

 ATTR_ORACLE_NULLS = '11'

Details

value
11

ATTR_PERSISTENT
jump to class

 ATTR_PERSISTENT = '12'

Details

value
12

ATTR_PREFETCH
jump to class

 ATTR_PREFETCH = '1'

Details

value
1

ATTR_SERVER_INFO
jump to class

 ATTR_SERVER_INFO = '6'

Details

value
6

ATTR_SERVER_VERSION
jump to class

 ATTR_SERVER_VERSION = '4'

Details

value
4

ATTR_STATEMENT_CLASS
jump to class

 ATTR_STATEMENT_CLASS = '13'

Details

value
13

ATTR_STRINGIFY_FETCHES
jump to class

 ATTR_STRINGIFY_FETCHES = '17'

Details

value
17

ATTR_TIMEOUT
jump to class

 ATTR_TIMEOUT = '2'

Details

value
2

CASE_LOWER
jump to class

 CASE_LOWER = '2'

Details

value
2

CASE_NATURAL
jump to class

 CASE_NATURAL = '0'

Details

value
0

CASE_UPPER
jump to class

 CASE_UPPER = '1'

Details

value
1

CURSOR_FWDONLY
jump to class

 CURSOR_FWDONLY = '0'

Details

value
0

CURSOR_SCROLL
jump to class

 CURSOR_SCROLL = '1'

Details

value
1

ERR_ALREADY_EXISTS
jump to class

 ERR_ALREADY_EXISTS = 'NULL'

Details

value
NULL

ERR_CANT_MAP
jump to class

 ERR_CANT_MAP = 'NULL'

Details

value
NULL

ERR_CONSTRAINT
jump to class

 ERR_CONSTRAINT = 'NULL'

Details

value
NULL

ERR_DISCONNECTED
jump to class

 ERR_DISCONNECTED = 'NULL'

Details

value
NULL

ERR_MISMATCH
jump to class

 ERR_MISMATCH = 'NULL'

Details

value
NULL

ERR_NO_PERM
jump to class

 ERR_NO_PERM = 'NULL'

Details

value
NULL

ERR_NONE
jump to class

 ERR_NONE = '00000'

Details

value
00000

ERR_NOT_FOUND
jump to class

 ERR_NOT_FOUND = 'NULL'

Details

value
NULL

ERR_NOT_IMPLEMENTED
jump to class

 ERR_NOT_IMPLEMENTED = 'NULL'

Details

value
NULL

ERR_SYNTAX
jump to class

 ERR_SYNTAX = 'NULL'

Details

value
NULL

ERR_TRUNCATED
jump to class

 ERR_TRUNCATED = 'NULL'

Details

value
NULL

ERRMODE_EXCEPTION
jump to class

 ERRMODE_EXCEPTION = '2'

Details

value
2

ERRMODE_SILENT
jump to class

 ERRMODE_SILENT = '0'

Details

value
0

ERRMODE_WARNING
jump to class

 ERRMODE_WARNING = '1'

Details

value
1

FETCH_ASSOC
jump to class

 FETCH_ASSOC = '2'

Details

value
2

FETCH_BOTH
jump to class

 FETCH_BOTH = '4'

Details

value
4

FETCH_BOUND
jump to class

 FETCH_BOUND = '6'

Details

value
6

FETCH_CLASS
jump to class

 FETCH_CLASS = '8'

Details

value
8

FETCH_CLASSTYPE
jump to class

 FETCH_CLASSTYPE = '262144'

Details

value
262144

FETCH_COLUMN
jump to class

 FETCH_COLUMN = '7'

Details

value
7

FETCH_FUNC
jump to class

 FETCH_FUNC = '10'

Details

value
10

FETCH_GROUP
jump to class

 FETCH_GROUP = '65536'

Details

value
65536

FETCH_INTO
jump to class

 FETCH_INTO = '9'

Details

value
9

FETCH_LAZY
jump to class

 FETCH_LAZY = '1'

Details

value
1

FETCH_NAMED
jump to class

 FETCH_NAMED = '11'

Details

value
11

FETCH_NUM
jump to class

 FETCH_NUM = '3'

Details

value
3

FETCH_OBJ
jump to class

 FETCH_OBJ = '5'

Details

value
5

FETCH_ORI_ABS
jump to class

 FETCH_ORI_ABS = '4'

Details

value
4

FETCH_ORI_FIRST
jump to class

 FETCH_ORI_FIRST = '2'

Details

value
2

FETCH_ORI_LAST
jump to class

 FETCH_ORI_LAST = '3'

Details

value
3

FETCH_ORI_NEXT
jump to class

 FETCH_ORI_NEXT = '0'

Details

value
0

FETCH_ORI_PRIOR
jump to class

 FETCH_ORI_PRIOR = '1'

Details

value
1

FETCH_ORI_REL
jump to class

 FETCH_ORI_REL = '5'

Details

value
5

FETCH_SERIALIZE
jump to class

 FETCH_SERIALIZE = '524288'

Details

value
524288

FETCH_UNIQUE
jump to class

 FETCH_UNIQUE = '196608'

Details

value
196608

NULL_EMPTY_STRING
jump to class

 NULL_EMPTY_STRING = '1'

Details

value
1

NULL_NATURAL
jump to class

 NULL_NATURAL = '0'

Details

value
0

NULL_TO_STRING
jump to class

 NULL_TO_STRING = 'NULL'

Details

value
NULL

PARAM_BOOL
jump to class

 PARAM_BOOL = '5'

Details

value
5

PARAM_INPUT_OUTPUT
jump to class

 PARAM_INPUT_OUTPUT = '2147483648'

Details

value
2147483648

PARAM_INT
jump to class

 PARAM_INT = '1'

Details

value
1

PARAM_LOB
jump to class

 PARAM_LOB = '3'

Details

value
3

PARAM_NULL
jump to class

 PARAM_NULL = '0'

Details

value
0

PARAM_STMT
jump to class

 PARAM_STMT = '4'

Details

value
4

PARAM_STR
jump to class

 PARAM_STR = '2'

Details

value
2

Methods

factory
jump to class

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

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.

Arguments
$adapter
mixed
String name of base adapter class, or Zend_Config object.
$config
mixed
OPTIONAL; an array or Zend_Config object with adapter parameters.
Output
Zend_Db_Adapter_Abstract
Details
visibility
public
final
false
static
true
throws
Documentation was generated by DocBlox.