(PECL maxdb >= 1.0)
Returns the thread ID for the current connection
int maxdb_thread_id ( resource $link )
Procedural style
Object oriented style
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.
Returns:
maxdb_thread_id() returns the Thread ID for the current connection.
Examples:
Object oriented style
<?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(); ?>
Procedural style
<?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); ?>
See also:
Please login to continue.