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)

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 203 of file oxlegacydb.php.

oxLegacyDb.commitTransaction (  ) 

Commit mysql transaction

Returns:
null

Definition at line 292 of file oxlegacydb.php.

oxLegacyDb.errorMsg (  ) 

Return error message

Returns:
int

Definition at line 223 of file oxlegacydb.php.

oxLegacyDb.errorNo (  ) 

Return error number

Returns:
int

Definition at line 213 of file oxlegacydb.php.

oxLegacyDb.execute ( sSql,
aParams = false 
)

Execute query

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

Definition at line 180 of file oxlegacydb.php.

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

Get value

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

Definition at line 108 of file oxlegacydb.php.

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

Get value

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

Definition at line 80 of file oxlegacydb.php.

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

Get value

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

Definition at line 137 of file oxlegacydb.php.

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

Get column value

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

Definition at line 151 of file oxlegacydb.php.

oxLegacyDb.getDb ( blType = true  ) 

Return conection to db

Parameters:
bool $blType - connection type
Returns:
object

Definition at line 51 of file oxlegacydb.php.

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

Get value

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

Definition at line 66 of file oxlegacydb.php.

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

Get value

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

Definition at line 94 of file oxlegacydb.php.

oxLegacyDb.metaColumnNames ( sTable,
blNumIndexes = false 
)

return meta data

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

Definition at line 272 of file oxlegacydb.php.

oxLegacyDb.metaColumns ( sTable  ) 

return meta data

Parameters:
string $sTable Table name
Returns:
object

Definition at line 259 of file oxlegacydb.php.

oxLegacyDb.qstr ( sValue  ) 

Quote string

Parameters:
string $sValue value
Returns:
object

Definition at line 235 of file oxlegacydb.php.

oxLegacyDb.query ( sSql,
aParams = false 
)

Execute query

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

Definition at line 193 of file oxlegacydb.php.

oxLegacyDb.quote ( sValue  ) 

Quote string

Parameters:
string $sValue value
Returns:
object

Definition at line 247 of file oxlegacydb.php.

oxLegacyDb.rollbackTransaction (  ) 

RollBack mysql transaction

Returns:
null

Definition at line 302 of file oxlegacydb.php.

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

Get value

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

Definition at line 123 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 $aParams Array of parameters
bool $blType connection type
Returns:
object

Definition at line 167 of file oxlegacydb.php.

oxLegacyDb.setConnection ( oConnection  ) 

Set slave connect

Parameters:
object $oConnection Connection
Returns:
null

Definition at line 26 of file oxlegacydb.php.

oxLegacyDb.setFetchMode ( iFetchMode  ) 

Set fetch mode to connection

Parameters:
int $iFetchMode Fetch mode
Returns:
null

Definition at line 38 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:
null

Definition at line 315 of file oxlegacydb.php.

oxLegacyDb.startTransaction (  ) 

Start mysql transaction

Returns:
null

Definition at line 282 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: