MDB
[ class tree: MDB ] [ index: MDB ] [ all elements ]

Class: MDB_oci8

Source Location: /MDB-1.3.0/MDB/oci8.php

Class Overview

PEAR
   |
   --MDB_Common
      |
      --MDB_oci8

MDB OCI8 driver


Author(s):

Variables

Methods


Inherited Variables

Inherited Methods

Class: MDB_Common

MDB_Common::MDB_Common()
Constructor
MDB_Common::affectedRows()
returns the affected rows of a query
MDB_Common::alterTable()
alter an existing table
MDB_Common::autoCommit()
Define whether database changes done on the database be automatically committed. This function may also implicitly start or end a transaction.
MDB_Common::captureDebugOutput()
set a debug handler
MDB_Common::commit()
Commit the database changes done during a transaction that is in progress. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after committing the pending changes.
MDB_Common::convertResult()
convert a value to a RDBMS indepdenant MDB type
MDB_Common::convertResultRow()
convert a result row
MDB_Common::createDatabase()
create a new database
MDB_Common::createIndex()
get the stucture of a field into an array
MDB_Common::createLob()
Create a handler object of a specified class with functions to retrieve data from a large object data stream.
MDB_Common::createSequence()
create sequence
MDB_Common::createTable()
create a new table
MDB_Common::currId()
returns the current id of a sequence
MDB_Common::debug()
set a debug message
MDB_Common::debugOutput()
output debug info
MDB_Common::destroyLob()
Free any resources allocated during the lifetime of the large object handler object.
MDB_Common::disconnect()
Log out and disconnect from the database.
MDB_Common::dropDatabase()
drop an existing database
MDB_Common::dropIndex()
drop existing index
MDB_Common::dropSequence()
drop existing sequence
MDB_Common::dropTable()
drop an existing table
MDB_Common::endOfLob()
Determine whether it was reached the end of the large object and therefore there is no more data to be read for the its input stream.
MDB_Common::endOfResult()
check if the end of the result set has been reached
MDB_Common::endOfResultLob()
Determine whether it was reached the end of the large object and therefore there is no more data to be read for the its input stream.
MDB_Common::error()
Retrieve the error message text associated with the last operation that failed. Some functions may fail but they do not return the reason that makes them to fail. This function is meant to retrieve a textual description of the failure cause.
MDB_Common::errorCode()
Map native error codes to MDB's portable ones. Requires that the DB implementation's constructor fills in the $errorcode_map property.
MDB_Common::errorMessage()
Map a MDB error code to a textual message. This is actually just a wrapper for MDB::errorMessage().
MDB_Common::errorNative()
returns an errormessage, provides by the database
MDB_Common::execute()
Executes a prepared SQL query
MDB_Common::executeMultiple()
This function does several execute() calls on the same statement handle.
MDB_Common::executeQuery()
Execute a prepared query statement.
MDB_Common::fetch()
fetch value from a result set
MDB_Common::fetchAll()
Fetch and return a column of data (it uses fetchInto for that)
MDB_Common::fetchBlob()
fetch a blob value from a result set
MDB_Common::fetchBoolean()
fetch a boolean value from a result set
MDB_Common::fetchClob()
fetch a clob value from a result set
MDB_Common::fetchCol()
Fetch and return a column of data (it uses fetchInto for that)
MDB_Common::fetchDate()
fetch a date value from a result set
MDB_Common::fetchDecimal()
fetch a decimal value from a result set
MDB_Common::fetchFloat()
fetch a float value from a result set
MDB_Common::fetchInto()
Fetch a row and return data in an array.
MDB_Common::fetchLob()
fetch a lob value from a result set
MDB_Common::fetchOne()
Fetch and return a field of data (it uses fetchInto for that)
MDB_Common::fetchRow()
Fetch and return a row of data (it uses fetchInto for that)
MDB_Common::fetchTime()
fetch a time value from a result set
MDB_Common::fetchTimestamp()
fetch a timestamp value from a result set
MDB_Common::freeBlobValue()
free a binary large object
MDB_Common::freeClobValue()
free a character large object
MDB_Common::freePreparedQuery()
Release resources allocated for the specified prepared query.
MDB_Common::freeResult()
Free the internal resources associated with $result.
MDB_Common::getAll()
Fetch all the rows returned from a query.
MDB_Common::getAssoc()
Fetch the entire result set of a query and return it as an associative array using the first column as the key.
MDB_Common::getBlobDeclaration()
Obtain DBMS specific SQL code portion needed to declare an binary large object type field to be used in statements like CREATE TABLE.
MDB_Common::getBlobValue()
Convert a text value into a DBMS specific format that is suitable to compose query statements.
MDB_Common::getBooleanDeclaration()
Obtain DBMS specific SQL code portion needed to declare a boolean type field to be used in statements like CREATE TABLE.
MDB_Common::getBooleanValue()
Convert a text value into a DBMS specific format that is suitable to compose query statements.
MDB_Common::getClobDeclaration()
Obtain DBMS specific SQL code portion needed to declare an character large object type field to be used in statements like CREATE TABLE.
MDB_Common::getClobValue()
Convert a text value into a DBMS specific format that is suitable to compose query statements.
MDB_Common::getCol()
Fetch a single column from a result set and return it as an indexed array.
MDB_Common::getColumnNames()
Retrieve the names of columns returned by the DBMS in a query result.
MDB_Common::getDateDeclaration()
Obtain DBMS specific SQL code portion needed to declare a date type field to be used in statements like CREATE TABLE.
MDB_Common::getDateValue()
Convert a text value into a DBMS specific format that is suitable to compose query statements.
MDB_Common::getDecimalDeclaration()
Obtain DBMS specific SQL code portion needed to declare a decimal type field to be used in statements like CREATE TABLE.
MDB_Common::getDecimalValue()
Convert a text value into a DBMS specific format that is suitable to compose query statements.
MDB_Common::getDSN()
return the DSN as a string
MDB_Common::getFieldDeclaration()
get declaration of a field
MDB_Common::getFieldDeclarationList()
get declaration of a number of field in bulk
MDB_Common::getFloatDeclaration()
Obtain DBMS specific SQL code portion needed to declare a float type field to be used in statements like CREATE TABLE.
MDB_Common::getFloatValue()
Convert a text value into a DBMS specific format that is suitable to compose query statements.
MDB_Common::getIntegerDeclaration()
Obtain DBMS specific SQL code portion needed to declare an integer type field to be used in statements like CREATE TABLE.
MDB_Common::getIntegerValue()
Convert a text value into a DBMS specific format that is suitable to compose query statements.
MDB_Common::getOne()
Fetch the first column of the first row of data returned from a query. Takes care of doing the query and freeing the results when finished.
MDB_Common::getOption()
returns the value of an option
MDB_Common::getRow()
Fetch the first row of data returned from a query. Takes care of doing the query and freeing the results when finished.
MDB_Common::getSequenceDefinition()
get the stucture of a sequence into an array
MDB_Common::getSequenceName()
adds sequence name formating to a sequence name
MDB_Common::getTableFieldDefinition()
get the stucture of a field into an array
MDB_Common::getTableIndexDefinition()
get the stucture of an index into an array
MDB_Common::getTextDeclaration()
Obtain DBMS specific SQL code portion needed to declare an text type field to be used in statements like CREATE TABLE.
MDB_Common::getTextValue()
Convert a text value into a DBMS specific format that is suitable to compose query statements.
MDB_Common::getTimeDeclaration()
Obtain DBMS specific SQL code portion needed to declare a time field to be used in statements like CREATE TABLE.
MDB_Common::getTimestampDeclaration()
Obtain DBMS specific SQL code portion needed to declare a timestamp field to be used in statements like CREATE TABLE.
MDB_Common::getTimestampValue()
Convert a text value into a DBMS specific format that is suitable to compose query statements.
MDB_Common::getTimeValue()
Convert a text value into a DBMS specific format that is suitable to compose query statements.
MDB_Common::getValue()
Convert a text value into a DBMS specific format that is suitable to compose query statements.
MDB_Common::getWarnings()
get all warnings in reverse order.
MDB_Common::limitQuery()
Generates a limited query
MDB_Common::listDatabases()
list all databases
MDB_Common::listFunctions()
list all functions in the current database
MDB_Common::listSequences()
list all tables in the current database
MDB_Common::listTableFields()
list all fields in a tables in the current database
MDB_Common::listTableIndexes()
list all indexes in a table
MDB_Common::listTables()
list all tables in the current database
MDB_Common::listUsers()
list all users
MDB_Common::listViews()
list all viewes in the current database
MDB_Common::loadLob()
loads the LOB module
MDB_Common::loadManager()
loads the Manager module
MDB_Common::nextId()
returns the next free id of a sequence
MDB_Common::numCols()
Count the number of columns returned by the DBMS in a query result.
MDB_Common::numRows()
returns the number of rows in a result object
MDB_Common::prepareQuery()
Prepares a query for multiple execution with execute().
MDB_Common::query()
Send a query to the database and return any results
MDB_Common::queryAll()
Execute the specified query, fetch all the rows of the result set into a two dimensional array and then frees the result set.
MDB_Common::queryCol()
Execute the specified query, fetch the value from the first column of each row of the result set into an array and then frees the result set.
MDB_Common::queryOne()
Execute the specified query, fetch the value from the first column of the first row of the result set and then frees the result set.
MDB_Common::queryRow()
Execute the specified query, fetch the values from the first row of the result set into an array and then frees the result set.
MDB_Common::quoteIdentifier()
Quote a string so it can be safely used as a table or column name
MDB_Common::raiseError()
This method is used to communicate an error and invoke error callbacks etc. Basically a wrapper for PEAR::raiseError without the message string.
MDB_Common::readLob()
Read data from large object input stream.
MDB_Common::replace()
Execute a SQL REPLACE query. A REPLACE query is identical to a INSERT query, except that if there is already a row in the table with the same key field values, the REPLACE query just updates its values instead of inserting a new row.
MDB_Common::resetWarnings()
reset the warning array
MDB_Common::resultIsNull()
Determine whether the value of a query result located in given row and field is a NULL.
MDB_Common::rollback()
Cancel any database changes done during a transaction that is in progress. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after canceling the pending changes.
MDB_Common::setDatabase()
Select a different database
MDB_Common::setDSN()
set the DSN
MDB_Common::setErrorHandler()
Specify a function that is called when an error occurs.
MDB_Common::setFetchMode()
Sets which fetch mode should be used by default on queries on this connection.
MDB_Common::setOption()
set the option for the db class
MDB_Common::setParam()
Set the value of a parameter of a prepared query.
MDB_Common::setParamArray()
Set the values of multiple a parameter of a prepared query in bulk.
MDB_Common::setParamBlob()
Set a parameter of a prepared query with a binary large object value.
MDB_Common::setParamBoolean()
Set a parameter of a prepared query with a boolean value.
MDB_Common::setParamClob()
Set a parameter of a prepared query with a character large object value.
MDB_Common::setParamDate()
Set a parameter of a prepared query with a date value.
MDB_Common::setParamDecimal()
Set a parameter of a prepared query with a decimal value.
MDB_Common::setParamFloat()
Set a parameter of a prepared query with a float value.
MDB_Common::setParamInteger()
Set a parameter of a prepared query with a text value.
MDB_Common::setParamNull()
Set the value of a parameter of a prepared query to NULL.
MDB_Common::setParamText()
Set a parameter of a prepared query with a text value.
MDB_Common::setParamTime()
Set a parameter of a prepared query with a time value.
MDB_Common::setParamTimestamp()
Set a parameter of a prepared query with a time stamp value.
MDB_Common::setResultTypes()
Define the list of types to be associated with the columns of a given result set.
MDB_Common::setSelectedRowRange()
set the range of the next query
MDB_Common::subSelect()
simple subselect emulation: leaves the query untouched for all RDBMS that support subselects
MDB_Common::support()
Tell whether a DB implementation or its backend extension supports a given feature.
MDB_Common::tableInfo()
returns meta data about the result set
MDB_Common::__toString()
String conversation

