mysql_close(3) [php man page]

MYSQL_CLOSE(3)								 1							    MYSQL_CLOSE(3)

mysql_close - Close MySQL connection

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_close(3)

		     oPDO: Assign the value of
		       NULL to the PDO object

       bool mysql_close ([resource  $link_identifier = NULL])

DESCRIPTION

       mysql_close(3) closes the non-persistent connection to  the  MySQL  server  that's  associated  with  the  specified  link  identifier.	If
       $link_identifier isn't specified, the last opened link is used.

	Using  mysql_close(3) isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution.
       See also freeing resources.

	      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 connection is found or established, an E_WARNING level error is generated.

	Returns TRUE on success or FALSE on failure.

       Example #1

	      mysql_close(3) example

	      <?php
	      $link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
	      if (!$link) {
		  die('Could not connect: ' . mysql_error());
	      }
	      echo 'Connected successfully';
	      mysql_close($link);
	      ?>

	      The above example will output:

	      Connected successfully

       Note

	      mysql_close(3) will not close persistent links created by mysql_pconnect(3).

       mysql_connect(3), mysql_free_result(3).

PHP Documentation Group 													    MYSQL_CLOSE(3)

MYSQL_CONNECT(3)							 1							  MYSQL_CONNECT(3)

mysql_connect - Open a connection to a MySQL Server

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_connect(3)

		     o PDO::__construct

       resource mysql_connect ([string	$server = ini_get("mysql.default_host")], [string   $username  =  ini_get("mysql.default_user")],  [string
       $password = ini_get("mysql.default_password")], [bool  $new_link = false], [int	$client_flags])

DESCRIPTION

	Opens or reuses a connection to a MySQL server.

	      o $server
		-  The	MySQL  server. It can also include a port number. e.g. "hostname:port" or a path to a local socket e.g. ":/path/to/socket"
		for the localhost.  If the PHP directive  mysql.default_host is undefined (default), then the default value  is  'localhost:3306'.
		In SQL safe mode, this parameter is ignored and value 'localhost:3306' is always used.

	      o $username
		-  The	username.  Default value is defined by mysql.default_user. In SQL safe mode, this parameter is ignored and the name of the
		user that owns the server process is used.

	      o $password
		- The password. Default value is defined by mysql.default_password. In SQL safe mode, this parameter is ignored and empty password
		is used.

	      o $new_link
		-  If  a  second  call is made to mysql_connect(3) with the same arguments, no new link will be established, but instead, the link
		identifier of the already opened link will be returned. The $new_link parameter modifies this behavior and makes  mysql_connect(3)
		always	open  a new link, even if mysql_connect(3) was called before with the same parameters. In SQL safe mode, this parameter is
		ignored.

	      o $client_flags
		- The $client_flags parameter can  be  a  combination  of  the	following  constants:  128  (enable  LOAD  DATA  LOCAL	handling),
		MYSQL_CLIENT_SSL,  MYSQL_CLIENT_COMPRESS,  MYSQL_CLIENT_IGNORE_SPACE  or  MYSQL_CLIENT_INTERACTIVE.  Read the section about "MySQL
		client constants" for further information. In SQL safe mode, this parameter is ignored.

	Returns a MySQL link identifier on success or FALSE on failure.

       +--------+---------------------------------------------------+
       |Version |						    |
       |	|						    |
       |	|		     Description		    |
       |	|						    |
       +--------+---------------------------------------------------+
       | 5.5.0	|						    |
       |	|						    |
       |	|  This  function  will  generate  an  E_DEPRECATED |
       |	| error.					    |
       |	|						    |
       | 4.3.0	|						    |
       |	|						    |
       |	|	  Added the $client_flags parameter.	    |
       |	|						    |
       | 4.2.0	|						    |
       |	|						    |
       |	|	    Added the $new_link parameter.	    |
       |	|						    |
       +--------+---------------------------------------------------+
       Example #1

	      mysql_connect(3) example

	      <?php
	      $link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
	      if (!$link) {
		  die('Could not connect: ' . mysql_error());
	      }
	      echo 'Connected successfully';
	      mysql_close($link);
	      ?>

       Example #2

	      mysql_connect(3) example using hostname:port syntax

	      <?php
	      // we connect to example.com and port 3307
	      $link = mysql_connect('example.com:3307', 'mysql_user', 'mysql_password');
	      if (!$link) {
		  die('Could not connect: ' . mysql_error());
	      }
	      echo 'Connected successfully';
	      mysql_close($link);

	      // we connect to localhost at port 3307
	      $link = mysql_connect('127.0.0.1:3307', 'mysql_user', 'mysql_password');
	      if (!$link) {
		  die('Could not connect: ' . mysql_error());
	      }
	      echo 'Connected successfully';
	      mysql_close($link);
	      ?>

       Example #3

	      mysql_connect(3) example using ":/path/to/socket" syntax

	      <?php
	      // we connect to localhost and socket e.g. /tmp/mysql.sock

	      // variant 1: omit localhost
	      $link = mysql_connect(':/tmp/mysql', 'mysql_user', 'mysql_password');
	      if (!$link) {
		  die('Could not connect: ' . mysql_error());
	      }
	      echo 'Connected successfully';
	      mysql_close($link);

	      // variant 2: with localhost
	      $link = mysql_connect('localhost:/tmp/mysql.sock', 'mysql_user', 'mysql_password');
	      if (!$link) {
		  die('Could not connect: ' . mysql_error());
	      }
	      echo 'Connected successfully';
	      mysql_close($link);
	      ?>

       Note

	       Whenever you specify "localhost" or "localhost:port" as server, the MySQL client library will override this and try to connect to a
	      local socket (named pipe on Windows). If you want to use TCP/IP, use "127.0.0.1" instead of "localhost". If the MySQL client library
	      tries  to  connect  to  the wrong local socket, you should set the correct path as "" in your PHP configuration and leave the server
	      field blank.

       Note

	       The link to the server will be closed as soon as the execution of the script ends, unless it's closed earlier by explicitly calling
	      mysql_close(3).

       Note

	       You can suppress the error message on failure by prepending a @ to the function name.

       Note

	       Error  "Can't create TCP/IP socket (10106)" usually means that the variables_order configure directive doesn't contain character E.
	      On Windows, if the environment is not copied the SYSTEMROOT environment variable won't be available and PHP will have problems load-
	      ing Winsock.

       mysql_pconnect(3), mysql_close(3).

PHP Documentation Group 													  MYSQL_CONNECT(3)