[ Index ]
 

Code source de SPIP Agora 1.4

Accédez au Source d'autres logiciels libresSoutenez Angelica Josefina !

title

Body

[fermer]

/Pear/DB/ -> ifx.php (sommaire)

(pas de description)

Poids: 579 lignes (18 kb)
Inclus ou requis:0 fois
Référencé: 0 fois
Nécessite: 0 fichiers

Définit 1 class

DB_ifx:: (18 méthodes):
  DB_ifx()
  connect()
  disconnect()
  simpleQuery()
  nextResult()
  affectedRows()
  fetchInto()
  numRows()
  numCols()
  freeResult()
  autoCommit()
  commit()
  rollback()
  ifxraiseError()
  errorCode()
  errorNative()
  getSpecialQuery()
  tableInfo()


Classe: DB_ifx  - X-Ref

Database independent query interface definition for PHP's Informix
extension.

DB_ifx()   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 Informix and return the results as a
Informix resource identifier.

param: $query the SQL query
return: int returns a valid Informix result for successful SELECT

nextResult($result)   X-Ref
Move the internal ifx result pointer to the next available result

param: a valid fbsql result resource
return: true if a result is available otherwise return false

affectedRows()   X-Ref
Gets the number of rows affected by the last query.
if the last query was a select, returns 0.

return: number of rows affected by the last query

fetchInto($result, &$arr, $fetchmode, $rownum=null)   X-Ref
Fetch a row and insert the data into an existing array.

Formating of the array and the data therein are configurable.
See DB_result::fetchInto() for more information.

param: resource $result    query result identifier
param: array    $arr       (reference) array where data from the row
param: int      $fetchmode how the resulting array should be indexed
param: int      $rownum    the row number to fetch
return: mixed DB_OK on success, null when end of result set is

numRows($result)   X-Ref
Pas de description

numCols($result)   X-Ref
Get the number of columns in a result set.

param: $result Informix result identifier
return: int the number of columns per row in $result

freeResult($result)   X-Ref
Free the internal resources associated with $result.

param: $result Informix result identifier
return: bool true on success, false if $result is invalid

autoCommit($onoff = true)   X-Ref
Enable/disable automatic commits


commit()   X-Ref
Commit the current transaction.


rollback()   X-Ref
Roll back (undo) the current transaction.


ifxraiseError($errno = null)   X-Ref
Gather information about an error, then use that info to create a
DB error object and finally return that object.

param: integer  $errno  PEAR error number (usually a DB constant) if
return: object  DB error object

errorCode($nativecode)   X-Ref
Map native error codes to DB's portable ones.

Requires that the DB implementation's constructor fills
in the <var>$errorcode_map</var> property.

param: string  $nativecode  error code returned by the database
return: int a portable DB error code, or DB_ERROR if this DB

errorNative()   X-Ref
Get the native error message of the last error (if any) that
occured on the current connection.

return: int native Informix error code

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

tableInfo($result, $mode = null)   X-Ref
Returns information about a table or a result set.

NOTE: only supports 'table' if <var>$result</var> is a table name.

If analyzing a query result and the result has duplicate field names,
an error will be raised saying
<samp>can't distinguish duplicate field names</samp>.

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



Généré le : Sat Feb 24 14:40:03 2007 par Balluche grâce à PHPXref 0.7