Class Details

[line 85]
MDB OCI8 driver

Notes:

  • when fetching in associative mode all keys are uppercased which is not the intenteded behavior. Due to BC issues this will not be changed in MDB 1.x however.
  • createDatabase and dropDatabase are not supported
  • Text fields with unspecified length limit are created as VARCHAR with an optional limit that may not exceed 4000 characters.
  • date fields are emulated with date fields with time set to 00:00:00.
  • The numRows method is emulated by fetching all the rows into memory. Avoid using it if for queries with large result sets.
  • Oracle does not provide direct support for returning result sets restricted
  • Storing data in large object fields has to be done in two phases: first the Besides the fact that only INSERT and UPDATE queries are supported to
  • The driver alterTable method does not implement table or column renaming.



[ Top ]


Class Variables

$columns = array()

[line 96]


Type:   mixed


[ Top ]

$connected_password =

[line 88]


Type:   mixed


[ Top ]

$connected_user =

[line 87]


Type:   mixed


[ Top ]

$connection =  0

[line 86]


Type:   mixed


[ Top ]

$current_row = array()

[line 95]


Type:   mixed


[ Top ]

$escape_quotes =  "'"

[line 90]


Type:   mixed


[ Top ]

$highest_fetched_row = array()

[line 100]


Type:   mixed


