| [ Index ] |
|
Code source de PHP PEAR 1.4.5 |
[Code source] [Imprimer] [Statistiques]
The PEAR DB driver for PHP's fbsql extension for interacting with FrontBase databases PHP versions 4 and 5
| Author: | Frank M. Kromann <frank@frontbase.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: fbsql.php,v 1.86 2007/01/12 03:11:17 aharvey Exp $ |
| Poids: | 769 lignes (23 kb) |
| Inclus ou requis: | 0 fois |
| Référencé: | 3 fois |
| Nécessite: | 1 fichier DB/common.php |
DB_fbsql:: (23 méthodes):
DB_fbsql()
connect()
disconnect()
simpleQuery()
nextResult()
fetchInto()
freeResult()
autoCommit()
commit()
rollback()
numCols()
numRows()
affectedRows()
nextId()
createSequence()
dropSequence()
modifyLimitQuery()
quoteBoolean()
quoteFloat()
fbsqlRaiseError()
errorNative()
tableInfo()
getSpecialQuery()
| DB_fbsql() 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. 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 param: string the SQL query string return: mixed + a PHP result resrouce for successful SELECT queries |
| nextResult($result) X-Ref |
| Move the internal fbsql result pointer to the next available result param: a valid fbsql 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 |
| 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. |
| 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. |
| numRows($result) X-Ref |
| Gets the number of rows in a result set 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. |
| 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. |
| 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. |
| 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 |
| quoteBoolean($boolean) X-Ref |
| Formats a boolean value for use within a query in a locale-independent manner. param: boolean the boolean value to be quoted. return: string the quoted string. |
| 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. |
| fbsqlRaiseError($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 |
| tableInfo($result, $mode = null) X-Ref |
| Returns information about a table or a result set 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 |
| Généré le : Sun Feb 25 14:08:00 2007 | par Balluche grâce à PHPXref 0.7 |