Packageindex Classtrees Modulegroups Elementlist Report XML Files

File: /home/cch/www/pear/DB/oci8.php
PEAR Repository -

DB_oci8

DB_common
   |
  +-- DB_oci8

DB_common is a base class for DB implementations, and should be
inherited by all such.

 

private class DB_oci8 extends DB_common

DB_common is a base class for DB implementations, and should be
inherited by all such.

 

Methods inherited from DB_common

quotestring, provides, errorcode, errormessage, &raiseerror, seterrorhandling, setfetchmode, execute_emulate_query, executemultiple, &getone, &getrow, &getcol, &getassoc, &getall, tostring, db_common

Public Method Summary

void

DB_oci8()

Private Method Summary

int

connect( &$dsn, boolean $persistent)

Connect to a database and log in as the specified user.
bool

disconnect()

Log out and disconnect from the database.
object [unknown]

&query( $query)

Send a query to the database and return the results as a DB_result object.
int

simpleQuery( $query)

Send a query to oracle and return the results as an oci8 resource
int

&fetchRow(array $result, string $fetchmode)

Fetch a row and return as array.
int

fetchInto(array $result, array &$arr, string $fetchmode)

Fetch a row and insert the data into an existing array.
bool

freeResult( $result)

Free the internal resources associated with $result.
int

numCols( $result)

Get the number of columns in a result set.
int

errorNative()

Get the native error code of the last error (if any) that occured
void

prepare( $query)

Prepares a query for multiple execution with execute(). With
int

execute( $stmt, boolean $data)

Executes a DB statement prepared with prepare().
void

autoCommit(boolean $onoff)

Enable/disable automatic commits
void

commit()

Commit transactions on the current connection
void

rollback()

Roll back all uncommitted transactions on the current connection.
void

affectedRows()

Gets the number of rows affected by the last query.

Fields inherited from DB_common

$features, $errorcode_map, $type, $prepare_tokens, $prepare_maxstmt, $error_mode, $error_level, $error_callback, $last_query, $fetchmode

Private Field Summary

unknown

$connection

unknown

$phptype

array

$select_query

array

$prepare_types

integer

$autoCommit

boolean

$last_stmt

Public Method Details

DB_oci8

public void DB_oci8( )

 

Returns void


Private Method Details

connect

private int connect( &$dsn, boolean $persistent )

  Connect to a database and log in as the specified user.

Parameter
&$dsn
boolean $persistent
Returns int

DB_OK on success, a DB error code on failure


disconnect

private bool disconnect( )

  Log out and disconnect from the database.

Returns bool

TRUE on success, FALSE if not connected.


&query

private object [unknown] &query( $query )

  Send a query to the database and return the results as a DB_result object.

Parameter
$query
Returns object [unknown]

a DB_result object on success, a DB error code
on failure


simpleQuery

private int simpleQuery( $query )

  Send a query to oracle and return the results as an oci8 resource
identifier.

Parameter
$query
Returns int

returns a valid oci8 result for successful SELECT
queries, DB_OK for other successful queries. A DB error code
is returned on failure.


&fetchRow

private int &fetchRow( array $result, string $fetchmode )

  Fetch a row and return as array.

Parameter
array $result
should be indexed
string $fetchmode
Returns int

an array on success, a DB error code on failure, NULL
if there is no more data


fetchInto

private int fetchInto( array $result, array &$arr, string $fetchmode )

  Fetch a row and insert the data into an existing array.

Parameter
array $result
where data from the row is stored
array &$arr
data should be indexed
string $fetchmode
Returns int

DB_OK on success, a DB error code on failure


freeResult

private bool freeResult( $result )

  Free the internal resources associated with $result.

Parameter
$result
Returns bool

TRUE on success, FALSE if $result is invalid


numCols

private int numCols( $result )

  Get the number of columns in a result set.

Parameter
$result
Returns int

the number of columns per row in $result


errorNative

private int errorNative( )

  Get the native error code of the last error (if any) that occured
on the current connection. This does not work, as OCIError does
not work unless given a statement. If OCIError does return
something, so will this.

Returns int

native oci8 error code


prepare

private void prepare( $query )

  Prepares a query for multiple execution with execute(). With
oci8, this is emulated.

Parameter
$query
Returns void


execute

private int execute( $stmt, boolean $data )

  Executes a DB statement prepared with prepare().

Parameter
$stmt
boolean $data
Returns int

returns an oci8 result resource for successful
SELECT queries, DB_OK for other successful queries. A DB error
code is returned on failure.


autoCommit

private void autoCommit( boolean $onoff )

  Enable/disable automatic commits

Parameter
boolean $onoff
Returns void


commit

private void commit( )

  Commit transactions on the current connection

Returns void


rollback

private void rollback( )

  Roll back all uncommitted transactions on the current connection.

Returns void


affectedRows

private void affectedRows( )

  Gets the number of rows affected by the last query.
if the last query was a select, returns 0.

Returns void


Private Field Details

$connection

private unknown $connection

>>unknown<<


$phptype

private unknown $phptype

>>unknown<<


$select_query

private array $select_query

>>array()<<


$prepare_types

private array $prepare_types

>>array()<<


$autoCommit

private integer $autoCommit

>>1<<


$last_stmt

private boolean $last_stmt

>>false<<



Packageindex Classtrees Modulegroups Elementlist Report XML Files
PHPDoc 1.0beta