PHP mysql_list_processes() Function
Complete PHP MySQL Reference
Definition and Usage
The mysql_list_processes() function finds current MySQL connection processes.
This function returns a result pointer containing the current processes
on success, or FALSE on failure.
Syntax
mysql_list_processes(connection)
|
Parameter |
Description |
connection |
Optional. Specifies the MySQL connection. If not specified,
the last connection opened by mysql_connect() or mysql_pconnect() is used. |
Example
<?php
$con = mysql_connect("localhost", "peter", "abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$my_list = mysql_list_processes($con);
while ($row = mysql_fetch_assoc($my_list))
{
print_r($row);
}
mysql_close($con);
?>
|
The output of the code above could be:
Array
(
[Id] => 2
[User] => peter
[Host] => localhost:1038
[db] =>
[Command] => Processlist
[Time] => 0
[State] =>
[Info] =>
)
|
Complete PHP MySQL Reference
|
|
|