| [ Index ] |
|
Code source de PHP PEAR 1.4.5 |
[Code source] [Imprimer] [Statistiques]
The PEAR DB driver for PHP's msql extension for interacting with Mini SQL databases PHP's mSQL extension did weird things with NULL values prior to PHP 4.3.11 and 5.0.4. Make sure your version of PHP meets or exceeds those versions.
| 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: msql.php,v 1.62 2007/01/12 03:11:17 aharvey Exp $ |
| Poids: | 831 lignes (25 kb) |
| Inclus ou requis: | 0 fois |
| Référencé: | 3 fois |
| Nécessite: | 1 fichier DB/common.php |
DB_msql:: (21 méthodes):
DB_msql()
connect()
disconnect()
simpleQuery()
nextResult()
fetchInto()
freeResult()
numCols()
numRows()
affectedRows()
nextId()
createSequence()
dropSequence()
quoteIdentifier()
quoteFloat()
escapeSimple()
msqlRaiseError()
errorNative()
errorCode()
tableInfo()
getSpecialQuery()
| DB_msql() 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. Example of how to connect: <code> require_once 'DB.php'; // $dsn = 'msql://hostname/dbname'; // use a TCP connection $dsn = 'msql:///dbname'; // use a socket $options = array( 'portability' => DB_PORTABILITY_ALL, ); $db =& DB::connect($dsn, $options); if (PEAR::isError($db)) { die($db->getMessage()); } </code> 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 msql 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. PHP's mSQL extension did weird things with NULL values prior to PHP 4.3.11 and 5.0.4. Make sure your version of PHP meets or exceeds those versions. 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 |
| 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 Also creates a new table to associate the sequence with. Uses a separate table to ensure portability with other drivers. 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. |
| quoteIdentifier($str) X-Ref |
| mSQL does not support delimited identifiers param: string $str the identifier name to be quoted return: object a DB_Error object |
| 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. |
| escapeSimple($str) X-Ref |
| Escapes a string according to the current DBMS's standards param: string $str the string to be escaped return: string the escaped string |
| msqlRaiseError($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 message produced by the last query return: string the DBMS' error message |
| errorCode($errormsg) X-Ref |
| Determines PEAR::DB error code from the database's text error message param: string $errormsg the error message returned from the database return: integer the error number from a DB_ERROR* constant |
| 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 |
| Obtain a list of a given type of objects param: string $type the kind of objects you want to retrieve return: array the array containing the list of objects requested |
| Généré le : Sun Feb 25 14:08:00 2007 | par Balluche grâce à PHPXref 0.7 |