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:

• core/oxlegacydb.php