Database_Driver_Oracle

Description

Oracle Database Driver NOTE: This driver is not in use and is still being tested thus no documentation was done for it just yet.

  • author: Raymond Benc
  • version: $Id: oracle.class.php 1687 2010-07-22 03:13:27Z Raymond_Benc $
  • copyright: [PHPFOX_COPYRIGHT]

Located in /include/library/phpfox/database/driver/oracle.class.php (line 17)


	
			
Variable Summary
 mixed $_hMaster
 mixed $_hSlave
 mixed $_sIsSlave
 mixed $_sLastQuery
Method Summary
 void affectedRows ()
 void connect ( $sHost,  $sUser,  $sPass,  $sName, [ $sPort = false], [ $sPersistent = false])
 void delete (string $sTable, string $sQuery)
 void dropTables ( $aDrops, [ $aVals = array()])
 mixed escape (mixed $mParam)
 void execute ( $sType, [ $aParams = array()])
 void freeResult ()
 void from ( $sTable, [ $sAlias = ''])
 mixed getField (string $sSql)
 int getLastId ()
 void getResource ()
 void getRow ( $sSql, [ $bAssoc = true])
 void getRows ( $sSql, [ $bAssoc = true])
 void getServerInfo ()
 mixed getSlaveField (string $sSql)
 void getSlaveRow ( $sSql, [ $bAssoc = true])
 void getSlaveRows ( $sSql, [ $bAssoc = true])
 void getVersion ()
 void group ( $sGroup)
 void having ( $sHaving)
 void innerJoin ( $sTable,  $sAlias, [ $mParam = null])
 void join ( $sTable,  $sAlias, [ $mParam = null])
 void leftJoin ( $sTable,  $sAlias, [ $mParam = null])
 void limit ( $iPage, [ $sLimit = null], [ $iCnt = null])
 void multiInsert ( $sTable,  $aFields,  $aValues)
 void order ( $sOrder)
 int query (string $sSql, [ &$hLink = ''])
 void search ( $sType,  $mFields,  $sSearch)
 void select ( $sSelect)
 void sqlReport ( $query)
 void where ( $aConds)
 void _connect ( $sHost,  $sUser,  $sPass, [ $sPort = false], [ $sPersistent = false])
 mixed _getField (string $sSql,  &$hLink)
 array _getRow (string $sSql, string $bAssoc,  &$hLink)
 array _getRows (string $sSql, [string $bAssoc = true],  &$hLink)
 void _insert ( $sTable,  $sFields,  $sValues)
 void _join ( $sType,  $sTable,  $sAlias, [ $mParam = null])
 void _sqlError ()
 void _update ( $sTable,  $sSets,  $sCond)
Variables
mixed $sSlaveServer (line 19)
  • access: public
mixed $_hMaster = null (line 20)
  • access: private
mixed $_hSlave = null (line 21)
  • access: private
mixed $_sIsSlave = '' (line 22)
  • access: private
mixed $_sLastQuery (line 23)
  • access: private
Methods
affectedRows (line 278)
  • access: public
void affectedRows ()
connect (line 25)
  • access: public
void connect ( $sHost,  $sUser,  $sPass,  $sName, [ $sPort = false], [ $sPersistent = false])
  • $sHost
  • $sUser
  • $sPass
  • $sName
  • $sPort
  • $sPersistent
delete (line 207)

Delete entry from the database

  • access: public
void delete (string $sTable, string $sQuery)
  • string $sTable: is the table name
  • string $sQuery: is the query we will run
dropTables (line 541)
  • access: public
void dropTables ( $aDrops, [ $aVals = array()])
  • $aDrops
  • $aVals
escape (line 170)

Prepares string to store in db (performs addslashes() )

  • return: escaped string or array of escaped strings
  • access: public
mixed escape (mixed $mParam)
  • mixed $mParam: string or array of string need to be escaped
execute (line 395)
  • access: public
void execute ( $sType, [ $aParams = array()])
  • $sType
  • $aParams
freeResult (line 270)
  • access: public
void freeResult ()
from (line 327)
  • access: public
void from ( $sTable, [ $sAlias = ''])
  • $sTable
  • $sAlias
getField (line 158)

Returns one field from a row

  • return: field value
  • access: public
mixed getField (string $sSql)
  • string $sSql: SQL query
getLastId (line 218)

Returns row id from last executed query

  • return: id of last INSERT operation
  • access: public
