File: DB.php

Source Location: /DB-1.6.2/DB.php

Classes:

The main "DB" class is simply a container class with some static methods for creating DB objects as well as some utility functions common to all parts of DB.

DB_Error

DB_Error implements a class for reporting portable database error messages.

DB_result

This class implements a wrapper for a DB result set.

DB_row

Pear DB Row Object

Page Details:

Filesource: Source Code for this file

Includes:

require_once('PEAR.php') [line 26]

DB_AUTOQUERY_INSERT [line 169]

DB_AUTOQUERY_INSERT = 1

[ Top ]

DB_AUTOQUERY_UPDATE [line 170]

DB_AUTOQUERY_UPDATE = 2

[ Top ]

DB_BINMODE_CONVERT [line 111]

DB_BINMODE_CONVERT = 3

[ Top ]

DB_BINMODE_PASSTHRU [line 109]

DB_BINMODE_PASSTHRU = 1

[ Top ]

DB_BINMODE_RETURN [line 110]

DB_BINMODE_RETURN = 2

[ Top ]

DB_ERROR [line 39]

DB_ERROR = -1

[ Top ]

DB_ERROR_ACCESS_VIOLATION [line 64]

DB_ERROR_ACCESS_VIOLATION = -26

[ Top ]

DB_ERROR_ALREADY_EXISTS [line 43]

DB_ERROR_ALREADY_EXISTS = -5

[ Top ]

DB_ERROR_CANNOT_CREATE [line 53]

DB_ERROR_CANNOT_CREATE = -15

[ Top ]

DB_ERROR_CANNOT_DELETE [line 54]

DB_ERROR_CANNOT_DELETE = -16

[ Top ]

DB_ERROR_CANNOT_DROP [line 55]

DB_ERROR_CANNOT_DROP = -17

[ Top ]

DB_ERROR_CONNECT_FAILED [line 62]

DB_ERROR_CONNECT_FAILED = -24

[ Top ]

DB_ERROR_CONSTRAINT [line 41]

DB_ERROR_CONSTRAINT = -3

[ Top ]

DB_ERROR_CONSTRAINT_NOT_NULL [line 66]

DB_ERROR_CONSTRAINT_NOT_NULL = -29

[ Top ]

DB_ERROR_DIVZERO [line 51]

DB_ERROR_DIVZERO = -13

[ Top ]

DB_ERROR_EXTENSION_NOT_FOUND [line 63]

DB_ERROR_EXTENSION_NOT_FOUND = -25

[ Top ]

DB_ERROR_INVALID [line 46]

DB_ERROR_INVALID = -8

[ Top ]

DB_ERROR_INVALID_DATE [line 50]

DB_ERROR_INVALID_DATE = -12

[ Top ]

DB_ERROR_INVALID_DSN [line 61]

DB_ERROR_INVALID_DSN = -23

[ Top ]

DB_ERROR_INVALID_NUMBER [line 49]

DB_ERROR_INVALID_NUMBER = -11

[ Top ]

DB_ERROR_MISMATCH [line 45]

DB_ERROR_MISMATCH = -7

[ Top ]

DB_ERROR_NEED_MORE_DATA [line 58]

DB_ERROR_NEED_MORE_DATA = -20

[ Top ]

DB_ERROR_NODBSELECTED [line 52]

DB_ERROR_NODBSELECTED = -14

[ Top ]

DB_ERROR_NOSUCHDB [line 65]

DB_ERROR_NOSUCHDB = -27

[ Top ]

DB_ERROR_NOSUCHFIELD [line 57]

DB_ERROR_NOSUCHFIELD = -19

[ Top ]

DB_ERROR_NOSUCHTABLE [line 56]

DB_ERROR_NOSUCHTABLE = -18

[ Top ]

DB_ERROR_NOT_CAPABLE [line 47]

DB_ERROR_NOT_CAPABLE = -9

[ Top ]

DB_ERROR_NOT_FOUND [line 42]

DB_ERROR_NOT_FOUND = -4

[ Top ]

DB_ERROR_NOT_LOCKED [line 59]

DB_ERROR_NOT_LOCKED = -21

[ Top ]

DB_ERROR_SYNTAX [line 40]

DB_ERROR_SYNTAX = -2

[ Top ]

DB_ERROR_TRUNCATED [line 48]

DB_ERROR_TRUNCATED = -10

[ Top ]

DB_ERROR_UNSUPPORTED [line 44]

DB_ERROR_UNSUPPORTED = -6

[ Top ]

DB_ERROR_VALUE_COUNT_ON_ROW [line 60]

