PHP Tutorial





Español Français 中文 Deutsch Portuguese Japanese nederlands
   
 
PHP Topics
Introduction Introduction
Syntax Syntax
Data Types Data Types
Operators Operators
Control Structures Control Structures
Functions Functions
Pre-defined Function Pre-defined Function
Calendar Functions Calendar Functions
Date and Time Date and Time
Array Functions Array Functions
Array List Array Functions List1
Array Function List Array Functions List2
Math Functions Math Functions
PHP MYSQL Functions PHP Mysql Functions
File Handling File Handling
Error Handling Error Handling
DB Size DB Size
PHP Mail PHP Mail
String Tokens String Tokens
String Functions String Functions
String Functions List String Functions List1
String Functions List2 String Functions List2
Session Functions Session Functions
Cookies Functions Cookies Functions
Form Variables Form Variables
Running PHP from JS Running PHP from JS
Array To JS Array To JS
JS Array Array to PHP
Encryption Encryption
Common Header Common Header
Forums Ask Your Doubts
Scraps More about PHP
Feedback Feedback
 




mysql_list_processes() function in PHP


Tutorials »Php »

Topic

What is mysql_list_processes() function in PHP?
How does mysql_list_processes() works?




Explanation

The mysql_list_processes() function list MySQL processes.

Syntax

resource mysql_list_processes ( [resource link_identifier])

Returns a result pointer containing the current processes on success, or FALSE on failure.

The mysql_list_processes() function returns result pointer containing current MySQL connection processes.

Example


<?php

//Attempt to connect to the default database server
$link = mysql_connect("mysql_host", "mysql_user", "mysql_password")
or die ("Could not connect");

//select database
mysql_select_db("my_database", $link);

//retrieves process information
$my_list = mysql_list_processes($link);

//list process information
while ($row = mysql_fetch_assoc($my_list))
{
print_r($row);
}
?>



RESULT:

Array
(
[Id] => 12
[User] => root
[Host] => localhost:2484
[db] => my_database
[Command] => Processlist
[Time] => 0
[State] =>
[Info] =>
)


See also: mysql_thread_id().





Other Links

web hosting