| [ Index ] |
|
Code source de PHP PEAR 1.4.5 |
[Code source] [Imprimer] [Statistiques]
(pas de description)
| Poids: | 1474 lignes (54 kb) |
| Inclus ou requis: | 0 fois |
| Référencé: | 1 fois |
| Nécessite: | 1 fichier MDB/Common.php |
MDB_pgsql:: (45 méthodes):
MDB_pgsql()
errorCode()
pgsqlRaiseError()
errorNative()
autoCommit()
commit()
rollback()
_doConnect()
connect()
_close()
_doQuery()
_standaloneQuery()
query()
getColumnNames()
numCols()
endOfResult()
fetch()
_retrieveLob()
endOfResultLob()
_readResultLob()
_destroyResultLob()
fetchClob()
fetchBlob()
convertResult()
resultIsNull()
numRows()
freeResult()
getTextDeclaration()
getClobDeclaration()
getBlobDeclaration()
getDateDeclaration()
getTimeDeclaration()
getFloatDeclaration()
getDecimalDeclaration()
_getLobValue()
getClobValue()
getBlobValue()
getFloatValue()
getDecimalValue()
nextId()
currId()
fetchInto()
nextResult()
tableInfo()
_pgFieldFlags()
| MDB_pgsql() X-Ref |
| Constructor |
| errorCode($errormsg) X-Ref |
| Map native error codes to DB's portable ones. Requires that the DB implementation's constructor fills in the $errorcode_map property. param: $nativecode the native error code, as returned by the backend return: int a portable MDB error code, or FALSE if this DB |
| pgsqlRaiseError($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 |
| errorNative() X-Ref |
| Get the native error code of the last error (if any) that occured on the current connection. return: int native pgsql error code |
| 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 |
| _doConnect($database_name, $persistent) X-Ref |
| Does the grunt work of connecting to the database return: mixed connection resource on success, MDB_Error on failure |
| connect() X-Ref |
| Connect to the database return: TRUE on success, MDB_Error on failure |
| _close() X-Ref |
| Close the database connection return: boolean |
| _doQuery($query) X-Ref |
| Execute a query param: string $query the SQL query return: mixed result identifier if query executed, else MDB_error |
| _standaloneQuery($query) X-Ref |
| execute a query param: string $query return: |
| 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 result identifier if query executed, else MDB_error |
| getColumnNames($result) X-Ref |
| Retrieve the names of columns returned by the DBMS in a query result. param: resource $result result identifier return: mixed 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 |
| _retrieveLob($lob) X-Ref |
| fetch a float 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 |
| endOfResultLob($lob) X-Ref |
| Determine whether it was reached the end of the large object and therefore there is no more data to be read for the its input stream. param: int $lob handle to a lob created by the createLob() function return: mixed TRUE or FALSE on success, a MDB error on failure |
| _readResultLob($lob, &$data, $length) X-Ref |
| Read data from large object input stream. param: int $lob handle to a lob created by the createLob() function param: blob $data reference to a variable that will hold data to be param: int $length integer value that indicates the largest ammount of return: mixed length on success, a MDB error on failure |
| _destroyResultLob($lob) X-Ref |
| Free any resources allocated during the lifetime of the large object handler object. param: int $lob handle to a lob created by the createLob() function |
| 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 or a MDB error on failure |
| resultIsNull($result, $row, $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 $row 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| _getLobValue($prepared_query, $parameter, $lob) 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: $lob return: string text string that represents the given argument value in |
| 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 |
| 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 |
| 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 ignored 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 pgsql result pointer to the next available result param: a valid fbsql 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: mixed $resource PostgreSQL result identifier or table name param: mixed $mode depends on implementation return: array an nested array, or a MDB error |
| _pgFieldFlags($resource, $num_field, $table_name) X-Ref |
| Flags of a Field param: int $resource PostgreSQL result identifier param: int $num_field the field number return: string The flags of the field ('not_null', 'default_xx', 'primary_key', |
| Généré le : Sun Feb 25 14:08:00 2007 | par Balluche grâce à PHPXref 0.7 |