MDB2
[ class tree: MDB2 ] [ index: MDB2 ] [ all elements ]
Packages:
MDB2


Classes:
MDB2_BufferedResult_oci8
MDB2_Driver_Datatype_oci8
MDB2_Driver_Function_oci8
MDB2_Driver_Manager_oci8
MDB2_Driver_Native_oci8
MDB2_Driver_oci8
MDB2_Driver_Reverse_oci8
MDB2_Result_oci8
MDB2_Statement_oci8
Files:
oci8.php
oci8.php
oci8.php
oci8.php
oci8.php
oci8.php

Class: MDB2_Driver_oci8

Source Location: /MDB2_Driver_oci8-0.2.6/MDB2/Driver/oci8.php

Class Overview

MDB2_Driver_Common
   |
   --MDB2_Driver_oci8

MDB2 OCI8 driver


Author(s):

Variables

Methods

Inherited Variables

Inherited Methods

Class Details

[line 55]
MDB2 OCI8 driver


[ Top ]

Class Variables

$escape_quotes =  "'"

[line 58]


Type:   mixed


[ Top ]

$uncommitedqueries =  0

[line 60]


Type:   mixed


[ Top ]


Method Detail

beginTransaction   [line 162]

mixed beginTransaction( )

Start a transaction.
  • Return: MDB2_OK on success, a MDB2 error on failure
  • Access: public

[ Top ]

commit   [line 187]

mixed commit( )

Commit the database changes done during a transaction that is in progress.
  • Return: MDB2_OK on success, a MDB2 error on failure
  • Access: public

[ Top ]

connect   [line 338]

MDB2_OK connect( )

Connect to the database
  • Return: on success, MDB2 Error Object on failure
  • Access: public

[ Top ]

currId   [line 816]

mixed currId( string $seq_name)

Returns the current id of a sequence
  • Return: MDB2_Error or id
  • Access: public

Parameters:

string   $seq_name   —   name of the sequence

[ Top ]

disconnect   [line 382]

mixed disconnect( [boolean $force = true])

Log out and disconnect from the database.
  • Return: true on success, false if not connected and error object on error
  • Access: public

Parameters:

boolean   $force   —   if the disconnect should be forced even if the connection is opened persistently

[ Top ]

errorInfo   [line 110]

array errorInfo( [integer $error = null])

This method is used to collect information about an error
  • Access: public

Parameters:

integer   $error   —   

[ Top ]

getServerVersion   [line 589]

mixed getServerVersion( [string $native = false])

return version information about the server
  • Return: array/string with version information or MDB2 error object
  • Access: public

Parameters:

string   $native   —   determines if the raw version string should be returned

[ Top ]

nextID   [line 786]

mixed nextID( string $seq_name, [boolean $ondemand = true])

Returns the next free id of a sequence
  • Return: MDB2 Error Object or id
  • Access: public

Parameters:

string   $seq_name   —   name of the sequence
boolean   $ondemand   —   when true the sequence is automatic created, if it not exists

[ Top ]

prepare   [line 645]

mixed &prepare( string $query, [mixed $types = null], [mixed $result_types = null], [mixed $lobs = array()])

Prepares a query for multiple execution with execute().

With some database backends, this is emulated. prepare() requires a generic query as string like 'INSERT INTO numbers VALUES(?,?)' or 'INSERT INTO numbers VALUES(:foo,:bar)'. The ? and :[a-zA-Z] and are placeholders which can be set using bindParam() and the query can be send off using the execute() method.

  • Return: resource handle for the prepared query on success, a MDB2 error on failure
  • See: bindParam, execute
  • Access: public

Parameters:

string   $query   —   the query to prepare
mixed   $types   —   array that contains the types of the placeholders
mixed   $result_types   —   array that contains the types of the columns in the result set or MDB2_PREPARE_RESULT, if set to MDB2_PREPARE_MANIP the query is handled as a manipulation query
mixed   $lobs   —   key (field) value (parameter) pair for all lob placeholders

[ Top ]

rollback   [line 219]

mixed rollback( )

Cancel any database changes done during a transaction that is in progress.
  • Return: MDB2_OK on success, a MDB2 error on failure
  • Access: public

[ Top ]

standaloneExec   [line 410]

mixed &standaloneExec( string $query)

execute a query as database administrator
  • Return: MDB2_OK on success, a MDB2 error on failure
  • Access: public

Parameters:

string   $query   —   the SQL query

[ Top ]

standaloneQuery   [line 448]

mixed &standaloneQuery( string $query, [mixed $types = null], [boolean $is_manip = false])

execute a query as DBA
  • Return: MDB2_OK on success, a MDB2 error on failure
  • Access: public

Parameters:

string   $query   —   the SQL query
mixed   $types   —   array that contains the types of the columns in the result set
boolean   $is_manip   —   if the query is a manipulation query

[ Top ]

_doConnect   [line 250]

connection _doConnect( mixed $username, mixed $password, [mixed $persistent = false])

do the grunt work of the connect
  • Return: on success or MDB2 Error Object on failure
  • Access: protected

[ Top ]

_doQuery   [line 519]

result &_doQuery( string $query, [boolean $is_manip = false], [resource $connection = null], [string $database_name = null])

Execute a query
  • Return: or error object
  • Access: protected

Parameters:

string   $query   —   query
boolean   $is_manip   —   if the query is a manipulation query
resource   $connection   —   
string   $database_name   —   

[ Top ]

_modifyQuery   [line 491]

string _modifyQuery( string $query, boolean $is_manip, integer $limit, integer $offset)

Changes a query string for various DBMS specific reasons
  • Return: modified query
  • Access: protected

Parameters:

string   $query   —   query to modify
boolean   $is_manip   —   if it is a DML query
integer   $limit   —   limit the number of rows
integer   $offset   —   start reading from given offset

[ Top ]
Documentation generated on Sun, 14 May 2006 02:35:12 -0400 by phpDocumentor 1.2.3. PEAR Logo Copyright © PHP Group 2004.