©
Ce document utilise Manuel du site Web PHP chinois Libérer
(PHP 5)
mysqli::kill -- mysqli_kill — Asks the server to kill a MySQL thread
面向对象风格
$processid
)过程化风格
$link
, 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.
link
仅以过程化样式:由 mysqli_connect() 或 mysqli_init() 返回的链接标识。
成功时返回 TRUE
, 或者在失败时返回 FALSE
。
Example #1 mysqli::kill() example
面向对象风格
<?php
$mysqli = new mysqli ( "localhost" , "my_user" , "my_password" , "world" );
if ( mysqli_connect_errno ()) {
printf ( "Connect failed: %s\n" , mysqli_connect_error ());
exit();
}
$thread_id = $mysqli -> thread_id ;
$mysqli -> kill ( $thread_id );
if (! $mysqli -> query ( "CREATE TABLE myCity LIKE City" )) {
printf ( "Error: %s\n" , $mysqli -> error );
exit;
}
$mysqli -> close ();
?>
过程化风格
<?php
$link = mysqli_connect ( "localhost" , "my_user" , "my_password" , "world" );
if ( mysqli_connect_errno ()) {
printf ( "Connect failed: %s\n" , mysqli_connect_error ());
exit();
}
$thread_id = mysqli_thread_id ( $link );
mysqli_kill ( $link , $thread_id );
if (! mysqli_query ( $link , "CREATE TABLE myCity LIKE City" )) {
printf ( "Error: %s\n" , mysqli_error ( $link ));
exit;
}
mysqli_close ( $link );
?>
以上例程会输出:
Error: MySQL server has gone away