mysqli->thread_id -- Returns the thread ID for the current connection
Description
Procedural style:
int mysqli_thread_id ( mysqli link )
Object oriented style (property):
class mysqli {
int thread_id
}
The mysqli_thread_id() function returns the thread ID for the current connection which can then be killed using the mysqli_kill() function. If the connection is lost and you reconnect with mysqli_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.
To kill a running query you can use the SQL command KILL QUERY processid.
Return Values
mysqli_thread_id() returns the Thread ID for the current connection.