Docs For Class jDbPDOConnection

Description

A connection object based on PDO

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

PDO
   |
   --jDbPDOConnection

Class Constant Summary

JPDO_ATTR_AUTOCOMMIT = 0

JPDO_ATTR_CASE = 8

JPDO_ATTR_CURSOR = 10

JPDO_ATTR_ERRMODE = 3

JPDO_ATTR_STATEMENT_CLASS = 13

JPDO_CASE_LOWER = 2

JPDO_CURSOR_SCROLL = 1

JPDO_ERRMODE_EXCEPTION = 2

JPDO_FETCH_CLASS = 8

JPDO_FETCH_COLUMN = 7

JPDO_FETCH_OBJ = 5

JPDO_FETCH_ORI_FIRST = 2

JPDO_FETCH_ORI_NEXT = 0

JPDO_MYSQL_ATTR_USE_BUFFERED_QUERY = 1000

Variable Summary

mixed $dbms

array $profil

Method Summary

boolean hasTablePrefix ()

jDbPDOConnection __construct ( $profil)

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

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

access: public

array $profil (line 98)

the profil the connection is using

access: public

Methods

hasTablePrefix (line 219)

Check if the current connection has a table prefix set

author: Julien Issler
since: 1.0
access: public

boolean hasTablePrefix ()

Constructor __construct (line 108)

Use a profil to do the connection

jDbPDOConnection __construct ( $profil)

$profil

Redefinition of:

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

lastIdInTable (line 189)

access: public

void lastIdInTable ( $fieldName, $tableName)

$fieldName
$tableName

limitQuery (line 169)

access: public

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

$queryString
$limitOffset
$limitCount

prefixTable (line 206)

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

access: public

void query ()

Redefinition of:

PDO::query ( )

setAutoCommit (line 185)

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 ( )
lastInsertId ( [$seqname = ] )
prepare ( $statment, [$options = ] )
query ( )
quote ( $string, [$paramtype = ] )
rollBack ( )
setAttribute ( $attribute, $value )
__sleep ( )
__wakeup ( )

Class Constants

JPDO_ATTR_AUTOCOMMIT = 0 (line 82)

JPDO_ATTR_CASE = 8 (line 88)

JPDO_ATTR_CURSOR = 10 (line 83)

JPDO_ATTR_ERRMODE = 3 (line 85)

JPDO_ATTR_STATEMENT_CLASS = 13 (line 81)

JPDO_CASE_LOWER = 2 (line 89)

JPDO_CURSOR_SCROLL = 1 (line 84)

JPDO_ERRMODE_EXCEPTION = 2 (line 86)

JPDO_FETCH_CLASS = 8 (line 80)

JPDO_FETCH_COLUMN = 7 (line 79)

JPDO_FETCH_OBJ = 5 (line 76)

PDO constant name have been change between php 5.0 and 5.1. So we use our own constant.

link: http://lxr.php.net/source/php-src/ext/pdo/php_pdo_driver.h
since: 1.0

JPDO_FETCH_ORI_FIRST = 2 (line 78)

JPDO_FETCH_ORI_NEXT = 0 (line 77)

JPDO_MYSQL_ATTR_USE_BUFFERED_QUERY = 1000 (line 87)

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_DIRECT_QUERY = 1006
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