| [ Index ] |
|
Code source de PHP PEAR 1.4.5 |
[Code source] [Imprimer] [Statistiques]
(pas de description)
| Poids: | 1557 lignes (56 kb) |
| Inclus ou requis: | 0 fois |
| Référencé: | 1 fois |
| Nécessite: | 1 fichier MDB/Common.php |
MDB_mysql:: (40 méthodes):
MDB_mysql()
errorNative()
mysqlRaiseError()
quoteIdentifier()
autoCommit()
commit()
rollback()
connect()
_close()
query()
subSelect()
replace()
getColumnNames()
numCols()
endOfResult()
fetch()
fetchClob()
fetchBlob()
convertResult()
numRows()
freeResult()
getIntegerDeclaration()
getClobDeclaration()
getBlobDeclaration()
getDateDeclaration()
getTimestampDeclaration()
getTimeDeclaration()
getFloatDeclaration()
getDecimalDeclaration()
getClobValue()
freeClobValue()
getBlobValue()
freeBlobValue()
getFloatValue()
getDecimalValue()
nextId()
currId()
fetchInto()
nextResult()
tableInfo()
| MDB_mysql() X-Ref |
| Constructor |
| errorNative() X-Ref |
| Get the native error code of the last error (if any) that occured on the current connection. return: int native MySQL error code |
| mysqlRaiseError($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 |
| quoteIdentifier($str) X-Ref |
| Quote a string so it can be safely used as a table or column name Quoting style depends on which database driver is being used. MySQL can't handle the backtick character (<kbd>`</kbd>) in table or column names. param: string $str identifier name to be quoted return: string quoted identifier string |
| 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() 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 return: boolean |
| query($query, $types = NULL) X-Ref |
| Send a query to the database and return any results param: string $query the SQL query param: mixed $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 |
| subSelect($query, $quote = FALSE) X-Ref |
| simple subselect emulation for Mysql param: string $query the SQL query for the subselect that may only param: string $quote determines if the data needs to be quoted before return: string the query |
| replace($table, $fields) X-Ref |
| 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. The REPLACE type of query does not make part of the SQL standards. Since practically only MySQL implements it natively, this type of query is emulated through this method for other DBMS using standard types of queries inside a transaction to assure the atomicity of the operation. param: string $table name of the table on which the REPLACE query will param: array $fields associative array that describes the fields and the return: mixed 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 |
| fetch($result, $row, $field) X-Ref |
| fetch 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 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 |
| 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: boolean TRUE on success, FALSE if $result is invalid |
| 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 |
| 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 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 |
| getDateDeclaration($name, $field) X-Ref |
| Obtain DBMS specific SQL code portion needed to declare an 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 an timestamp 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 |
| getTimeDeclaration($name, $field) X-Ref |
| Obtain DBMS specific SQL code portion needed to declare an time 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 |
| getFloatDeclaration($name, $field) X-Ref |
| Obtain DBMS specific SQL code portion needed to declare an 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 an 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) X-Ref |
| free a character large object param: resource $prepared_query query handle from prepare() param: string $clob return: MDB_OK |
| 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) X-Ref |
| free a binary large object param: resource $prepared_query query handle from prepare() param: string $blob return: MDB_OK |
| 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 insert the data into an existing 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: int data array on success, a MDB error on failure |
| nextResult($result) X-Ref |
| Move the internal mysql result pointer to the next available result Currently not supported param: a 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 |