Docs For Class jDbPDOConnection

Description

A connection object based on PDO

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

PDO
   |
   --jDbPDOConnection

Variable Summary

string $dbms

array $profile

jDbTools $_tools

Method Summary

jDbPDOConnection __construct (array $profile)

string encloseName (string $fieldName)

void exec ( $query)

boolean hasTablePrefix ()

integer lastIdInTable (string $fieldName, string $tableName)

jDbPDOResultSet|boolean limitQuery (string $queryString, [integer $limitOffset = null], [integer $limitCount = null])

string prefixTable ( $table_name, string $table)

void query ()

string quote2 (string $text, [boolean $checknull = true], [boolean $binary = false])

void setAutoCommit ([boolean $state = true])

jDbTools tools ()

Variables

string $dbms (line 34)

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

access: public

array $profile (line 28)

the profile the connection is using

access: public

jDbTools $_tools = null (line 256)

access: protected

Methods

Constructor __construct (line 40)

Use a profile to do the connection

jDbPDOConnection __construct (array $profile)

array $profile: the profile data readed from the ini file

Redefinition of:

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

encloseName (line 229)

enclose the field name

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

string encloseName (string $fieldName)

string $fieldName: the field name

exec (line 143)

access: public

void exec ( $query)

$query

Redefinition of:

PDO::exec ( $query )

hasTablePrefix (line 219)

Check if the current connection has a table prefix set

author: Julien Issler
since: 1.0
access: public

boolean hasTablePrefix ()

lastIdInTable (line 189)

return the maximum value of the given primary key in a table

return: the maximum value
access: public

integer lastIdInTable (string $fieldName, string $tableName)

string $fieldName: the name of the primary key
string $tableName: the name of the table

limitQuery (line 158)

Launch a SQL Query with limit parameter (so only a subset of a result)

return: SQL Select. False if the query has failed.
access: public

jDbPDOResultSet|boolean limitQuery (string $queryString, [integer $limitOffset = null], [integer $limitCount = null])

string $queryString: the SQL query
integer $limitOffset: the offset of the first row to return
integer $limitCount: the maximum of number of rows to return

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

access: public

void query ()

Redefinition of:

PDO::query ( )

quote2 (line 246)

Escape and quotes strings. if null, will only return the text "NULL"

return: escaped string
todo: $binary parameter is not really supported, check if PDOConnection::quote supports binary strings
since: 1.2
access: public

string quote2 (string $text, [boolean $checknull = true], [boolean $binary = false])

string $text: string to quote
boolean $checknull: if true, check if $text is a null value, and then return NULL
boolean $binary: set to true if $text contains a binary string

setAutoCommit (line 179)

sets the autocommit state

access: public

void setAutoCommit ([boolean $state = true])

boolean $state: the status of autocommit

tools (line 261)

access: public

jDbTools tools ()

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

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