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

oxLegacyDb.commitTransaction

(

)

Commit mysql transaction

Returns:

bool

Definition at line 303 of file oxlegacydb.php.

oxLegacyDb.errorMsg

(

)

Return error message

Returns:

string

Definition at line 218 of file oxlegacydb.php.

oxLegacyDb.errorNo

(

)

Return error number

Returns:

int

Definition at line 208 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 175 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 103 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 75 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 132 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 146 of file oxlegacydb.php.

oxLegacyDb.getDb

(

$

blType = true

)

Return connection to db

Parameters:

bool

$blType - connection type

Returns:

object

Definition at line 46 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 61 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 89 of file oxlegacydb.php.

oxLegacyDb.Insert_ID

(

)

Returns last insert ID

Returns:

int

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

oxLegacyDb.metaColumns

(

$

sTable

)

return meta data

Parameters:

string

$sTable Table name

Returns:

array

Definition at line 270 of file oxlegacydb.php.

oxLegacyDb.qstr

(

$

sValue

)

Quote string

Parameters:

string

$sValue value

Returns:

string

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

oxLegacyDb.quote

(

$

sValue

)

Quote string

Parameters:

string

$sValue value

Returns:

string

Definition at line 242 of file oxlegacydb.php.

oxLegacyDb.quoteArray

(

$

aStrArray

)

Quotes an array.

Parameters:

array

$aStrArray array of strings to quote

Returns:

array

Definition at line 254 of file oxlegacydb.php.

oxLegacyDb.rollbackTransaction

(

)

RollBack mysql transaction

Returns:

bool

Definition at line 313 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 118 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 162 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 326 of file oxlegacydb.php.

oxLegacyDb.startTransaction

(

)

Start mysql transaction

Returns:

bool

Definition at line 293 of file oxlegacydb.php.

oxLegacyDb.UI

(

$

iPollSecs = 5

)

Calls Db UI method

Parameters:

integer

$iPollSecs poll seconds

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