int getLastId ()
getResource (line 74)
  • access: public
void getResource ()
getRow (line 142)
  • access: public
void getRow ( $sSql, [ $bAssoc = true])
  • $sSql
  • $bAssoc
getRows (line 147)
  • access: public
void getRows ( $sSql, [ $bAssoc = true])
  • $sSql
  • $bAssoc
getServerInfo (line 69)
  • access: public
void getServerInfo ()
getSlaveField (line 121)

Returns one field from a row

  • return: field value
  • access: public
mixed getSlaveField (string $sSql)
  • string $sSql: SQL query
getSlaveRow (line 128)
  • access: public
void getSlaveRow ( $sSql, [ $bAssoc = true])
  • $sSql
  • $bAssoc
getSlaveRows (line 135)
  • access: public
void getSlaveRows ( $sSql, [ $bAssoc = true])
  • $sSql
  • $bAssoc
getVersion (line 64)
  • access: public
void getVersion ()
group (line 344)
  • access: public
void group ( $sGroup)
  • $sGroup
having (line 351)
  • access: public
void having ( $sHaving)
  • $sHaving
innerJoin (line 365)
  • access: public
void innerJoin ( $sTable,  $sAlias, [ $mParam = null])
  • $sTable
  • $sAlias
  • $mParam
join (line 372)
  • access: public
void join ( $sTable,  $sAlias, [ $mParam = null])
  • $sTable
  • $sAlias
  • $mParam
leftJoin (line 358)
  • access: public
void leftJoin ( $sTable,  $sAlias, [ $mParam = null])
  • $sTable
  • $sAlias
  • $mParam
limit (line 379)
  • access: public
void limit ( $iPage, [ $sLimit = null], [ $iCnt = null])
  • $iPage
  • $sLimit
  • $iCnt
multiInsert (line 187)
  • access: public
void multiInsert ( $sTable,  $aFields,  $aValues)
  • $sTable
  • $aFields
  • $aValues
order (line 334)
  • access: public
void order ( $sOrder)
  • $sOrder
query (line 87)

Performs sql query with error reporting and logging.

  • return: query result handle
  • todo: Debug debug backtrace
  • access: public
int query (string $sSql, [ &$hLink = ''])
  • string $sSql: query string
  • &$hLink
search (line 283)
  • access: public
void search ( $sType,  $mFields,  $sSearch)
  • $sType
  • $mFields
  • $sSearch
select (line 293)
  • access: public
void select ( $sSelect)
  • $sSelect
sqlReport (line 474)
  • access: public
void sqlReport ( $query)
  • $query
where (line 305)
  • access: public
void where ( $aConds)
  • $aConds
_connect (line 676)
  • access: private
void _connect ( $sHost,  $sUser,  $sPass, [ $sPort = false], [ $sPersistent = false])
  • $sHost
  • $sUser
  • $sPass
  • $sPort
  • $sPersistent
_getField (line 697)

Returns one field from a row

  • return: field value
  • access: private
mixed _getField (string $sSql,  &$hLink)
  • string $sSql: SQL query
  • &$hLink
_getRow (line 603)

Returns exactly one row as array. If there is number of rows satisfying the condition then the first one will be returned.

  • return: exact one row (first if multiply row selected): or false on error
  • access: private
array _getRow (string $sSql, string $bAssoc,  &$hLink)
  • string $sSql: select query
  • string $bAssoc: type of returned rows array
  • &$hLink
_getRows (line 644)

Gets data returned by sql query

  • return: selected rows (each row is array of specified type) or emprt array on error
  • access: private
array _getRows (string $sSql, [string $bAssoc = true],  &$hLink)
  • string $sSql: select query
  • string $bAssoc: type of returned rows array
  • &$hLink
_insert (line 708)
  • access: protected
void _insert ( $sTable,  $sFields,  $sValues)
  • $sTable
  • $sFields
  • $sValues
_join (line 560)
  • access: private
void _join ( $sType,  $sTable,  $sAlias, [ $mParam = null])
  • $sType
  • $sTable
  • $sAlias
  • $mParam
_sqlError (line 589)
  • access: private
void _sqlError ()
_update (line 719)
  • access: protected
void _update ( $sTable,  $sSets,  $sCond)
  • $sTable
  • $sSets
  • $sCond

Documentation generated on Tue, 28 Sep 2010 10:36:42 +0200 by phpDocumentor 1.4.0a2