[ Top ]

$limits = array()

[line 98]


Type:   mixed


[ Top ]

$results = array()

[line 94]


Type:   mixed


[ Top ]

$rows = array()

[line 97]


Type:   mixed


[ Top ]

$row_buffer = array()

[line 99]


Type:   mixed


[ Top ]

$uncommitedqueries =  0

[line 92]


Type:   mixed


[ Top ]



Method Detail

MDB_oci8 (Constructor)   [line 107]

MDB_oci8 MDB_oci8( )

Constructor

[ Top ]

autoCommit   [line 218]

mixed autoCommit( boolean $auto_commit)

Define whether database changes done on the database be automatically committed. This function may also implicitly start or end a transaction.
  • Return: MDB_OK on success, a MDB error on failure
  • Access: public

Overrides MDB_Common::autoCommit() (Define whether database changes done on the database be automatically committed. This function may also implicitly start or end a transaction.)

Parameters:

boolean   $auto_commit   —  flag that indicates whether the database changes should be committed right after executing every query statement. If this argument is 0 a transaction implicitly started. Otherwise, if a transaction is in progress it is ended by committing any database changes that were pending.

[ Top ]

commit   [line 244]

mixed commit( )

Commit the database changes done during a transaction that is in progress. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after committing the pending changes.
  • Return: MDB_OK on success, a MDB error on failure
  • Access: public

