mysql_get_server_info(3) [php man page]

MYSQL_GET_SERVER_INFO(3)						 1						  MYSQL_GET_SERVER_INFO(3)

mysql_get_server_info - Get MySQL server info

SYNOPSIS

       Warning

	      This  extension  is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
	      be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:

		     omysqli_get_server_info(3)

		     o PDO::getAttribute

       string mysql_get_server_info ([resource	$link_identifier = NULL])

DESCRIPTION

	Retrieves the MySQL server version.

	      o $
		link_identifier -The MySQL connection. If the link identifier is not specified,  the  last  link  opened  by  mysql_connect(3)	is
		assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
		is found or established, an E_WARNING level error is generated.

	Returns the MySQL server version on success or FALSE on failure.

       Example #1

	      mysql_get_server_info(3) example

	      <?php
	      $link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
	      if (!$link) {
		  die('Could not connect: ' . mysql_error());
	      }
	      printf("MySQL server version: %s
", mysql_get_server_info());
	      ?>

	      The above example will output something similar to:

	      MySQL server version: 4.0.1-alpha

       mysql_get_client_info(3), mysql_get_host_info(3), mysql_get_proto_info(3), phpversion(3).

PHP Documentation Group 												  MYSQL_GET_SERVER_INFO(3)

MYSQL_LIST_PROCESSES(3) 						 1						   MYSQL_LIST_PROCESSES(3)

mysql_list_processes - List MySQL processes

SYNOPSIS

       Warning

	      This  extension  is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
	      be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:

		     omysqli_thread_id(3)

       resource mysql_list_processes ([resource  $link_identifier = NULL])

DESCRIPTION

	Retrieves the current MySQL server threads.

	      o $
		link_identifier -The MySQL connection. If the link identifier is not specified,  the  last  link  opened  by  mysql_connect(3)	is
		assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
		is found or established, an E_WARNING level error is generated.

	A result pointer resource on success or FALSE on failure.

       Example #1

	      mysql_list_processes(3) example

	      <?php
	      $link = mysql_connect('localhost', 'mysql_user', 'mysql_password');

	      $result = mysql_list_processes($link);
	      while ($row = mysql_fetch_assoc($result)){
		  printf("%s %s %s %s %s
", $row["Id"], $row["Host"], $row["db"],
		      $row["Command"], $row["Time"]);
	      }
	      mysql_free_result($result);
	      ?>

	      The above example will output something similar to:

	      1 localhost test Processlist 0
	      4 localhost mysql sleep 5

       mysql_thread_id(3), mysql_stat(3).

PHP Documentation Group 												   MYSQL_LIST_PROCESSES(3)