Docs For Class DB

Description

ORACLE database connection class

author: Peter Krebs <p.krebs@lvus.at>
copyright: (c) 2002-2003 by Peter Krebs and Landesverlag Unternehmensservice
project: Open CSP-Management
license: GNU Public License

Located in /db/ORACLE.phpclass (line 29)

Variable Summary

mixed $dbConnId

mixed $dbdatabase

mixed $dbhost

mixed $dbinitcmd

mixed $dbisInit

mixed $dbpasswd

mixed $dbuser

mixed $oraResults

Method Summary

DB_ORA DB_ORA ()

void commit ()

void connect ( $aUser, $aPassword, [ $aDatabase = ""], [ $aHost = "localhost"], [ $debug = FALSE])

string convertString (string $aValue, [boolean $debug = FALSE])

void disconnect ()

void executeBindCMD ( $aQuery, &$aBindArr)

void executeCmd ( $aQuery, [ $debug = FALSE])

array fetchArray (ORACLECURSOR $aCursor, [int $mode = NULL], [boolean $debug = FALSE])

void freeCursor ( $aCursor)

void getEmptyTblArr ( $aTable)

void getError ([ $show = TRUE])

void getResultArray ( $aCursor)

void getTableDesc ( $aTable)

void getTableFields ( $aTable, $owner)

void getTableList ([ $owner = ""], [ $debug = FALSE])

void initCon ( $aInitCmd)

void insert ( $aQuery, [ $aTable = ""], [ $keyfld = ""], [ $debug = FALSE])

void isconnected ()

string qs_getSlashedValue (string $aValue, [ $debug = FALSE])

void query ([ $aQuery = ""], [ $withErrMsg = FALSE])

mixed quickQuery (string $aQuery, [int $colNr = -1], [bool $withErrMsg = FALSE], [bool $useNames = TRUE], [bool $secMode = TRUE], [ $debug = FALSE])

void rollback ()

Variables

mixed $dbConnId = FALSE (line 45)

mixed $dbdatabase = "" (line 38)

mixed $dbhost = "" (line 37)

mixed $dbinitcmd = array() (line 41)

mixed $dbisInit = FALSE (line 42)

mixed $dbpasswd = "" (line 40)

mixed $dbuser = "" (line 39)

mixed $oraResults = array() (line 43)

Methods

Constructor DB_ORA (line 53)

DB_ORA DB_ORA ()

commit (line 322)

void commit ()

connect (line 61)

void connect ( $aUser, $aPassword, [ $aDatabase = ""], [ $aHost = "localhost"], [ $debug = FALSE])

$aUser
$aPassword
$aDatabase
$aHost
$debug

convertString (line 449)

removes /0 from $aValue

since: pk-04-09-14

string convertString (string $aValue, [boolean $debug = FALSE])

string $aValue
boolean $debug

disconnect (line 83)

void disconnect ()

executeBindCMD (line 286)

void executeBindCMD ( $aQuery, &$aBindArr)

$aQuery
&$aBindArr

executeCmd (line 271)

void executeCmd ( $aQuery, [ $debug = FALSE])

$aQuery
$debug

fetchArray (line 195)

fetch a row into an array

version: pk-04-11-17

array fetchArray (ORACLECURSOR $aCursor, [int $mode = NULL], [boolean $debug = FALSE])

ORACLECURSOR $aCursor
int $mode
boolean $debug

freeCursor (line 234)

void freeCursor ( $aCursor)

$aCursor

getEmptyTblArr (line 326)

void getEmptyTblArr ( $aTable)

$aTable

getError (line 364)

void getError ([ $show = TRUE])

$show

getResultArray (line 215)

void getResultArray ( $aCursor)

$aCursor

getTableDesc (line 401)

void getTableDesc ( $aTable)

$aTable

getTableFields (line 405)

void getTableFields ( $aTable, $owner)

$aTable
$owner

getTableList (line 380)

void getTableList ([ $owner = ""], [ $debug = FALSE])

$owner
$debug

initCon (line 73)

void initCon ( $aInitCmd)

$aInitCmd

insert (line 245)

void insert ( $aQuery, [ $aTable = ""], [ $keyfld = ""], [ $debug = FALSE])

$aQuery
$aTable
$keyfld
$debug

isconnected (line 91)

void isconnected ()

qs_getSlashedValue (line 434)

replaces ' with ''

since: pk-04-09-08

string qs_getSlashedValue (string $aValue, [ $debug = FALSE])

string $aValue
$debug

query (line 100)

void query ([ $aQuery = ""], [ $withErrMsg = FALSE])

$aQuery
$withErrMsg

quickQuery (line 146)

returns (a column) of the first row match

if $colNr > -1 the column value at position $colNr in the select statement is returned (NOTE: index starts at 0)

if $colNr < 0 a array is returend if $usNames the DB-column names are the index otherwise the index of the returned are is the number in the select order

version: pk-04-11-17
todo: $secMode not implemented

mixed quickQuery (string $aQuery, [int $colNr = -1], [bool $withErrMsg = FALSE], [bool $useNames = TRUE], [bool $secMode = TRUE], [ $debug = FALSE])

string $aQuery
int $colNr
bool $withErrMsg
bool $useNames
bool $secMode
$debug

rollback (line 318)

void rollback ()