PHP MySQLi mysqli_thread_id() - Current Thread ID

mysqli_thread_id()

The mysqli_thread_id() function returns a unique identifier (ID) of the thread for the current connection. This number can later be used with the mysqli_kill() function if you want to terminate a specific session.

EXAMPLE

<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "mysqli_database";

$connection = mysqli_connect($server, $username, $password, $database);

if (!$connection) {
    die("Connection failed: " . mysqli_connect_error());
}

// Retrieve the unique ID of the current session or worker thread on the server
// NOTE: Every open connection to the database receives its own unique thread ID.
// If your script hangs due to a heavy query, an administrator can use this ID 
// to safely terminate only your connection in the terminal or via the mysqli_kill() function, 
// while all other website users continue working uninterrupted.
$thread_id = mysqli_thread_id($connection);

echo "Your current connection (thread) ID is: " . $thread_id;

// Example of how you would forcefully close this specific thread if needed:
// mysqli_kill($connection, $thread_id);

mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: Every connection to the server gets its own ID. If the connection is lost and we reconnect, the number will be different. This function is mainly used for monitoring database performance and troubleshooting long-running queries.

It returns an integer representing the current session.

The ID changes with each new connection establishment.

Essential for use in combination with the mysqli_kill() function.