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 ($pollsecs=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 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.

oxLegacyDb.UI

(

$

pollsecs = 5

)

Calls Db UI method

Parameters:

type

$pollsecs poll seconds

Returns:

null

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