maxdb_thread_id

maxdb::thread_id

(PECL maxdb >= 1.0)

maxdb_thread_id -- maxdb::thread_idReturns the thread ID for the current connection

说明

过程化风格

maxdb_thread_id ( resource $link ) : int

面向对象风格

int $maxdb->thread_id;

The maxdb_thread_id() function returns the thread ID for the current connection which can then be killed using the maxdb_kill() function. If the connection is lost and you reconnect with maxdb_ping(), the thread ID will be other. Therefore you should get the thread ID only when you need it.

Note:

The thread ID is assigned on a connection-by-connection basis. Hence, if the connection is broken and then re-established a new thread ID will be assigned.

返回值

maxdb_thread_id() returns the Thread ID for the current connection.

范例

Example #1 面向对象风格

<?php
$maxdb 
= new maxdb("localhost""MONA""RED""DEMODB");

/* check connection */
if (maxdb_connect_errno()) {
   
printf("Connect failed: %s\n"maxdb_connect_error());
   exit();
}

/* determine our thread id */
$thread_id $maxdb->thread_id;

/* Kill connection */
$maxdb->kill($thread_id);

/* This should produce an error */
if (!$maxdb->query("CREATE TABLE mycity LIKE hotel.city")) {
   
printf("Error: %s\n"$maxdb->error);
   exit;
}

/* close connection */
$maxdb->close();
?>

Example #2 过程化风格

<?php
$link 
maxdb_connect("localhost""MONA""RED""DEMODB");

/* check connection */
if (maxdb_connect_errno()) {
   
printf("Connect failed: %s\n"maxdb_connect_error());
   exit();
}

/* determine our thread id */
$thread_id maxdb_thread_id($link);

/* Kill connection */
maxdb_kill($link$thread_id);

/* This should produce an error */
if (!maxdb_query($link"CREATE TABLE mycity LIKE hotel.city")) {
   
printf("Error: %s\n"maxdb_error($link));
   exit;
}

/* close connection */
maxdb_close($link);
?>

以上例程的输出类似于:

Warning: maxdb_query(): -10821 Session not connected <...>
Error: Session not connected

参见

相关文章
php ibm db2 函数 returns a string containing the sqlstate returned by the last connection attemptphp ibm db2 函数 returns the auto generated id of the last insert query that successfully executed on this connectionphp maxdb 函数 returns the default character set for the database connectionphp maxdb 函数 closes a previously opened database connectionphp maxdb 函数 commits the current transactionphp maxdb 函数 returns the error code from last connect callphp maxdb 函数 returns the lengths of the columns of the current row in the result setphp maxdb 函数 returns the current row of a result set as an objectphp maxdb 函数 returns a string representing the type of connection usedphp maxdb 函数 returns the auto generated id used in the last queryphp maxdb 函数 pings a server connection or tries to reconnect if the connection has gone downphp maxdb 函数 escapes special characters in a string for use in an sql statement taking into account the current charset of the connectionphp maxdb 函数 initializes a statement and returns an resource for use with maxdb stmt preparephp maxdb 函数 returns the thread id for the current connectionphp maxdb 函数 returns whether thread safety is given or notphp mysqlnd ms 函数 returns an array which describes the last used connectionphp mysqlnd ms 函数 returns query distribution and connection statisticsphp odbc 函数 returns information about a current connectionphp postgresql 函数 returns the type id oid for the corresponding field numberphp mysqlnduhconnection returns the thread id for the current connection
关注编程学问公众号