What is PhpDig?
PhpDig is a PHP MySQL based
Web Spider & Search Engine.



ifx_error — Returns error code of last Informix call


string ifx_error(void)




Returns information about any errors that occurred in the database. These errors can relate to problems such as incorrect logins, through to query execution errors or system errors.

ifx_error() returns a formatted error code from the database according to the following format: X [SQLSTATE=AA BBB SQLCODE=-CCC]. Where:

  • X is a general error condition and can be one either be a space indicating to error, E indicating an error, N indicating no more data (for example, you go beyond the end of the result set), W indicating a warning and ? indicating an undefined error.

  • AA is the SQLSTATE error class an correlates roughly to the general error condition indicated by X. A value of 00 indicates success, 01 indicates a warning, 02 indicates end of data which anything higher indicates a range of general errors.

  • BBB represents the subclass of the errorcode indicated by AAA.

  • CCC or the SQLCODE is a three letter digit indicating the actual type of error that occurred. This can be further expanded upon by calling ifx_errormsg() or by using the 'finderr'

For more information on errors contained in SQLSTATE or SQLCODE, consult your informix documentation.


Since version 3.0.3 and 4.0


Example 561. Check for database errors

function print_error($text) {
   echo "There was an error reported by the database.\n";
   echo "Error reported was: $text";

// try an oncorrect login
if (!$conn = @ifx_connect( "stores7@demo_se", "testuser", "password" )) {

// try an incorrect query
if (!$result = @ifx_query("SELECT customer_num, company FROM customer", $conn)) {
} else {
   while ($row = ifx_fetch_row($result)) {
      printf("%s %s<BR>", $row["customer_num"], $row["company"]);

PHP Functions Essential Reference. Copyright © 2002 by New Riders Publishing (Authors: Zak Greant, Graeme Merrall, Torben Wilson, Brett Michlitsch). This material may be distributed only subject to the terms and conditions set forth in the Open Publication License, v1.0 or later (the latest version is presently available at The authors of this book have elected not to choose any options under the OPL. This online book was obtained from and is designed to provide information about the PHP programming language, focusing on PHP version 4.0.4 for the most part. The information is provided on an as-is basis, and no warranty or fitness is implied. All persons and entities shall have neither liability nor responsibility to any person or entity with respect to any loss or damage arising from the information contained in this book.

Powered by: vBulletin Version 3.0.7
Copyright ©2000 - 2005, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.