php man page for mysqli_kill

Query: mysqli_kill

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

MYSQLI_KILL(3)								 1							    MYSQLI_KILL(3)

mysqli::kill - Asks the server to kill a MySQL thread

       Object oriented style

SYNOPSIS
bool mysqli::kill (int $processid)
DESCRIPTION
Procedural style bool mysqli_kill (mysqli $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(3) function. To stop a running query you should use the SQL command KILL QUERY processid.
PARAMETERS
o $ link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1 mysqli::kill example Object oriented style <?php $mysqli = new mysqli("localhost", "my_user", "my_password", "world"); /* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s ", 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 ", $mysqli->error); exit; } /* close connection */ $mysqli->close(); ?> Procedural style <?php $link = mysqli_connect("localhost", "my_user", "my_password", "world"); /* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s ", 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 ", mysqli_error($link)); exit; } /* close connection */ mysqli_close($link); ?> The above examples will output: Error: MySQL server has gone away
SEE ALSO
mysqli_thread_id(3). PHP Documentation Group MYSQLI_KILL(3)
Related Man Pages
mysqli_real_escape_string(3) - php
mysqli_autocommit(3) - php
mysqli_error_list(3) - php
mysqli_insert_id(3) - php
mysqli_warning_count(3) - php
Similar Topics in the Unix Linux Community
how to close an .app without using Kill
Pass Kill with arguments
How to kill the TCP ESTABLISHED connection in netstat
creating multiple threads using single thread id
Kill -3 explanation