Properties

$dependencies

$dependencies : 

Type

$shortcuts

$shortcuts : 

Type

$singleton

$singleton : 

Type

$class_hash

$class_hash : 

Type

$resConnection

$resConnection : 

Type

$blnDisableAutocommit

$blnDisableAutocommit : 

Type

$strTmpPrefix

$strTmpPrefix : 

Type

$strTablePrefix

$strTablePrefix : 

Type

$strDebugPrefix

$strDebugPrefix : 

Type

$strCharset

$strCharset : 

Type

$strDatabase

$strDatabase : 

Type

$strError

$strError : 

Type

$intErrno

$intErrno : 

Type

$intQueryCount

$intQueryCount : 

Type

$_shorts

$_shorts : 

Type

$_shorts_loaded

$_shorts_loaded : 

Type

$_class_index

$_class_index : 

Type

$objLogger

$objLogger : 

Type

$blnInConstruct

$blnInConstruct : 

Type

Methods

__get()

__get(  $strKey) : string|null

Return an object property

Parameters

$strKey

Returns

string|null

__isset()

__isset(  $name) 

Parameters

$name

__dependencies()

__dependencies() 

__shortcuts()

__shortcuts() 

__destruct()

__destruct() 

Close the database connection

__construct()

__construct(  $arrOptions = array()) 

Parameters

$arrOptions

pdl_html_format_sql_error()

pdl_html_format_sql_error(  $log_entry) 

Parameters

$log_entry

pdl_pt_format_sql_error()

pdl_pt_format_sql_error(  $log_entry) 

Parameters

$log_entry

clean_errormessage()

clean_errormessage(  $strErrorMessage) 

Parameters

$strErrorMessage

highlight()

highlight(  $sql) 

Parameters

$sql

pdl_html_format_sql_query()

pdl_html_format_sql_query(  $log_entry) 

Parameters

$log_entry

prepare()

prepare(  $strQuery) : \Database_Statement

Prepare a statement (return a Database_Statement object)

Parameters

$strQuery

Returns

\Database_Statement

execute()

execute(  $strQuery) : \Database_Result

Execute a query (return a Database_Result object)

Parameters

$strQuery

Returns

\Database_Result

query()

query(  $strQuery,   $blnGetFirstRow = false) : \Database_Result

Execute a raw query (return a Database_Result object)

Parameters

$strQuery
$blnGetFirstRow

Returns

\Database_Result

checkQuery()

checkQuery(  $strQuery) : boolean

Checks if a Query is executed or not

Parameters

$strQuery

Returns

boolean

listTables()

listTables(  $strDatabase = null) : array

Return all columns of a particular table as array

Parameters

$strDatabase

Returns

array

tableExists()

tableExists(  $strTable,   $strDatabase = null) : boolean

Determine if a particular database table exists

Parameters

$strTable
$strDatabase

Returns

boolean

listFields()

listFields(  $strTable) : array

Return all columns of a particular table as array

Parameters

$strTable

Returns

array

fieldInformation()

fieldInformation(  $strTable) 

Parameters

$strTable

fieldExists()

fieldExists(  $strField,   $strTable) : boolean

Determine if a particular column exists

Parameters

$strField
$strTable

Returns

boolean

getFieldNames()

getFieldNames(  $strTable) : array

Return the field names of a particular table as array

Parameters

$strTable

Returns

array

setDatabase()

setDatabase(  $strDatabase = false) : boolean

Change the current database

Parameters

$strDatabase

Returns

boolean

setPrefix()

setPrefix(  $strPrefix) 

Parameters

$strPrefix

resetPrefix()

resetPrefix() 

beginTransaction()

beginTransaction() 

Begin a transaction

commitTransaction()

commitTransaction() 

Commit a transaction

rollbackTransaction()

rollbackTransaction() 

Rollback a transaction

getSizeOf()

getSizeOf(  $strTable) : integer

Return the table size in bytes

Parameters

$strTable

Returns

integer

getNextId()

getNextId(  $strTable) : integer

Return the next autoincrement ID of a table

Parameters

$strTable

Returns

integer

showCreateTable()

showCreateTable(  $strTable) 

Parameters

$strTable

isEQdkpTable()

isEQdkpTable(  $strTable) 

Parameters

$strTable

escapeString()

escapeString(  $strString) 

Parameters

$strString

connect()

connect(  $strHost,   $strUser,   $strPassword,   $strDatabase,   $intPort = false,   $blnPersistent = false) 

Parameters

$strHost
$strUser
$strPassword
$strDatabase
$intPort
$blnPersistent

error()

error(  $strErrorMessage,   $strQuery,   $strErrorCode = '') 

Parameters

$strErrorMessage
$strQuery
$strErrorCode

disconnect()

disconnect() 

get_client_version()

get_client_version() 

get_server_version()

get_server_version() 

get_error()

get_error() 

get_connerror()

get_connerror() 

begin_transaction()

begin_transaction() 

commit_transaction()

commit_transaction() 

rollback_transaction()

rollback_transaction() 

list_fields()

list_fields(  $strTable) 

Parameters

$strTable

field_information()

field_information(  $strTable) 

Parameters

$strTable

set_database()

set_database(  $strDatabase) 

Parameters

$strDatabase

get_size_of()

get_size_of(  $strTable) 

Parameters

$strTable

get_next_id()

get_next_id(  $strTable) 

Parameters

$strTable

createStatement()

createStatement(  $resConnection,   $strTablePrefix,   $strDebugPrefix,   $blnDisableAutocommit) 

Parameters

$resConnection
$strTablePrefix
$strDebugPrefix
$blnDisableAutocommit

show_create_table()

show_create_table(  $strTable) 

Parameters

$strTable