OXID eShop CE  4.8.10
 All Classes Files Functions Variables Pages
oxLegacyDb Class Reference
+ 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$sSqlQuery
array | bool$aParamsArray of parameters
Returns
object

Definition at line 179 of file oxlegacydb.php.

oxLegacyDb::getAll (   $sSql,
  $aParams = false,
  $blType = true 
)

Get value

Parameters
string$sSqlQuery
array | bool$aParamsArray of parameters
bool$blTypeconnection type
Returns
array

Definition at line 107 of file oxlegacydb.php.

oxLegacyDb::getArray (   $sSql,
  $aParams = false,
  $blType = true 
)

Get value

Parameters
string$sSqlQuery
array | bool$aParamsArray of parameters
bool$blTypeconnection type
Returns
array

Definition at line 79 of file oxlegacydb.php.

oxLegacyDb::getAssoc (   $sSql,
  $aParams = false,
  $blType = true 
)

Get value

Parameters
string$sSqlQuery
array | bool$aParamsArray of parameters
bool$blTypeconnection type
Returns
array

Definition at line 136 of file oxlegacydb.php.

oxLegacyDb::getCol (   $sSql,
  $aParams = false,
  $blType = true 
)

Get column value

Parameters
string$sSqlQuery
array | bool$aParamsArray of parameters
bool$blTypeconnection 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$sSqlQuery
array | bool$aParamsArray of parameters
bool$blTypeconnection type
Returns
string

Definition at line 65 of file oxlegacydb.php.

oxLegacyDb::getRow (   $sSql,
  $aParams = false,
  $blType = true 
)

Get value

Parameters
string$sSqlQuery
array | bool$aParamsArray of parameters
bool$blTypeconnection type
Returns
array

Definition at line 93 of file oxlegacydb.php.

oxLegacyDb::metaColumnNames (   $sTable,
  $blNumIndexes = false 
)

return meta data

Parameters
string$sTableTable name
bool$blNumIndexesNumeric indexes
Returns
array

Definition at line 271 of file oxlegacydb.php.

oxLegacyDb::metaColumns (   $sTable)

return meta data

Parameters
string$sTableTable name
Returns
array

Definition at line 258 of file oxlegacydb.php.

oxLegacyDb::qstr (   $sValue)

Quote string

Parameters
string$sValuevalue
Returns
string

Definition at line 234 of file oxlegacydb.php.

oxLegacyDb::query (   $sSql,
  $aParams = false 
)

Execute query

Parameters
string$sSqlQuery
array | bool$aParamsArray of parameters
Returns
object

Definition at line 192 of file oxlegacydb.php.

oxLegacyDb::quote (   $sValue)

Quote string

Parameters
string$sValuevalue
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$sSqlQuery
array | bool$aParamsArray of parameters
bool$blTypeconnection 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$sSqlQuery
int$iRowsRows
int$iOffsetOffset
array | bool$aParamsArray of parameters
bool$blTypeconnection type
Returns
object

Definition at line 166 of file oxlegacydb.php.

oxLegacyDb::setConnection (   $oConnection)

Set connection

Parameters
object$oConnectionConnection
Returns
null

Definition at line 25 of file oxlegacydb.php.

oxLegacyDb::setFetchMode (   $iFetchMode)

Set fetch mode to connection

Parameters
int$iFetchModeFetch 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$sLevellevel
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$iPollSecspoll 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: