 |
|
 PhpDig.net |
What is PhpDig?
PhpDig is a PHP MySQL based Web Spider & Search Engine. |
ifx_error
Description
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'
Example
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";
die();
}
// try an oncorrect login
if (!$conn = @ifx_connect( "stores7@demo_se", "testuser", "password" )) {
print_error(ifx_error());
}
// try an incorrect query
if (!$result = @ifx_query("SELECT customer_num, company FROM customer", $conn)) {
print_error(ifx_error());
} else {
while ($row = ifx_fetch_row($result)) {
printf("%s %s<BR>", $row["customer_num"], $row["company"]);
}
}