Overrides MDB_Common::commit() (Commit the database changes done during a transaction that is in progress. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after committing the pending changes.)
[ Top ]

connect   [line 302]

TRUE connect( [ $user = NULL], [ $password = NULL], [ $persistent = NULL])

Connect to the database
  • Return: on success, MDB_Error on failure

Parameters:

   $user   — 
   $password   — 
   $persistent   — 

[ Top ]

convertResult   [line 855]

mixed convertResult( mixed $value, int $type)

convert a value to a RDBMS indepdenant MDB type
  • Return: converted value
  • Access: public

Overrides MDB_Common::convertResult() (convert a value to a RDBMS indepdenant MDB type)

Parameters:

mixed   $value   —  value to be converted
int   $type   —  constant that specifies which type to convert to

[ Top ]

currId   [line 1500]

mixed currId( string $seq_name)

returns the current id of a sequence
  • Return: MDB_Error or id
  • Access: public

Overrides MDB_Common::currId() (returns the current id of a sequence)

Parameters:

string   $seq_name   —  name of the sequence

[ Top ]

endOfResult   [line 702]

mixed endOfResult( resource $result)

check if the end of the result set has been reached
  • Return: TRUE or FALSE on sucess, a MDB error on failure
  • Access: public

Overrides MDB_Common::endOfResult() (check if the end of the result set has been reached)

Parameters:

resource   $result   —  result identifier

[ Top ]

errorNative   [line 156]

int errorNative( [ $statement = NULL])

Get the native error code of the last error (if any) that occured on the current connection.
  • Return: native oci8 error code
  • Access: public

Overrides MDB_Common::errorNative() (returns an errormessage, provides by the database)

Parameters:

   $statement   — 

[ Top ]

fetch   [line 775]

mixed fetch( resource $result, int $rownum, int $colnum)

fetch value from a result set
  • Return: string on success, a MDB error on failure
  • Access: public

Overrides MDB_Common::fetch() (fetch value from a result set)

Parameters:

resource   $result   —  result identifier
int   $rownum   —  number of the row where the data can be found
int   $colnum   —  field number where the data can be found

[ Top ]

fetchBlob   [line 817]

mixed fetchBlob( resource $result, int $row, int $field)

fetch a blob value from a result set
  • Return: content of the specified data cell, a MDB error on failure
  • Access: public

