Question

How to kill MySQLi connection thread (kill the connection) in PHP

Answer 1

$db_host        = 'localhost';
$db_user        = 'root';
$db_password    = '';
$db_name        = 'allonpage';
  
$con = new mysqli('localhost', $db_user, $db_password, $db_name);
  
if ($con->connect_error) 
    die('Connection Error: ' . $con->server_info);
  
$thread_id = $con->thread_id;
echo $thread_id . "<br />";

$con->kill($thread_id);

if (!$con->query("SELECT * FROM images")) 
{
    echo "Error: " . $con->error;
    exit;
}
                                   
$con->close();
 
/*
run: 

4267
Error: MySQL server has gone away
 
*/

 

70+ SQL courses for beginners and professionals