MySQL Improved Extension (
Mysqli
)
2429
mysqli_use_result
20.7.3.9.57.
mysqli::$thread_id
,
mysqli_thread_id
Copyright 1997-2012 the PHP Documentation Group. [2230]
•
mysqli::$thread_id
mysqli_thread_id
Returns the thread ID for the current connection
Description
Object oriented style
int
mysqli->thread_id ;
Procedural style
int mysqli_thread_id(
mysqli link);
The
mysqli_thread_id
function returns the thread ID for the current connection which can then be
killed using the
mysqli_kill
function. If the connection is lost and you reconnect with
mysqli_ping
,
the thread ID will be other. Therefore you should get the thread ID only when you need it.
Note
The thread ID is assigned on a connection-by-connection basis. Hence, if the
connection is broken and then re-established a new thread ID will be assigned.
To kill a running query you can use the SQL command
KILL QUERY
processid
.
Parameters
link
Procedural style only: A link identifier returned by
mysqli_connect
or
mysqli_init
Return Values
Returns the Thread ID for the current connection.
Examples
Example 20.146.
$mysqli->thread_id
example
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;
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...