Overrides MDB_Common::fetchBlob() (fetch a blob value from a result set)

Parameters:

resource   $result   —  result identifier
int   $row   —  number of the row where the data can be found
int   $field   —  field number where the data can be found

[ Top ]

fetchClob   [line 801]

mixed fetchClob( resource $result, int $row, int $field)

fetch a clob value from a result set
  • Return: content of the specified data cell, a MDB error on failure, a MDB error on failure
  • Access: public

Overrides MDB_Common::fetchClob() (fetch a clob value from a result set)

Parameters:

resource   $result   —  result identifier
int   $row   —  number of the row where the data can be found
int   $field   —  field number where the data can be found

[ Top ]

fetchInto   [line 1528]

mixed fetchInto( resource $result, [int $fetchmode = MDB_FETCHMODE_DEFAULT], [int $rownum = NULL])

Fetch a row and return data in an array.
  • Return: data array or NULL on success, a MDB error on failure
  • Access: public

Overrides MDB_Common::fetchInto() (Fetch a row and return data in an array.)

Parameters:

resource   $result   —  result identifier
int   $fetchmode   —  how the array data should be indexed
int   $rownum   —  the row number to fetch

[ Top ]

freeBlobValue   [line 1366]

void freeBlobValue( resource $prepared_query, string $blob, &$value, string $value)

free a binary large object
  • Access: public

Overrides MDB_Common::freeBlobValue() (free a binary large object)

Parameters:

resource   $prepared_query   —  query handle from prepare()
string   $blob   — 
string   $value   — 
   &$value   — 

[ Top ]

freeClobValue   [line 1331]

void freeClobValue( resource $prepared_query, $clob, &$value, string $blob, string $value)

free a character large object
  • Access: public

Overrides MDB_Common::freeClobValue() (free a character large object)

Parameters:

resource   $prepared_query   —  query handle from prepare()
string   $blob   — 
string   $value   — 
   $clob   — 
   &$value   — 

[ Top ]

freeResult   [line 926]

bool freeResult( $result $result)

Free the internal resources associated with $result.
  • Return: TRUE on success, FALSE if $result is invalid
  • Access: public

Overrides MDB_Common::freeResult() (Free the internal resources associated with $result.)

Parameters:

$result   $result   —  result identifier

[ Top ]

getBlobDeclaration   [line 1116]

string getBlobDeclaration( string $name, string $field)

Obtain DBMS specific SQL code portion needed to declare an binary large object type field to be used in statements like CREATE TABLE.
  • Return: DBMS specific SQL code portion that should be used to declare the specified field.
  • Access: public

Overrides MDB_Common::getBlobDeclaration() (Obtain DBMS specific SQL code portion needed to declare an binary large object type field to be used in statements like CREATE TABLE.)

Parameters:

string   $name   —  name the field to be declared.
string   $field   — 

associative array with the name of the properties of the field being declared as array indexes. Currently, the types of supported field properties are as follows:

length Integer value that determines the maximum length of the large object field. If this argument is missing the field should be declared to have the longest length allowed by the DBMS.

notnull Boolean flag that indicates whether this field is constrained to not be set to NULL.


[ Top ]

getBlobValue   [line 1350]

string getBlobValue( resource $prepared_query, $parameter $parameter, $blob $blob)

Convert a text value into a DBMS specific format that is suitable to compose query statements.
  • Return: text string that represents the given argument value in a DBMS specific format.
  • Access: public

Overrides MDB_Common::getBlobValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)

Parameters:

resource   $prepared_query   —  query handle from prepare()
$parameter   $parameter   — 
$blob   $blob   — 

[ Top ]

getBooleanDeclaration   [line 1143]

string getBooleanDeclaration( string $name, string $field)

Obtain DBMS specific SQL code portion needed to declare a boolean type field to be used in statements like CREATE TABLE.
  • Return: DBMS specific SQL code portion that should be used to declare the specified field.
  • Access: public

Overrides MDB_Common::getBooleanDeclaration() (Obtain DBMS specific SQL code portion needed to declare a boolean type field to be used in statements like CREATE TABLE.)

Parameters:

string   $name   —  name the field to be declared.
string   $field   — 

associative array with the name of the properties of the field being declared as array indexes. Currently, the types of supported field properties are as follows:

default Boolean value to be used as default for this field.

notnullL Boolean flag that indicates whether this field is constrained to not be set to NULL.


