Docs For Class jDbPDOConnection

Description

A connection object based on PDO

Located in /db/jDbPDOConnection.class.php (line 104)

PDO
   |
   --jDbPDOConnection

Variable Summary

mixed $dbms

array $profile

Method Summary

jDbPDOConnection __construct ( $profile)

string encloseName (string $fieldName)

boolean hasTablePrefix ()

void lastIdInTable ( $fieldName, $tableName)

void limitQuery ( $queryString, [ $limitOffset = null], [ $limitCount = null])

string prefixTable ( $table_name, string $table)

void query ()

void setAutoCommit ([boolean $state = true])

Variables

mixed $dbms (line 118)

The database type name (mysql, pgsql ...)

access: public

array $profile (line 113)

the profile the connection is using

access: public

Methods

Constructor __construct (line 123)

Use a profile to do the connection

jDbPDOConnection __construct ( $profile)

$profile

Redefinition of:

PDO::constructor __construct ( $dsn, $username, $passwd, [$options = ] )

encloseName (line 244)

enclose the field name

return: the enclosed field name
since: 1.1.2
access: public

string encloseName (string $fieldName)

string $fieldName: the field name

hasTablePrefix (line 234)

Check if the current connection has a table prefix set

author: Julien Issler
since: 1.0
access: public

boolean hasTablePrefix ()

lastIdInTable (line 204)

access: public

void lastIdInTable ( $fieldName, $tableName)

$fieldName
$tableName

limitQuery (line 184)

access: public

void limitQuery ( $queryString, [ $limitOffset = null], [ $limitCount = null])

$queryString
$limitOffset
$limitCount

prefixTable (line 221)

Prefix the given table with the prefix specified in the connection's profile If there's no prefix for the connection's profile, return the table's name unchanged.

return: the prefixed table's name
author: Julien Issler
since: 1.0
access: public

string prefixTable ( $table_name, string $table)

string $table: the table's name
$table_name

query (line 164)

access: public

void query ()

Redefinition of:

PDO::query ( )

setAutoCommit (line 200)

sets the autocommit state

access: public

void setAutoCommit ([boolean $state = true])

boolean $state: state the status of autocommit

Inherited Methods

Inherited From PDO (Internal Class)

constructor __construct ( $dsn, $username, $passwd, [$options = ] )
beginTransaction ( )
commit ( )
errorCode ( )
errorInfo ( )
exec ( $query )
getAttribute ( $attribute )
getAvailableDrivers ( )
inTransaction ( )
lastInsertId ( [$seqname = ] )
prepare ( $statment, [$options = ] )
query ( )
quote ( $string, [$paramtype = ] )
rollBack ( )
setAttribute ( $attribute, $value )
__sleep ( )
__wakeup ( )

Class Constants

Inherited Constants

Inherited from PDO (Internal Class)

ATTR_AUTOCOMMIT = 0
ATTR_CASE = 8
ATTR_CLIENT_VERSION = 5
ATTR_CONNECTION_STATUS = 7
ATTR_CURSOR = 10
ATTR_CURSOR_NAME = 9
ATTR_DEFAULT_FETCH_MODE = 19
ATTR_DRIVER_NAME = 16
ATTR_EMULATE_PREPARES = 20
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
ERRMODE_EXCEPTION = 2
ERRMODE_SILENT = 0
ERRMODE_WARNING = 1
ERR_NONE = '00000'
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_KEY_PAIR = 12
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_PROPS_LATE = 1048576
FETCH_SERIALIZE = 524288
FETCH_UNIQUE = 196608
MYSQL_ATTR_COMPRESS = 1006
MYSQL_ATTR_DIRECT_QUERY = 1007
MYSQL_ATTR_FOUND_ROWS = 1008
MYSQL_ATTR_IGNORE_SPACE = 1009
MYSQL_ATTR_INIT_COMMAND = 1002
MYSQL_ATTR_LOCAL_INFILE = 1001
MYSQL_ATTR_MAX_BUFFER_SIZE = 1005
MYSQL_ATTR_READ_DEFAULT_FILE = 1003
MYSQL_ATTR_READ_DEFAULT_GROUP = 1004
MYSQL_ATTR_USE_BUFFERED_QUERY = 1000
NULL_EMPTY_STRING = 1
NULL_NATURAL = 0
NULL_TO_STRING = 2
PARAM_BOOL = 5
PARAM_EVT_ALLOC = 0
PARAM_EVT_EXEC_POST = 3
PARAM_EVT_EXEC_PRE = 2
PARAM_EVT_FETCH_POST = 5
PARAM_EVT_FETCH_PRE = 4
PARAM_EVT_FREE = 1
PARAM_EVT_NORMALIZE = 6
PARAM_INPUT_OUTPUT = 2147483648
PARAM_INT = 1
PARAM_LOB = 3
PARAM_NULL = 0
PARAM_STMT = 4
PARAM_STR = 2
PGSQL_ATTR_DISABLE_NATIVE_PREPARED_STATEMENT = 1000
PGSQL_TRANSACTION_ACTIVE = 1
PGSQL_TRANSACTION_IDLE = 0
PGSQL_TRANSACTION_INERROR = 3
PGSQL_TRANSACTION_INTRANS = 2
PGSQL_TRANSACTION_UNKNOWN = 4