Class jDbPDOConnection

Description
Description | Vars (details) | Methods (details) Constants

A connection object based on PDO

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

PDO
   |
   --jDbPDOConnection
Variable Summary
Description | Vars (details) | Methods (details) Constants
string $dbms
string $driverName
array $profile
jDbTools $_tools
Method Summary
Description | Constants Vars (details) | Methods (details)
jDbPDOConnection __construct (array $profile)
string encloseName (string $fieldName)
void exec ( $query)
boolean hasTablePrefix ()
integer lastIdInTable (string $fieldName, string $tableName)
string lastInsertId ([string $fromSequence = null])
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
Description | Vars (details) Constants | Methods (details)
string $dbms (line 35)

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

  • access: public
string $driverName = '' (line 41)

driver name

  • access: public
array $profile (line 29)

the profile the connection is using

  • access: public
jDbTools $_tools = null (line 264)
  • access: protected
Methods
Description | Vars (details) Constants Methods (details)
Constructor __construct (line 47)

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

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 151)
  • access: public
void exec ( $query)
  • $query
Redefinition of:
PDO::exec ( $query )
hasTablePrefix (line 227)

Check if the current connection has a table prefix set

  • author: Julien Issler
  • since: 1.0
  • access: public
boolean hasTablePrefix ()
lastIdInTable (line 197)

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
lastInsertId (line 287)

Get the ID of the last inserted row Mssql pdo driver does not support this feature.

so, we use a custom query

  • access: public
string lastInsertId ([string $fromSequence = null])
  • string $fromSequence: the sequence name, if needed
Redefinition of:
PDO::lastInsertId ( [$seqname = ] )
limitQuery (line 166)

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

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 123)
  • access: public
void query ()
Redefinition of:
PDO::query ( )
quote2 (line 254)

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

sets the autocommit state

  • access: public
void setAutoCommit ([boolean $state = true])
  • boolean $state: the status of autocommit
tools (line 269)
  • 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 ( )
inTransaction ( )
lastInsertId ( [$seqname = ] )
prepare ( $statement, [$options = ] )
query ( )
quote ( $string, [$paramtype = ] )
rollBack ( )
setAttribute ( $attribute, $value )
__sleep ( )
__wakeup ( )
Class Constants
Description | Constants (details) Vars (details) | Methods (details)

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_SSL_CA = 1012
 MYSQL_ATTR_SSL_CAPATH = 1013
 MYSQL_ATTR_SSL_CERT = 1011
 MYSQL_ATTR_SSL_CIPHER = 1014
 MYSQL_ATTR_SSL_KEY = 1010
 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

Documentation generated on Mon, 26 Oct 2015 21:53:16 +0100 by phpDocumentor 1.4.3