[ Top ]

getClobDeclaration   [line 1087]

string getClobDeclaration( string $name, string $field)

Obtain DBMS specific SQL code portion needed to declare an character large object type field to be used in statements like CREATE TABLE.
  • Return: DBMS specific SQL code portion that should be used to declare the specified field.
  • Access: public

Overrides MDB_Common::getClobDeclaration() (Obtain DBMS specific SQL code portion needed to declare an character large object type field to be used in statements like CREATE TABLE.)

Parameters:

string   $name   —  name the field to be declared.
string   $field   — 

associative array with the name of the properties of the field being declared as array indexes. Currently, the types of supported field properties are as follows:

length Integer value that determines the maximum length of the large object field. If this argument is missing the field should be declared to have the longest length allowed by the DBMS.

notnull Boolean flag that indicates whether this field is constrained to not be set to NULL.


[ Top ]

getClobValue   [line 1315]

string getClobValue( resource $prepared_query, $parameter $parameter, $clob $clob)

Convert a text value into a DBMS specific format that is suitable to compose query statements.
  • Return: text string that represents the given argument value in a DBMS specific format.
  • Access: public

Overrides MDB_Common::getClobValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)

Parameters:

resource   $prepared_query   —  query handle from prepare()
$parameter   $parameter   — 
$clob   $clob   — 

[ Top ]

getColumnNames   [line 650]

mixed getColumnNames( resource $result)

Retrieve the names of columns returned by the DBMS in a query result.
  • Return:

    an associative array variable that will hold the names of columns.The indexes of the array are the column names mapped to lower case and the values are the respective numbers of the columns starting from 0. Some DBMS may not return any columns when the result set does not contain any rows.

    a MDB error on failure

  • Access: public

Overrides MDB_Common::getColumnNames() (Retrieve the names of columns returned by the DBMS in a query result.)

Parameters:

resource   $result   —  result identifier

[ Top ]

getDateDeclaration   [line 1173]

string getDateDeclaration( string $name, string $field)

Obtain DBMS specific SQL code portion needed to declare a date type field to be used in statements like CREATE TABLE.
  • Return: DBMS specific SQL code portion that should be used to declare the specified field.
  • Access: public

Overrides MDB_Common::getDateDeclaration() (Obtain DBMS specific SQL code portion needed to declare a date type field to be used in statements like CREATE TABLE.)

Parameters:

string   $name   —  name the field to be declared.
string   $field   — 

associative array with the name of the properties of the field being declared as array indexes. Currently, the types of supported field properties are as follows:

default Date value to be used as default for this field.

notnull Boolean flag that indicates whether this field is constrained to not be set to NULL.


[ Top ]

getDateValue   [line 1383]

string getDateValue( string $value)

Convert a text value into a DBMS specific format that is suitable to compose query statements.
  • Return: text string that represents the given argument value in a DBMS specific format.
  • Access: public

Overrides MDB_Common::getDateValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)

Parameters:

string   $value   —  text string value that is intended to be converted.

[ Top ]

getDecimalDeclaration   [line 1293]

string getDecimalDeclaration( string $name, string $field)

Obtain DBMS specific SQL code portion needed to declare a decimal type field to be used in statements like CREATE TABLE.
  • Return: DBMS specific SQL code portion that should be used to declare the specified field.
  • Access: public

Overrides MDB_Common::getDecimalDeclaration() (Obtain DBMS specific SQL code portion needed to declare a decimal type field to be used in statements like CREATE TABLE.)

Parameters:

string   $name   —  name the field to be declared.
string   $field   — 

associative array with the name of the properties of the field being declared as array indexes. Currently, the types of supported field properties are as follows:

default Decimal value to be used as default for this field.

notnull Boolean flag that indicates whether this field is constrained to not be set to NULL.


[ Top ]

getDecimalValue   [line 1451]

string getDecimalValue( string $value)

Convert a text value into a DBMS specific format that is suitable to compose query statements.
  • Return: text string that represents the given argument value in a DBMS specific format.
  • Access: public

Overrides MDB_Common::getDecimalValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)

Parameters:

string   $value   —  text string value that is intended to be converted.

[ Top ]

getFloatDeclaration   [line 1263]

string getFloatDeclaration( string $name, string $field)