DB_ERROR_VALUE_COUNT_ON_ROW = -22

[ Top ]

DB_FETCHMODE_ASSOC [line 132]

DB_FETCHMODE_ASSOC = 2

Column data indexed by column names

[ Top ]

DB_FETCHMODE_DEFAULT [line 122]

DB_FETCHMODE_DEFAULT = 0

This is a special constant that tells DB the user hasn't specified any particular get mode, so the default should be used.

[ Top ]

DB_FETCHMODE_FLIPPED [line 145]

DB_FETCHMODE_FLIPPED = 4

For multi-dimensional results: normally the first level of arrays is the row number, and the second level indexed by column number or name.

DB_FETCHMODE_FLIPPED switches this order, so the first level of arrays is the column name, and the second level the row number.

[ Top ]

DB_FETCHMODE_OBJECT [line 137]

DB_FETCHMODE_OBJECT = 3

Column data as object properties

[ Top ]

DB_FETCHMODE_ORDERED [line 127]

DB_FETCHMODE_ORDERED = 1

Column data indexed by numbers, ordered from 0 and up

[ Top ]

DB_GETMODE_ASSOC [line 149]

DB_GETMODE_ASSOC = DB_FETCHMODE_ASSOC

[ Top ]

DB_GETMODE_FLIPPED [line 150]

DB_GETMODE_FLIPPED = DB_FETCHMODE_FLIPPED

[ Top ]

DB_GETMODE_ORDERED [line 148]

DB_GETMODE_ORDERED = DB_FETCHMODE_ORDERED

[ Top ]

DB_OK [line 38]

DB_OK = 1

[ Top ]

DB_PARAM_MISC [line 91]

DB_PARAM_MISC = 3

[ Top ]

DB_PARAM_OPAQUE [line 90]

DB_PARAM_OPAQUE = 2

[ Top ]

DB_PARAM_SCALAR [line 89]

DB_PARAM_SCALAR = 1

[ Top ]

DB_PORTABILITY_ALL [line 234]

DB_PORTABILITY_ALL = 63

Portability: turn on all portability features.

See: DB_common::setOption()

[ Top ]

DB_PORTABILITY_DELETE_COUNT [line 200]

DB_PORTABILITY_DELETE_COUNT = 4

Portability: force reporting the number of rows deleted.

See: DB_common::setOption()

[ Top ]

DB_PORTABILITY_ERRORS [line 221]

DB_PORTABILITY_ERRORS = 16

Portability: makes certain error messages in certain drivers compatible with those from other DBMS's.

mysql, mysqli: change unique/primary key constraints DB_ERROR_ALREADY_EXISTS -> DB_ERROR_CONSTRAINT

odbc(access): MS's ODBC driver reports 'no such field' as code 07001, which means 'too few parameters.' When this option is on that code gets mapped to DB_ERROR_NOSUCHFIELD.

See: DB_common::setOption()

[ Top ]

DB_PORTABILITY_LOWERCASE [line 188]

DB_PORTABILITY_LOWERCASE = 1

Portability: convert names of tables and fields to lower case when using the get*(), fetch*() and tableInfo() methods.

See: DB_common::setOption()

[ Top ]

DB_PORTABILITY_NONE [line 181]

DB_PORTABILITY_NONE = 0

Portability: turn off all portability features.

See: DB_common::setOption()

[ Top ]

DB_PORTABILITY_NULL_TO_EMPTY [line 228]

DB_PORTABILITY_NULL_TO_EMPTY = 32

Portability: convert null values to empty strings in data output by get*() and fetch*().

See: DB_common::setOption()

[ Top ]

DB_PORTABILITY_NUMROWS [line 206]

DB_PORTABILITY_NUMROWS = 8

Portability: enable hack that makes numRows() work in Oracle.

See: DB_common::setOption()

[ Top ]

DB_PORTABILITY_RTRIM [line 194]

DB_PORTABILITY_RTRIM = 2

Portability: right trim the data output by get*() and fetch*().

See: DB_common::setOption()

[ Top ]

DB_TABLEINFO_FULL [line 164]

DB_TABLEINFO_FULL = 3

[ Top ]

DB_TABLEINFO_ORDER [line 162]

DB_TABLEINFO_ORDER = 1

these are constants for the tableInfo-function

they are bitwised or'ed. so if there are more constants to be defined in the future, adjust DB_TABLEINFO_FULL accordingly

[ Top ]

DB_TABLEINFO_ORDERTABLE [line 163]

DB_TABLEINFO_ORDERTABLE = 2

[ Top ]