| [ Index ] |
|
Code source de Dolibarr 2.0.1 |
[Code source] [Imprimer] [Statistiques]
(pas de description)
| Poids: | 786 lignes (26 kb) |
| Inclus ou requis: | 0 fois |
| Référencé: | 0 fois |
| Nécessite: | 0 fichiers |
DB_pgsql:: (24 méthodes):
DB_pgsql()
connect()
disconnect()
simpleQuery()
nextResult()
errorCode()
fetchInto()
freeResult()
quote()
numCols()
numRows()
errorNative()
autoCommit()
commit()
rollback()
affectedRows()
nextId()
createSequence()
dropSequence()
modifyLimitQuery()
pgsqlRaiseError()
_pgFieldFlags()
tableInfo()
getSpecialQuery()
| DB_pgsql() X-Ref |
| Pas de description |
| connect($dsninfo, $persistent = false) X-Ref |
| Connect to a database and log in as the specified user. param: $dsn the data source name (see DB::parseDSN for syntax) param: $persistent (optional) whether the connection should return: int DB_OK on success, a DB error code on failure |
| disconnect() X-Ref |
| Log out and disconnect from the database. return: bool TRUE on success, FALSE if not connected. |
| simpleQuery($query) X-Ref |
| Send a query to PostgreSQL and return the results as a PostgreSQL resource identifier. param: $query the SQL query return: int returns a valid PostgreSQL result for successful SELECT |
| 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 |
| 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 DB error code, or FALSE if this DB |
| fetchInto($result, &$row, $fetchmode, $rownum=null) X-Ref |
| Fetch a row and insert the data into an existing array. param: $result PostgreSQL result identifier param: $row (reference) array where data from the row is stored param: $fetchmode how the array data should be indexed param: $rownum the row number to fetch return: int DB_OK on success, a DB error code on failure |
| freeResult($result) X-Ref |
| Free the internal resources associated with $result. param: $result int PostgreSQL result identifier or DB statement identifier return: bool TRUE on success, FALSE if $result is invalid |
| quote($str = null) X-Ref |
| Quote the given string so it can be safely used within string delimiters in a query. param: $string mixed Data to be quoted return: mixed "NULL" string, quoted string or original data |
| numCols($result) X-Ref |
| Get the number of columns in a result set. param: $result resource PostgreSQL result identifier return: int the number of columns per row in $result |
| numRows($result) X-Ref |
| Get the number of rows in a result set. param: $result resource PostgreSQL result identifier return: int the number of rows in $result |
| errorNative() X-Ref |
| Get the native error code of the last error (if any) that occured on the current connection. return: int native PostgreSQL error code |
| autoCommit($onoff = false) X-Ref |
| Enable/disable automatic commits |
| commit() X-Ref |
| Commit the current transaction. |
| rollback() X-Ref |
| Roll back (undo) the current transaction. |
| affectedRows() X-Ref |
| Gets the number of rows affected by the last query. if the last query was a select, returns 0. return: int number of rows affected by the last query or DB_ERROR |
| nextId($seq_name, $ondemand = true) X-Ref |
| Get the next value in a sequence. We are using native PostgreSQL sequences. If a sequence does not exist, it will be created, unless $ondemand is false. param: string $seq_name the name of the sequence param: bool $ondemand whether to create the sequence on demand return: a sequence integer, or a DB error |
| createSequence($seq_name) X-Ref |
| Create the sequence param: string $seq_name the name of the sequence return: mixed DB_OK on success or DB error on error |
| dropSequence($seq_name) X-Ref |
| Drop a sequence param: string $seq_name the name of the sequence return: mixed DB_OK on success or DB error on error |
| modifyLimitQuery($query, $from, $count) X-Ref |
| Pas de description |
| pgsqlRaiseError($errno = null) X-Ref |
| Pas de description |
| _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", |
| tableInfo($result, $mode = null) X-Ref |
| Returns information about a table or a result set NOTE: doesn't support table name and flags if called from a db_result param: mixed $resource PostgreSQL result identifier or table name param: int $mode A valid tableInfo mode (DB_TABLEINFO_ORDERTABLE or return: array An array with all the information |
| getSpecialQuery($type) X-Ref |
| Returns the query needed to get some backend info param: string $type What kind of info you want to retrieve return: string The SQL query string |
| Généré le : Mon Nov 26 12:29:37 2007 | par Balluche grâce à PHPXref 0.7 |
|
|