Obtain DBMS specific SQL code portion needed to declare a float type field to be used in statements like CREATE TABLE.
  • Return: DBMS specific SQL code portion that should be used to declare the specified field.
  • Access: public

Overrides MDB_Common::getFloatDeclaration() (Obtain DBMS specific SQL code portion needed to declare a float type field to be used in statements like CREATE TABLE.)

Parameters:

string   $name   —  name the field to be declared.
string   $field   — 

associative array with the name of the properties of the field being declared as array indexes. Currently, the types of supported field properties are as follows:

default Float value to be used as default for this field.

notnull Boolean flag that indicates whether this field is constrained to not be set to NULL.


[ Top ]

getFloatValue   [line 1434]

string getFloatValue( string $value)

Convert a text value into a DBMS specific format that is suitable to compose query statements.
  • Return: text string that represents the given argument value in a DBMS specific format.
  • Access: public

Overrides MDB_Common::getFloatValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)

Parameters:

string   $value   —  text string value that is intended to be converted.

[ Top ]

getIntegerDeclaration   [line 1020]

string getIntegerDeclaration( string $name, string $field)

Obtain DBMS specific SQL code portion needed to declare an integer type field to be used in statements like CREATE TABLE.
  • Return: DBMS specific SQL code portion that should be used to declare the specified field.
  • Access: public

Overrides MDB_Common::getIntegerDeclaration() (Obtain DBMS specific SQL code portion needed to declare an integer type field to be used in statements like CREATE TABLE.)

Parameters:

string   $name   —  name the field to be declared.
string   $field   — 

associative array with the name of the properties of the field being declared as array indexes. Id ently, the types of supported field properties are as follows:

unsigned Boolean flag that indicates whether the field should be declared as unsigned integer if possible.

default Integer value to be used as default for this field.

notnull Boolean flag that indicates whether this field is constrained to not be set to NULL.


[ Top ]

getTextDeclaration   [line 1056]

string getTextDeclaration( string $name, string $field)

Obtain DBMS specific SQL code portion needed to declare an text type field to be used in statements like CREATE TABLE.
  • Return: DBMS specific SQL code portion that should be used to declare the specified field.
  • Access: public

Overrides MDB_Common::getTextDeclaration() (Obtain DBMS specific SQL code portion needed to declare an text type field to be used in statements like CREATE TABLE.)

Parameters:

string   $name   —  name the field to be declared.
string   $field   — 

associative array with the name of the properties of the field being declared as array indexes. Currently, the types of supported field properties are as follows:

length Integer value that determines the maximum length of the text field. If this argument is missing the field should be declared to have the longest length allowed by the DBMS.

default Text value to be used as default for this field.

notnull Boolean flag that indicates whether this field is constrained to not be set to NULL.


[ Top ]

getTimeDeclaration   [line 1233]

string getTimeDeclaration( string $name, string $field)

Obtain DBMS specific SQL code portion needed to declare a time field to be used in statements like CREATE TABLE.
  • Return: DBMS specific SQL code portion that should be used to declare the specified field.
  • Access: public

Overrides MDB_Common::getTimeDeclaration() (Obtain DBMS specific SQL code portion needed to declare a time field to be used in statements like CREATE TABLE.)

Parameters:

string   $name   —  name the field to be declared.
string   $field   — 

associative array with the name of the properties of the field being declared as array indexes. Currently, the types of supported field properties are as follows:

default Time value to be used as default for this field.

notnull Boolean flag that indicates whether this field is constrained to not be set to NULL.


[ Top ]

getTimestampDeclaration   [line 1203]

string getTimestampDeclaration( string $name, string $field)

Obtain DBMS specific SQL code portion needed to declare a timestamp field to be used in statements like CREATE TABLE.
  • Return: DBMS specific SQL code portion that should be used to declare the specified field.
  • Access: public

Overrides MDB_Common::getTimestampDeclaration() (Obtain DBMS specific SQL code portion needed to declare a timestamp field to be used in statements like CREATE TABLE.)

Parameters:

string   $name   —  name the field to be declared.
string   $field   — 

associative array with the name of the properties of the field being declared as array indexes. Currently, the types of supported field properties are as follows:

default Timestamp value to be used as default for this field.

notnull Boolean flag that indicates whether this field is constrained to not be set to NULL.


[ Top ]

getTimestampValue   [line 1400]

string getTimestampValue( string $value)

