(PHP 5, PHP 7, PHP 8)
mysqli::kill -- mysqli_kill — Asks the server to kill a MySQL thread
This function has been DEPRECATED as of PHP 8.4.0. Relying on this function is highly discouraged.
Nesne yönelimli kullanım
Yordamsal kullanım
This function is used to ask the server to kill a MySQL thread specified
by the process_id
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
.
bağlantı
Sadece yordamsal tarz: mysqli_connect() veya mysqli_init() işlevinden dönen bir mysqli nesnesi.
Eğer mysqli hata bildirimi etkinse (MYSQLI_REPORT_ERROR
)
ve istenen işlem başarısız olursa bir uyarı üretilir. Ek olarak, kip
MYSQLI_REPORT_STRICT
ise bunun yerine
mysqli_sql_exception istisnası oluşur.
Sürüm: | Açıklama |
---|---|
8.4.0 |
Both mysqli::kill() and
mysqli_kill() are now deprecated. Use the
KILL SQL command instead.
|
Örnek 1 mysqli::kill() example
Nesne yönelimli kullanım
<?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();
?>
Yordamsal kullanım
<?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);
?>
Yukarıdaki örneklerin çıktısı:
Error: MySQL server has gone away