db2_conn_error

(PECL ibm_db2 >= 1.0.0)

db2_conn_error Returns a string containing the SQLSTATE returned by the last connection attempt

说明

db2_conn_error ([ resource $connection ] ) : string

db2_conn_error() returns an SQLSTATE value representing the reason the last attempt to connect to a database failed. As db2_connect() returns FALSE in the event of a failed connection attempt, you do not pass any parameters to db2_conn_error() to retrieve the SQLSTATE value.

If, however, the connection was successful but becomes invalid over time, you can pass the connection parameter to retrieve the SQLSTATE value for a specific connection.

To learn what the SQLSTATE value means, you can issue the following command at a DB2 Command Line Processor prompt: db2 '? sqlstate-value'. You can also call db2_conn_errormsg() to retrieve an explicit error message and the associated SQLCODE value.

参数

connection

A connection resource associated with a connection that initially succeeded, but which over time became invalid.

返回值

Returns the SQLSTATE value resulting from a failed connection attempt. Returns an empty string if there is no error associated with the last connection attempt.

范例

Example #1 Retrieving an SQLSTATE value for a failed connection attempt

The following example demonstrates how to return an SQLSTATE value after deliberately passing invalid parameters to db2_connect().

<?php
$conn 
db2_connect('badname''baduser''badpassword');
if (!
$conn) {
    print 
"SQLSTATE value: " db2_conn_error();
}
?>

以上例程会输出:

SQLSTATE value: 08001

参见

相关文章
php eventbufferevent returns string describing the last failed dns lookup attemptphp ibm db2 函数 returns or sets the autocommit state for a database connectionphp ibm db2 函数 returns an object with properties that describe the db2 database clientphp ibm db2 函数 closes a database connectionphp ibm db2 函数 returns a string containing the sqlstate returned by the last connection attemptphp ibm db2 函数 returns the last connection error message and sqlcode valuephp ibm db2 函数 returns a connection to a databasephp ibm db2 函数 returns an array indexed by column name representing a row in a result setphp ibm db2 函数 returns an array indexed by both column name and position representing a row in a result setphp ibm db2 函数 returns an object with properties representing columns in the fetched rowphp ibm db2 函数 returns the auto generated id of the last insert query that successfully executed on this connectionphp ibm db2 函数 returns the number of fields contained in a result setphp ibm db2 函数 returns the number of rows affected by an sql statementphp ibm db2 函数 returns a persistent connection to a databasephp ibm db2 函数 returns a string containing the sqlstate returned by an sql statementphp ibm db2 函数 returns a string containing the last sql statement error messagephp ibm db2 函数 returns a result set listing the tables and associated privileges in a databasephp ibm db2 函数 returns a result set listing the tables and associated metadata in a databasephp eio 函数 returns string describing the last error associated with a request resourcephp maxdb 函数 returns a string description for last statement error
关注编程学问公众号