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 ( mysqli 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.
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.
Voorbeelden
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); ?>
|
|
Het resultaat van dit script is als volgt:
Error: MySQL server has gone away |