Public Member Functions | Protected Attributes

oxLegacyDb Class Reference

Inheritance diagram for oxLegacyDb:
Collaboration diagram for oxLegacyDb:

List of all members.

Public Member Functions

 setConnection ($oConnection)
 setFetchMode ($iFetchMode)
 getDb ($blType=true)
 getOne ($sSql, $aParams=false, $blType=true)
 getArray ($sSql, $aParams=false, $blType=true)
 getRow ($sSql, $aParams=false, $blType=true)
 getAll ($sSql, $aParams=false, $blType=true)
 select ($sSql, $aParams=false, $blType=true)
 getAssoc ($sSql, $aParams=false, $blType=true)
 getCol ($sSql, $aParams=false, $blType=true)
 selectLimit ($sSql, $iRows=-1, $iOffset=-1, $aParams=false, $blType=true)
 execute ($sSql, $aParams=false)
 query ($sSql, $aParams=false)
 Affected_Rows ()
 errorNo ()
 errorMsg ()
 qstr ($sValue)
 quote ($sValue)
 metaColumns ($sTable)
 metaColumnNames ($sTable, $blNumIndexes=false)
 startTransaction ()
 commitTransaction ()
 rollbackTransaction ()
 setTransactionIsolationLevel ($sLevel=null)
 UI ($iPollSecs=5)

Protected Attributes

 $_oDb = null

Detailed Description

Database connection class

Definition at line 7 of file oxlegacydb.php.


Member Function Documentation

oxLegacyDb.Affected_Rows (  ) 

Return count effected values

Returns:
int

Definition at line 202 of file oxlegacydb.php.

oxLegacyDb.commitTransaction (  ) 

Commit mysql transaction

Returns:
bool

Definition at line 291 of file oxlegacydb.php.

oxLegacyDb.errorMsg (  ) 

Return error message

Returns:
string

Definition at line 222 of file oxlegacydb.php.

oxLegacyDb.errorNo (  ) 

Return error number

Returns:
int

Definition at line 212 of file oxlegacydb.php.

oxLegacyDb.execute ( sSql,
aParams = false 
)

Execute query

Parameters:
string $sSql Query
array|bool $aParams Array of parameters
Returns:
object

Definition at line 179 of file oxlegacydb.php.

oxLegacyDb.getAll ( sSql,
aParams = false,
blType = true 
)

Get value

Parameters:
string $sSql Query
array|bool $aParams Array of parameters
bool $blType connection type
Returns:
array

Definition at line 107 of file oxlegacydb.php.

oxLegacyDb.getArray ( sSql,
aParams = false,
blType = true 
)

Get value

Parameters:
string $sSql Query
array|bool $aParams Array of parameters
bool $blType connection type
Returns:
array

Definition at line 79 of file oxlegacydb.php.

oxLegacyDb.getAssoc ( sSql,
aParams = false,
blType = true 
)

Get value

Parameters:
string $sSql Query
array|bool $aParams Array of parameters
bool $blType connection type
Returns:
array

Definition at line 136 of file oxlegacydb.php.

oxLegacyDb.getCol ( sSql,
aParams = false,
blType = true 
)

Get column value

Parameters:
string $sSql Query
array|bool $aParams Array of parameters
bool $blType connection type
Returns:
object

Definition at line 150 of file oxlegacydb.php.

oxLegacyDb.getDb ( blType = true  ) 

Return connection to db

Parameters:
bool $blType - connection type
Returns:
object

Definition at line 50 of file oxlegacydb.php.

oxLegacyDb.getOne ( sSql,
aParams = false,
blType = true 
)

Get value

Parameters:
string $sSql Query
array|bool $aParams Array of parameters
bool $blType connection type
Returns:
string

Definition at line 65 of file oxlegacydb.php.

oxLegacyDb.getRow ( sSql,
aParams = false,
blType = true 
)

Get value

Parameters:
string $sSql Query
array|bool $aParams Array of parameters
bool $blType connection type
Returns:
array

Definition at line 93 of file oxlegacydb.php.

oxLegacyDb.metaColumnNames ( sTable,
blNumIndexes = false 
)

return meta data

Parameters:
string $sTable Table name
bool $blNumIndexes Numeric indexes
Returns:
array

Definition at line 271 of file oxlegacydb.php.

oxLegacyDb.metaColumns ( sTable  ) 

return meta data

Parameters:
string $sTable Table name
Returns:
array

Definition at line 258 of file oxlegacydb.php.

oxLegacyDb.qstr ( sValue  ) 

Quote string

Parameters:
string $sValue value
Returns:
string

Definition at line 234 of file oxlegacydb.php.

oxLegacyDb.query ( sSql,
aParams = false 
)

Execute query

Parameters:
string $sSql Query
array|bool $aParams Array of parameters
Returns:
object

Definition at line 192 of file oxlegacydb.php.

oxLegacyDb.quote ( sValue  ) 

Quote string

Parameters:
string $sValue value
Returns:
string

Definition at line 246 of file oxlegacydb.php.

oxLegacyDb.rollbackTransaction (  ) 

RollBack mysql transaction

Returns:
bool

Definition at line 301 of file oxlegacydb.php.

oxLegacyDb.select ( sSql,
aParams = false,
blType = true 
)

Get value

Parameters:
string $sSql Query
array|bool $aParams Array of parameters
bool $blType connection type
Returns:
object

Definition at line 122 of file oxlegacydb.php.

oxLegacyDb.selectLimit ( sSql,
iRows = -1,
iOffset = -1,
aParams = false,
blType = true 
)

Get array

Parameters:
string $sSql Query
int $iRows Rows
int $iOffset Offset
array|bool $aParams Array of parameters
bool $blType connection type
Returns:
object

Definition at line 166 of file oxlegacydb.php.

oxLegacyDb.setConnection ( oConnection  ) 

Set connection

Parameters:
object $oConnection Connection
Returns:
null

Definition at line 25 of file oxlegacydb.php.

oxLegacyDb.setFetchMode ( iFetchMode  ) 

Set fetch mode to connection

Parameters:
int $iFetchMode Fetch mode
Returns:
null

Definition at line 37 of file oxlegacydb.php.

oxLegacyDb.setTransactionIsolationLevel ( sLevel = null  ) 

Set transaction isolation level Allowed values READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, SERIALIZABLE

Parameters:
string $sLevel level
Returns:
bool

Definition at line 314 of file oxlegacydb.php.

oxLegacyDb.startTransaction (  ) 

Start mysql transaction

Returns:
bool

Definition at line 281 of file oxlegacydb.php.

oxLegacyDb.UI ( iPollSecs = 5  ) 

Calls Db UI method

Parameters:
integer $iPollSecs poll seconds
Returns:
null

Definition at line 333 of file oxlegacydb.php.


Member Data Documentation

oxLegacyDb.$_oDb = null [protected]

Definition at line 15 of file oxlegacydb.php.


The documentation for this class was generated from the following file: