| [ Index ] |
|
Code source de PHP PEAR 1.4.5 |
[Code source] [Imprimer] [Statistiques]
The PEAR DB driver for PHP's oci8 extension for interacting with Oracle databases PHP versions 4 and 5
| Author: | James L. Pine <jlp@valinux.com> |
| Author: | Daniel Convissor <danielc@php.net> |
| Copyright: | 1997-2005 The PHP Group |
| License: | http://www.php.net/license/3_0.txt PHP License 3.0 |
| Version: | CVS: $Id: oci8.php,v 1.111 2007/01/12 03:11:17 aharvey Exp $ |
| Poids: | 1154 lignes (38 kb) |
| Inclus ou requis: | 0 fois |
| Référencé: | 3 fois |
| Nécessite: | 1 fichier DB/common.php |
DB_oci8:: (26 méthodes):
DB_oci8()
connect()
disconnect()
simpleQuery()
nextResult()
fetchInto()
freeResult()
freePrepared()
numRows()
numCols()
prepare()
execute()
autoCommit()
commit()
rollback()
affectedRows()
modifyQuery()
modifyLimitQuery()
nextId()
createSequence()
dropSequence()
oci8RaiseError()
errorNative()
tableInfo()
getSpecialQuery()
quoteFloat()
| DB_oci8() X-Ref |
| This constructor calls <kbd>$this->DB_common()</kbd> return: void |
| connect($dsn, $persistent = false) X-Ref |
| Connect to the database server, log in and open the database Don't call this method directly. Use DB::connect() instead. If PHP is at version 5.0.0 or greater: + Generally, oci_connect() or oci_pconnect() are used. + But if the new_link DSN option is set to true, oci_new_connect() is used. When using PHP version 4.x, OCILogon() or OCIPLogon() are used. PEAR DB's oci8 driver supports the following extra DSN options: + charset The character set to be used on the connection. Only used if PHP is at version 5.0.0 or greater and the Oracle server is at 9.2 or greater. Available since PEAR DB 1.7.0. + new_link If set to true, causes subsequent calls to connect() to return a new connection link instead of the existing one. WARNING: this is not portable to other DBMS's. Available since PEAR DB 1.7.0. param: array $dsn the data source name param: bool $persistent should the connection be persistent? return: int DB_OK on success. A DB_Error object on failure. |
| disconnect() X-Ref |
| Disconnects from the database server return: bool TRUE on success, FALSE on failure |
| simpleQuery($query) X-Ref |
| Sends a query to the database server To determine how many rows of a result set get buffered using ocisetprefetch(), see the "result_buffering" option in setOptions(). This option was added in Release 1.7.0. param: string the SQL query string return: mixed + a PHP result resrouce for successful SELECT queries |
| nextResult($result) X-Ref |
| Move the internal oracle result pointer to the next available result param: a valid oci8 result resource return: true if a result is available otherwise return false |
| fetchInto($result, &$arr, $fetchmode, $rownum = null) X-Ref |
| Places a row from the result set into the given array Formating of the array and the data therein are configurable. See DB_result::fetchInto() for more information. This method is not meant to be called directly. Use DB_result::fetchInto() instead. It can't be declared "protected" because DB_result is a separate object. param: resource $result the query result resource param: array $arr the referenced array to put the data in param: int $fetchmode how the resulting array should be indexed param: int $rownum the row number to fetch (0 = first row) return: mixed DB_OK on success, NULL when the end of a result set is |
| freeResult($result) X-Ref |
| Deletes the result set and frees the memory occupied by the result set This method is not meant to be called directly. Use DB_result::free() instead. It can't be declared "protected" because DB_result is a separate object. param: resource $result PHP's query result resource return: bool TRUE on success, FALSE if $result is invalid |
| freePrepared($stmt, $free_resource = true) X-Ref |
| Frees the internal resources associated with a prepared query param: resource $stmt the prepared statement's resource param: bool $free_resource should the PHP resource be freed too? return: bool TRUE on success, FALSE if $result is invalid |
| numRows($result) X-Ref |
| Gets the number of rows in a result set Only works if the DB_PORTABILITY_NUMROWS portability option is turned on. This method is not meant to be called directly. Use DB_result::numRows() instead. It can't be declared "protected" because DB_result is a separate object. param: resource $result PHP's query result resource return: int the number of rows. A DB_Error object on failure. |
| numCols($result) X-Ref |
| Gets the number of columns in a result set This method is not meant to be called directly. Use DB_result::numCols() instead. It can't be declared "protected" because DB_result is a separate object. param: resource $result PHP's query result resource return: int the number of columns. A DB_Error object on failure. |
| prepare($query) X-Ref |
| Prepares a query for multiple execution with execute(). With oci8, this is emulated. prepare() requires a generic query as string like <code> INSERT INTO numbers VALUES (?, ?, ?) </code>. The <kbd>?</kbd> characters are placeholders. Three types of placeholders can be used: + <kbd>?</kbd> a quoted scalar value, i.e. strings, integers + <kbd>!</kbd> value is inserted 'as is' + <kbd>&</kbd> requires a file name. The file's contents get inserted into the query (i.e. saving binary data in a db) Use backslashes to escape placeholder characters if you don't want them to be interpreted as placeholders. Example: <code> "UPDATE foo SET col=? WHERE col='over \& under'" </code> param: string $query the query to be prepared return: mixed DB statement resource on success. DB_Error on failure. |
| execute($stmt, $data = array() X-Ref |
| Executes a DB statement prepared with prepare(). To determine how many rows of a result set get buffered using ocisetprefetch(), see the "result_buffering" option in setOptions(). This option was added in Release 1.7.0. param: resource $stmt a DB statement resource returned from prepare() param: mixed $data array, string or numeric data to be used in return: mixed returns an oic8 result resource for successful SELECT |
| autoCommit($onoff = false) X-Ref |
| Enables or disables automatic commits param: bool $onoff true turns it on, false turns it off return: int DB_OK on success. A DB_Error object if the driver |
| commit() X-Ref |
| Commits the current transaction return: int DB_OK on success. A DB_Error object on failure. |
| rollback() X-Ref |
| Reverts the current transaction return: int DB_OK on success. A DB_Error object on failure. |
| affectedRows() X-Ref |
| Determines the number of rows affected by a data maniuplation query 0 is returned for queries that don't manipulate data. return: int the number of rows. A DB_Error object on failure. |
| modifyQuery($query) X-Ref |
| Changes a query string for various DBMS specific reasons "SELECT 2+2" must be "SELECT 2+2 FROM dual" in Oracle. param: string $query the query string to modify return: string the modified query string |
| modifyLimitQuery($query, $from, $count, $params = array() X-Ref |
| Adds LIMIT clauses to a query string according to current DBMS standards param: string $query the query to modify param: int $from the row to start to fetching (0 = the first row) param: int $count the numbers of rows to fetch param: mixed $params array, string or numeric data to be used in return: string the query string with LIMIT clauses added |
| nextId($seq_name, $ondemand = true) X-Ref |
| Returns the next free id in a sequence param: string $seq_name name of the sequence param: boolean $ondemand when true, the seqence is automatically return: int the next id number in the sequence. |
| createSequence($seq_name) X-Ref |
| Creates a new sequence param: string $seq_name name of the new sequence return: int DB_OK on success. A DB_Error object on failure. |
| dropSequence($seq_name) X-Ref |
| Deletes a sequence param: string $seq_name name of the sequence to be deleted return: int DB_OK on success. A DB_Error object on failure. |
| oci8RaiseError($errno = null) X-Ref |
| Produces a DB_Error object regarding the current problem param: int $errno if the error is being manually raised pass a return: object the DB_Error object |
| errorNative() X-Ref |
| Gets the DBMS' native error code produced by the last query return: int the DBMS' error code. FALSE if the code could not be |
| tableInfo($result, $mode = null) X-Ref |
| Returns information about a table or a result set NOTE: only supports 'table' and 'flags' if <var>$result</var> is a table name. NOTE: flags won't contain index information. param: object|string $result DB_result object from a query or a param: int $mode a valid tableInfo mode return: array an associative array with the information requested. |
| getSpecialQuery($type) X-Ref |
| Obtains the query string needed for listing a given type of objects param: string $type the kind of objects you want to retrieve return: string the SQL query string or null if the driver doesn't |
| quoteFloat($float) X-Ref |
| Formats a float value for use within a query in a locale-independent manner. param: float the float value to be quoted. return: string the quoted string. |
| Généré le : Sun Feb 25 14:08:00 2007 | par Balluche grâce à PHPXref 0.7 |