mysqli_kill
(PHP 5)
mysqli_kill
(no version information, might be only in CVS)
mysqli->kill -- Asks the server to kill a MySQL thread
Description
Procedural style:
bool
mysqli_kill ( object link, int processid)
Object oriented style (method)
class
mysqli {
bool
kill ( int processid)
}
This function is used to ask the server to kill a MySQL thread specified
by the processid parameter. This value must be
retrieved by calling the mysqli_thread_id() function.
Opmerking:
To stop a running query you should use the SQL command
KILL QUERY processid.
Return values
Geeft TRUE terug bij succes, FALSE indien er een fout is opgetreden.
Example
Voorbeeld 1. Object oriented style
<?php $mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); }
/* determine our thread id */ $thread_id = $mysqli->thread_id;
/* Kill connection */ $mysqli->kill($thread_id);
/* This should produce an error */ if (!$mysqli->query("CREATE TABLE myCity LIKE City")) { printf("Error: %s\n", $mysqli->error); exit; }
/* close connection */ $mysqli->close(); ?>
|
|
Voorbeeld 2. Procedural style
<?php $link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); }
/* determine our thread id */ $thread_id = mysqli_thread_id($link);
/* Kill connection */ mysqli_kill($link, $thread_id);
/* This should produce an error */ if (!mysqli_query($link, "CREATE TABLE myCity LIKE City")) { printf("Error: %s\n", mysqli_error($link)); exit; }
/* close connection */ mysqli_close($link); ?>
|
|
The above examples would produce the following output:
Error: MySQL server has gone away |