PHP Informix Functions

EditRocket provides the following information on Informix functions in the PHP source code builder.

int ifx_affected_rows ( resource $result_id ) - Returns the number of rows affected by a query associated with result_id.

bool ifx_blobinfile_mode ( int $mode ) - Set the default blob mode for all select queries.

bool ifx_byteasvarchar ( int $mode ) - Sets the default byte mode for all select-queries.

bool ifx_close ([ resource $link_identifier ] ) - ifx_close() closes the link to an Informix database that's associated with the specified link identifier.

resource ifx_connect ([ string $database [, string $userid [, string $password ]]] ) - ifx_connect() establishes a connection to an Informix server.

int ifx_copy_blob ( int $bid ) - Duplicates the given blob object.

int ifx_create_blob ( int $type , int $mode , string $param ) - Creates a blob object.

int ifx_create_char ( string $param ) - Creates an char object.

bool ifx_do ( resource $result_id ) - Executes a previously prepared query or opens a cursor for it.

string ifx_error ([ resource $link_identifier ] ) - Returns in a string one character describing the general results of a statement and both SQLSTATE and SQLCODE associated with the most recent SQL statement executed.

string ifx_errormsg ([ int $errorcode ] ) - Returns the Informix error message associated with the most recent Informix error.

array ifx_fetch_row ( resource $result_id [, mixed $position ] ) - Fetches one row of data from the result associated with the specified result identifier.

array ifx_fieldproperties ( resource $result_id ) - Returns the Informix SQL fieldproperties of every field in the query as an associative array. Properties are encoded as: SQLTYPE;length;precision;scale;ISNULLABLE where SQLTYPE = the Informix type like SQLVCHAR etc. and ISNULLABLE = Y or N.

array ifx_fieldtypes ( resource $result_id ) - Returns an associative array with fieldnames as key and the SQL fieldtypes as data for the query associated with result_id.

bool ifx_free_blob ( int $bid ) - Deletes the blobobject for the given blob object-id.

bool ifx_free_char ( int $bid ) - Deletes the charobject for the given char object-id.

bool ifx_free_result ( resource $result_id ) - Releases resources for the query associated with result_id.

string ifx_get_blob ( int $bid ) - Returns the content of the blob object.

string ifx_get_char ( int $bid ) - Returns the content of the char object.

array ifx_getsqlca ( resource $result_id ) - Returns a pseudo-row with sqlca.sqlerrd[0] ... sqlca.sqlerrd[5] after the query associated with result_id.

int ifx_htmltbl_result ( resource $result_id [, string $html_table_options ] ) - Formats and prints all rows of the result_id query into a HTML table.

bool ifx_nullformat ( int $mode ) - Sets the default return value of a NULL-value on a fetch row.

int ifx_num_fields ( resource $result_id ) - After preparing or executing a query, this call gives you the number of columns in the query.

int ifx_num_rows ( resource $result_id ) -

resource ifx_pconnect ([ string $database [, string $userid [, string $password ]]] ) -

resource ifx_prepare ( string $query , resource $link_identifier [, int $cursor_def ], mixed $blobidarray ) -

resource ifx_query ( string $query , resource $link_identifier [, int $cursor_type [, mixed $blobidarray ]] ) - Sends a query to the currently active database on the server that's associated with the specified link identifier.

bool ifx_textasvarchar ( int $mode ) - Sets the default text mode for all select-queries.

bool ifx_update_blob ( int $bid , string $content ) - Updates the content of the blob object for the given blob object bid.

bool ifx_update_char ( int $bid , string $content ) - Updates the content of the char object for the given char object bid.

bool ifxus_close_slob ( int $bid ) - Deletes the slob object on the given slob object-id bid.

int ifxus_create_slob ( int $mode ) - Creates an slob object and opens it.

bool ifxus_free_slob ( int $bid ) - Deletes the slob object.

int ifxus_open_slob ( int $bid , int $mode ) - Opens an slob object. bid should be an existing slob id.

string ifxus_read_slob ( int $bid , int $nbytes ) - Reads nbytes of the slob object.

int ifxus_seek_slob ( int $bid , int $mode , int $offset ) - Sets the current file or seek position of an open slob object.

int ifxus_tell_slob ( int $bid ) - Returns the current file or seek position of an open slob object

int ifxus_write_slob ( int $bid , string $content ) - Writes a string into the slob object.