Packageindex Classtrees Modulegroups Elementlist Report XML Files

File: c:/www/apache/doc2//pear/DB/oci8.php
PEAR 2000/12/03 -

DB_oci8

DB_common
   |
  +-- DB_oci8

DB_common is a base class for DB implementations, and should be

 

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()

Warning: documentation is missing.

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 a

&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(). WithWarning: documentation is missing.
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( )

 

Warning: documentation is missing.

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
Warning: documentation is missing.
boolean $persistent
Warning: documentation is missing.
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 a &query( $query )

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

Parameter
$query
Warning: documentation is missing.
Returns object 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
Warning: documentation is missing.
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
be indexed
string $fetchmode
Warning: documentation is missing.
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
data from the row is stored
array &$arr
should be indexed
string $fetchmode
Warning: documentation is missing.
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
Warning: documentation is missing.
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
Warning: documentation is missing.
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 doesnot work unless given a statement. If OCIError does returnsomething, 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.

Warning: documentation is missing.

Parameter
$query
Warning: documentation is missing.
Returns void


execute

private int execute( $stmt, boolean $data )

  Executes a DB statement prepared with prepare().

Parameter
$stmt
Warning: documentation is missing.
boolean $data
Warning: documentation is missing.
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
Warning: documentation is missing.
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

>><<



$phptype

private unknown $phptype

>><<



$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