Inheritance diagram for oxLegacyDb:

Collaboration diagram for oxLegacyDb:

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)
Public Member Functions inherited from oxSuperCfg
	__call ($sMethod, $aArgs)
	__construct ()
	getConfig ()
	setConfig ($oConfig)
	getSession ()
	setSession ($oSession)
	getUser ()
	setUser ($oUser)
	isAdmin ()
	setAdminMode ($blAdmin)

Protected Attributes
	$_oDb = null

Additional Inherited Members
Static Protected Attributes inherited from oxSuperCfg
static	$_oConfig = null
static	$_oSession = null
static	$_oRights = null
static	$_oActUser = null
static	$_blIsAdmin = 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:

core/oxlegacydb.php

Public Member Functions

Protected Attributes

Additional Inherited Members

Detailed Description

Member Function Documentation

Member Data Documentation