DB_ifx
The methods PEAR DB uses to interact with PHP's ifx extension for interacting with Informix databases
These methods overload the ones declared in DB_common.
More info on Informix errors can be found at: http://www.informix.com/answers/english/ierrors.htm
TODO:
- set needed env Informix vars on connect
- implement native prepare/execute
Located in /web/lib/external/pear-db/DB/ifx.php (line 54)
PEAR | --DB_common | --DB_ifx
resource
$connection
(line 131)
The raw database connection created by PHP
string
$dbsyntax
= 'ifx' (line 68)
The database syntax variant to be used (db2, access, etc.), if any
array
$dsn
= array() (line 137)
The DSN information for connecting to a database
array
$errorcode_map
= array('-201' => DB_ERROR_SYNTAX,
'-206' => DB_ERROR_NOSUCHTABLE,
'-217' => DB_ERROR_NOSUCHFIELD,
'-236' => DB_ERROR_VALUE_COUNT_ON_ROW,
'-239' => DB_ERROR_CONSTRAINT,
'-253' => DB_ERROR_SYNTAX,
'-268' => DB_ERROR_CONSTRAINT,
'-292' => DB_ERROR_CONSTRAINT_NOT_NULL,
'-310' => DB_ERROR_ALREADY_EXISTS,
'-316' => DB_ERROR_ALREADY_EXISTS,
'-319' => DB_ERROR_NOT_FOUND,
'-329' => DB_ERROR_NODBSELECTED,
'-346' => DB_ERROR_CONSTRAINT,
'-386' => DB_ERROR_CONSTRAINT_NOT_NULL,
'-391' => DB_ERROR_CONSTRAINT_NOT_NULL,
'-554' => DB_ERROR_SYNTAX,
'-691' => DB_ERROR_CONSTRAINT,
'-692' => DB_ERROR_CONSTRAINT,
'-703' => DB_ERROR_CONSTRAINT_NOT_NULL,
'-1202' => DB_ERROR_DIVZERO,
'-1204' => DB_ERROR_INVALID_DATE,
'-1205' => DB_ERROR_INVALID_DATE,
'-1206' => DB_ERROR_INVALID_DATE,
'-1209' => DB_ERROR_INVALID_DATE,
'-1210' => DB_ERROR_INVALID_DATE,
'-1212' => DB_ERROR_INVALID_DATE,
'-1213' => DB_ERROR_INVALID_NUMBER,
) (line 97)
A mapping of native error codes to DB error codes
array
$features
= array('limit' => 'emulate',
'new_link' => false,
'numrows' => 'emulate',
'pconnect' => true,
'prepare' => false,
'ssl' => false,
'transactions' => true,
) (line 83)
The capabilities of this DB implementation
The 'new_link' element contains the PHP version that first provided new_link support for this DBMS. Contains false if it's unsupported.
Meaning of the 'limit' element:
- 'emulate' = emulate with fetch row by number
- 'alter' = alter the query
- false = skip rows
string
$phptype
= 'ifx' (line 62)
The DB driver type (mysql, oci8, odbc, etc.)
Inherited Variables
Inherited from DB_common
Determines the number of rows affected by a data maniuplation query
- is returned for queries that don't manipulate data.
- DB_common::affectedRows()
- Determines the number of rows affected by a data maniuplation query
Enables or disables automatic commits
- bool $onoff: true turns it on, false turns it off
- DB_common::autoCommit()
- Enables or disables automatic commits
Commits the current transaction
- DB_common::commit()
- Commits the current transaction
Connect to the database server, log in and open the database
Don't call this method directly. Use DB::connect() instead.
- array $dsn: the data source name
- bool $persistent: should the connection be persistent?
Maps native error codes to DB's portable ones.
Requires that the DB implementation's constructor fills in the $errorcode_map property.
- string $nativecode: error code returned by the database
- DB_common::errorCode()
- Maps native error codes to DB's portable ones
Gets the DBMS' native error code and message produced by the last query
- DB_common::errorNative()
- Gets the DBMS' native error code produced by the last query
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.
- resource $result: the query result resource
- array $arr: the referenced array to put the data in
- int $fetchmode: how the resulting array should be indexed
- int $rownum: the row number to fetch (0 = first row)
- &$arr
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.
- resource $result: PHP's query result resource
Obtains the query string needed for listing a given type of objects
- string $type: the kind of objects you want to retrieve
- DB_common::getSpecialQuery()
- Obtains the query string needed for listing a given type of objects
Produces a DB_Error object regarding the current problem
- int $errno: if the error is being manually raised pass a DB_ERROR* constant here. If this isn't passed the error information gathered from the DBMS.
Move the internal ifx result pointer to the next available result
- a $result: valid fbsql result resource
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.
- resource $result: PHP's query result resource
Reverts the current transaction
- DB_common::rollback()
- Reverts the current transaction
Sends a query to the database server
- string $query: the SQL query string
Returns information about a table or a result set
NOTE: only supports 'table' if $result is a table name.
If analyzing a query result and the result has duplicate field names, an error will be raised saying can't distinguish duplicate field names.
- object|string $result: DB_result object from a query or a string containing the name of a table. While this also accepts a query result resource identifier, this behavior is deprecated.
- int $mode: a valid tableInfo mode
- DB_common::tableInfo()
- Returns information about a table or a result set
Inherited Methods
Inherited From DB_common
DB_common::DB_common()
DB_common::affectedRows()
Inherited From PEAR
Documentation generated on Wed, 09 Feb 2011 09:01:36 +0700 by phpDocumentor 1.4.2