| [ Index ] |
|
Code source de PHP PEAR 1.4.5 |
[Code source] [Imprimer] [Statistiques]
(pas de description)
| Poids: | 1769 lignes (69 kb) |
| Inclus ou requis: | 0 fois |
| Référencé: | 1 fois |
| Nécessite: | 1 fichier MDB/Common.php |
MDB_oci8:: (48 méthodes):
MDB_oci8()
errorNative()
oci8RaiseError()
autoCommit()
commit()
rollback()
connect()
_close()
_doQuery()
query()
_executePreparedQuery()
_skipLimitOffset()
getColumnNames()
numCols()
endOfResult()
_retrieveLob()
fetch()
fetchClob()
fetchBlob()
resultIsNull()
convertResult()
numRows()
freeResult()
getTypeDeclaration()
getIntegerDeclaration()
getTextDeclaration()
getClobDeclaration()
getBlobDeclaration()
getBooleanDeclaration()
getDateDeclaration()
getTimestampDeclaration()
getTimeDeclaration()
getFloatDeclaration()
getDecimalDeclaration()
getClobValue()
freeClobValue()
getBlobValue()
freeBlobValue()
getDateValue()
getTimestampValue()
getTimeValue()
getFloatValue()
getDecimalValue()
nextId()
currId()
fetchInto()
nextResult()
tableInfo()
| MDB_oci8() X-Ref |
| Constructor |
| errorNative($statement = NULL) X-Ref |
| Get the native error code of the last error (if any) that occured on the current connection. return: int native oci8 error code |
| oci8RaiseError($errno = NULL, $message = NULL) X-Ref |
| 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. param: integer $errno error code param: string $message userinfo message return: object a PEAR error object |
| autoCommit($auto_commit) X-Ref |
| Define whether database changes done on the database be automatically committed. This function may also implicitly start or end a transaction. param: boolean $auto_commit flag that indicates whether the database return: mixed MDB_OK on success, a MDB error on failure |
| commit() X-Ref |
| 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: mixed MDB_OK on success, a MDB error on failure |
| rollback() X-Ref |
| 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: mixed MDB_OK on success, a MDB error on failure |
| connect($user = NULL , $password = NULL, $persistent = NULL) X-Ref |
| Connect to the database return: TRUE on success, MDB_Error on failure |
| _close() X-Ref |
| all the RDBMS specific things needed close a DB connection |
| _doQuery($query, $first = 0, $limit = 0, $prepared_query = 0) X-Ref |
| all the RDBMS specific things needed close a DB connection |
| query($query, $types = NULL) X-Ref |
| Send a query to the database and return any results param: string $query the SQL query param: array $types array that contains the types of the columns in return: mixed a result handle or MDB_OK on success, a MDB error on failure |
| _executePreparedQuery($prepared_query, $query) X-Ref |
| Execute a prepared query statement. param: int $prepared_query argument is a handle that was returned by param: string $query query to be executed param: array $types array that contains the types of the columns in return: mixed a result handle or MDB_OK on success, a MDB error on failure |
| _skipLimitOffset($result) X-Ref |
| Skip the first row of a result set. param: resource $result return: mixed a result handle or MDB_OK on success, a MDB error on failure |
| getColumnNames($result) X-Ref |
| Retrieve the names of columns returned by the DBMS in a query result. param: resource $result result identifier return: mixed an associative array variable |
| numCols($result) X-Ref |
| Count the number of columns returned by the DBMS in a query result. param: resource $result result identifier return: mixed integer value with the number of columns, a MDB error |
| endOfResult($result) X-Ref |
| check if the end of the result set has been reached param: resource $result result identifier return: mixed TRUE or FALSE on sucess, a MDB error on failure |
| _retrieveLob($lob) X-Ref |
| fetch a lob value from a result set param: int $lob handle to a lob created by the createLob() function return: mixed MDB_OK on success, a MDB error on failure |
| fetch($result, $rownum, $colnum) X-Ref |
| fetch value from a result set param: resource $result result identifier param: int $rownum number of the row where the data can be found param: int $colnum field number where the data can be found return: mixed string on success, a MDB error on failure |
| fetchClob($result, $row, $field) X-Ref |
| fetch a clob value from a result set param: resource $result result identifier param: int $row number of the row where the data can be found param: int $field field number where the data can be found return: mixed content of the specified data cell, a MDB error on failure, |
| fetchBlob($result, $row, $field) X-Ref |
| fetch a blob value from a result set param: resource $result result identifier param: int $row number of the row where the data can be found param: int $field field number where the data can be found return: mixed content of the specified data cell, a MDB error on failure |
| resultIsNull($result, $rownum, $field) X-Ref |
| Determine whether the value of a query result located in given row and field is a NULL. param: resource $result result identifier param: int $rownum number of the row where the data can be found param: int $field field number where the data can be found return: mixed TRUE or FALSE on success, a MDB error on failure |
| convertResult($value, $type) X-Ref |
| convert a value to a RDBMS indepdenant MDB type param: mixed $value value to be converted param: int $type constant that specifies which type to convert to return: mixed converted value |
| numRows($result) X-Ref |
| returns the number of rows in a result object param: ressource $result a valid result ressouce pointer return: mixed MDB_Error or the number of rows |
| freeResult($result) X-Ref |
| Free the internal resources associated with $result. param: $result result identifier return: bool TRUE on success, FALSE if $result is invalid |
| getTypeDeclaration($field) X-Ref |
| Obtain DBMS specific native datatype as a string param: string $field associative array with the name of the properties return: string with the correct RDBMS native type |
| getIntegerDeclaration($name, $field) X-Ref |
| Obtain DBMS specific SQL code portion needed to declare an integer type field to be used in statements like CREATE TABLE. param: string $name name the field to be declared. param: string $field associative array with the name of the properties return: string DBMS specific SQL code portion that should be used to |
| getTextDeclaration($name, $field) X-Ref |
| Obtain DBMS specific SQL code portion needed to declare an text type field to be used in statements like CREATE TABLE. param: string $name name the field to be declared. param: string $field associative array with the name of the properties return: string DBMS specific SQL code portion that should be used to |
| getClobDeclaration($name, $field) X-Ref |
| Obtain DBMS specific SQL code portion needed to declare an character large object type field to be used in statements like CREATE TABLE. param: string $name name the field to be declared. param: string $field associative array with the name of the properties return: string DBMS specific SQL code portion that should be used to |
| getBlobDeclaration($name, $field) X-Ref |
| Obtain DBMS specific SQL code portion needed to declare an binary large object type field to be used in statements like CREATE TABLE. param: string $name name the field to be declared. param: string $field associative array with the name of the properties return: string DBMS specific SQL code portion that should be used to |
| getBooleanDeclaration($name, $field) X-Ref |
| Obtain DBMS specific SQL code portion needed to declare a boolean type field to be used in statements like CREATE TABLE. param: string $name name the field to be declared. param: string $field associative array with the name of the properties return: string DBMS specific SQL code portion that should be used to |
| getDateDeclaration($name, $field) X-Ref |
| Obtain DBMS specific SQL code portion needed to declare a date type field to be used in statements like CREATE TABLE. param: string $name name the field to be declared. param: string $field associative array with the name of the properties return: string DBMS specific SQL code portion that should be used to |
| getTimestampDeclaration($name, $field) X-Ref |
| Obtain DBMS specific SQL code portion needed to declare a timestamp field to be used in statements like CREATE TABLE. param: string $name name the field to be declared. param: string $field associative array with the name of the properties return: string DBMS specific SQL code portion that should be used to |
| getTimeDeclaration($name, $field) X-Ref |
| Obtain DBMS specific SQL code portion needed to declare a time field to be used in statements like CREATE TABLE. param: string $name name the field to be declared. param: string $field associative array with the name of the properties return: string DBMS specific SQL code portion that should be used to |
| getFloatDeclaration($name, $field) X-Ref |
| Obtain DBMS specific SQL code portion needed to declare a float type field to be used in statements like CREATE TABLE. param: string $name name the field to be declared. param: string $field associative array with the name of the properties return: string DBMS specific SQL code portion that should be used to |
| getDecimalDeclaration($name, $field) X-Ref |
| Obtain DBMS specific SQL code portion needed to declare a decimal type field to be used in statements like CREATE TABLE. param: string $name name the field to be declared. param: string $field associative array with the name of the properties return: string DBMS specific SQL code portion that should be used to |
| getClobValue($prepared_query, $parameter, $clob) X-Ref |
| Convert a text value into a DBMS specific format that is suitable to compose query statements. param: resource $prepared_query query handle from prepare() param: $parameter param: $clob return: string text string that represents the given argument value in |
| freeClobValue($prepared_query, $clob, &$value) X-Ref |
| free a character large object param: resource $prepared_query query handle from prepare() param: string $blob param: string $value |
| getBlobValue($prepared_query, $parameter, $blob) X-Ref |
| Convert a text value into a DBMS specific format that is suitable to compose query statements. param: resource $prepared_query query handle from prepare() param: $parameter param: $blob return: string text string that represents the given argument value in |
| freeBlobValue($prepared_query, $blob, &$value) X-Ref |
| free a binary large object param: resource $prepared_query query handle from prepare() param: string $blob param: string $value |
| getDateValue($value) X-Ref |
| Convert a text value into a DBMS specific format that is suitable to compose query statements. param: string $value text string value that is intended to be converted. return: string text string that represents the given argument value in |
| getTimestampValue($value) X-Ref |
| Convert a text value into a DBMS specific format that is suitable to compose query statements. param: string $value text string value that is intended to be converted. return: string text string that represents the given argument value in |
| getTimeValue($value) X-Ref |
| Convert a text value into a DBMS specific format that is suitable to compose query statements. param: string $value text string value that is intended to be converted. return: string text string that represents the given argument value in |
| getFloatValue($value) X-Ref |
| Convert a text value into a DBMS specific format that is suitable to compose query statements. param: string $value text string value that is intended to be converted. return: string text string that represents the given argument value in |
| getDecimalValue($value) X-Ref |
| Convert a text value into a DBMS specific format that is suitable to compose query statements. param: string $value text string value that is intended to be converted. return: string text string that represents the given argument value in |
| nextId($seq_name, $ondemand = TRUE) X-Ref |
| returns the next free id of a sequence param: string $seq_name name of the sequence param: boolean $ondemand when TRUE the seqence is return: mixed MDB_Error or id |
| currId($seq_name) X-Ref |
| returns the current id of a sequence param: string $seq_name name of the sequence return: mixed MDB_Error or id |
| fetchInto($result, $fetchmode = MDB_FETCHMODE_DEFAULT, $rownum = NULL) X-Ref |
| Fetch a row and return data in an array. param: resource $result result identifier param: int $fetchmode how the array data should be indexed param: int $rownum the row number to fetch return: mixed data array or NULL on success, a MDB error on failure |
| nextResult($result) X-Ref |
| Move the internal oracle result pointer to the next available result Currently not supported param: $result a oracle valid result resource return: TRUE if a result is available otherwise return FALSE |
| tableInfo($result, $mode = NULL) X-Ref |
| returns meta data about the result set param: resource $result result identifier param: mixed $mode depends on implementation return: array an nested array, or a MDB error |
| Généré le : Sun Feb 25 14:08:00 2007 | par Balluche grâce à PHPXref 0.7 |