Convert a text value into a DBMS specific format that is suitable to compose query statements.
  • Return: text string that represents the given argument value in a DBMS specific format.
  • Access: public

Overrides MDB_Common::getTimestampValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)

Parameters:

string   $value   —  text string value that is intended to be converted.

[ Top ]

getTimeValue   [line 1417]

string getTimeValue( string $value)

Convert a text value into a DBMS specific format that is suitable to compose query statements.
  • Return: text string that represents the given argument value in a DBMS specific format.
  • Access: public

Overrides MDB_Common::getTimeValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)

Parameters:

string   $value   —  text string value that is intended to be converted.

[ Top ]

getTypeDeclaration   [line 970]

string getTypeDeclaration( string $field)

Obtain DBMS specific native datatype as a string
  • Return: with the correct RDBMS native type
  • Access: public

Parameters:

string   $field   —  associative array with the name of the properties of the field being declared as array indexes. Currently, the types of supported field properties are as follows:

[ Top ]

nextId   [line 1469]

mixed nextId( string $seq_name, [boolean $ondemand = TRUE])

returns the next free id of a sequence
  • Return: MDB_Error or id
  • Access: public

Overrides MDB_Common::nextId() (returns the next free id of a sequence)

Parameters:

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

[ Top ]

nextResult   [line 1636]

TRUE nextResult( $result $result)

Move the internal oracle result pointer to the next available result Currently not supported
  • Return: if a result is available otherwise return FALSE
  • Access: public

Parameters:

$result   $result   —  a oracle valid result resource

[ Top ]

numCols   [line 682]

mixed numCols( resource $result)

Count the number of columns returned by the DBMS in a query result.
  • Return: integer value with the number of columns, a MDB error on failure
  • Access: public

Overrides MDB_Common::numCols() (Count the number of columns returned by the DBMS in a query result.)

Parameters:

resource   $result   —  result identifier

[ Top ]

numRows   [line 877]

mixed numRows( ressource $result)

returns the number of rows in a result object
  • Return: MDB_Error or the number of rows
  • Access: public

Overrides MDB_Common::numRows() (returns the number of rows in a result object)

Parameters:

ressource   $result   —  a valid result ressouce pointer

[ Top ]

oci8RaiseError   [line 183]

object a oci8RaiseError( [integer $errno = NULL], [string $message = NULL])

This method is used to communicate an error and invoke error callbacks etc. Basically a wrapper for MDB::raiseError that checks for native error msgs.
  • Return: PEAR error object
  • See: PEAR_Error
  • Access: public

Parameters:

integer   $errno   —  error code
string   $message   —  userinfo message

[ Top ]

query   [line 557]

mixed query( string $query, [array $types = NULL])

Send a query to the database and return any results
  • Return: a result handle or MDB_OK on success, a MDB error on failure
  • Access: public

Overrides MDB_Common::query() (Send a query to the database and return any results)

Parameters:

string   $query   —  the SQL query
array   $types   —  array that contains the types of the columns in the result set

[ Top ]

resultIsNull   [line 835]

mixed resultIsNull( resource $result, int $rownum, int $field)

Determine whether the value of a query result located in given row and field is a NULL.
  • Return: TRUE or FALSE on success, a MDB error on failure
  • Access: public

Overrides MDB_Common::resultIsNull() (Determine whether the value of a query result located in given row and field is a NULL.)

Parameters:

resource   $result   —  result identifier
int   $rownum   —  number of the row where the data can be found
int   $field   —  field number where the data can be found

[ Top ]

rollback   [line 277]

mixed rollback( )

Cancel any database changes done during a transaction that is in progress. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after canceling the pending changes.
  • Return: MDB_OK on success, a MDB error on failure
  • Access: public

Overrides MDB_Common::rollback() (Cancel any database changes done during a transaction that is in progress. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after canceling the pending changes.)
[ Top ]

tableInfo   [line 1652]

array tableInfo( resource $result, [mixed $mode = NULL])

returns meta data about the result set
  • Return: an nested array, or a MDB error
  • Access: public

Overrides MDB_Common::tableInfo() (returns meta data about the result set)

Parameters:

resource   $result   —  result identifier
mixed   $mode   —  depends on implementation

[ Top ]


Documentation generated on Mon, 11 Mar 2019 10:15:29 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright © PHP Group 2004.