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)
	quoteArray ($aStrArray)
	metaColumns ($sTable)
	metaColumnNames ($sTable, $blNumIndexes=false)
	startTransaction ()
	commitTransaction ()
	rollbackTransaction ()
	setTransactionIsolationLevel ($sLevel=null)
	UI ($iPollSecs=5)
	Insert_ID ()
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 200 of file oxlegacydb.php.

oxLegacyDb::commitTransaction ( )

Commit mysql transaction

Returns: bool

Definition at line 305 of file oxlegacydb.php.

oxLegacyDb::errorMsg ( )

Return error message

Returns: string

Definition at line 220 of file oxlegacydb.php.

oxLegacyDb::errorNo ( )

Return error number

Returns: int

Definition at line 210 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 177 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 105 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 77 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 134 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 148 of file oxlegacydb.php.

oxLegacyDb::getDb ( $blType = true )

Return connection to db

Parameters

bool $blType - connection type

Deprecated:: since v5.3 (2016-02-25); Do not use this method at all, we want this class to be the only database access possibility.

Returns: object

Definition at line 48 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 63 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 91 of file oxlegacydb.php.

oxLegacyDb::Insert_ID ( )

Returns last insert ID

Returns: int

Definition at line 355 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 285 of file oxlegacydb.php.

oxLegacyDb::metaColumns ( $sTable )

return meta data

Parameters

string $sTable Table name

Returns: array

Definition at line 272 of file oxlegacydb.php.

oxLegacyDb::qstr ( $sValue )

Quote string

Parameters

string $sValue value

Returns: string

Definition at line 232 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 190 of file oxlegacydb.php.

oxLegacyDb::quote ( $sValue )

Quote string

Parameters

string $sValue value

Returns: string

Definition at line 244 of file oxlegacydb.php.

oxLegacyDb::quoteArray ( $aStrArray )

Quotes an array.

Parameters

array $aStrArray array of strings to quote

Returns: array

Definition at line 256 of file oxlegacydb.php.

oxLegacyDb::rollbackTransaction ( )

RollBack mysql transaction

Returns: bool

Definition at line 315 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 120 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 164 of file oxlegacydb.php.

oxLegacyDb::setConnection ( $oConnection )

Set connection

Parameters

object $oConnection Connection

Definition at line 23 of file oxlegacydb.php.

oxLegacyDb::setFetchMode ( $iFetchMode )

Set fetch mode to connection

Parameters

int $iFetchMode Fetch mode

Definition at line 33 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 328 of file oxlegacydb.php.

oxLegacyDb::startTransaction ( )

Start mysql transaction

Returns: bool

Definition at line 295 of file oxlegacydb.php.

oxLegacyDb::UI ( $iPollSecs = 5 )

Calls Db UI method

Parameters

integer $iPollSecs poll seconds

Definition at line 345 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