OXID eShop CE  4.9.7
 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)
 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 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$sSqlQuery
array | bool$aParamsArray of parameters
Returns
object

Definition at line 175 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 103 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 75 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 132 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 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$sSqlQuery
array | bool$aParamsArray of parameters
bool$blTypeconnection type
Returns
string

Definition at line 61 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 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$sTableTable name
bool$blNumIndexesNumeric indexes
Returns
array

Definition at line 283 of file oxlegacydb.php.

oxLegacyDb::metaColumns (   $sTable)

return meta data

Parameters
string$sTableTable name
Returns
array

Definition at line 270 of file oxlegacydb.php.

oxLegacyDb::qstr (   $sValue)

Quote string

Parameters
string$sValuevalue
Returns
string

Definition at line 230 of file oxlegacydb.php.

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

Execute query

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

Definition at line 188 of file oxlegacydb.php.

oxLegacyDb::quote (   $sValue)

Quote string

Parameters
string$sValuevalue
Returns
string

Definition at line 242 of file oxlegacydb.php.

oxLegacyDb::quoteArray (   $aStrArray)

Quotes an array.

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

Definition at line 162 of file oxlegacydb.php.

oxLegacyDb::setConnection (   $oConnection)

Set connection

Parameters
object$oConnectionConnection

Definition at line 23 of file oxlegacydb.php.

oxLegacyDb::setFetchMode (   $iFetchMode)

Set fetch mode to connection

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