mssql_pconnect(3) [php man page]

MSSQL_PCONNECT(3)														 MSSQL_PCONNECT(3)

mssql_pconnect - Open persistent MS SQL connection

SYNOPSIS

       resource mssql_pconnect ([string  $servername], [string	$username], [string  $password], [bool	$new_link = false])

DESCRIPTION

       mssql_pconnect(3) acts very much like mssql_connect(3) with two major differences.

	First,	when  connecting,  the	function  would first try to find a (persistent) link that's already open with the same host, username and
       password. If one is found, an identifier for it will be returned instead of opening a new connection.

	Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open  for
       future use (mssql_close(3) will not close links established by mssql_pconnect(3)).

	This type of links is therefore called 'persistent'.

PARAMETERS

	      o $servername
		- The MS SQL server. It can also include a port number. e.g.  hostname:port.

	      o $username
		- The username.

	      o $password
		- The password.

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

RETURN VALUES

	Returns a positive MS SQL persistent link identifier on success, or FALSE on error.

EXAMPLES

       Example #1

	      mssql_pconnect(3) using the $new_link parameter

	      <?php
	      // Connect to MSSQL and select the database
	      $link1 = mssql_pconnect('MANGOSQLEXPRESS', 'sa', 'phpfi');
	      mssql_select_db('php', $link1);

	      // Create a new link
	      $link2 = mssql_pconnect('MANGOSQLEXPRESS', 'sa', 'phpfi', true);
	      mssql_select_db('random', $link2);
	      ?>

PHP Documentation Group 													 MSSQL_PCONNECT(3)

MSSQL_CONNECT(3)														  MSSQL_CONNECT(3)

mssql_connect - Open MS SQL server connection

SYNOPSIS

       resource mssql_connect ([string	$servername], [string  $username], [string  $password], [bool  $new_link = false])

DESCRIPTION

       mssql_connect(3) establishes a connection to a MS SQL server.

	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
       mssql_close(3).

PARAMETERS

	      o $servername
		- The MS SQL server. It can also include a port number, e.g.  hostname:port (Linux), or hostname,port (Windows).

	      o $username
		- The username.

	      o $password
		- The password.

	      o $new_link
		- If a second call is made to mssql_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. This parameter modifies this behavior and makes mssql_connect(3) always
		open a new link, even if mssql_connect(3) was called before with the same parameters.

RETURN VALUES

	Returns a MS SQL link identifier on success, or FALSE on error.

CHANGELOG

       +--------+------------------------------------+
       |Version |				     |
       |	|				     |
       |	|	     Description	     |
       |	|				     |
       +--------+------------------------------------+
       | 5.1.0	|				     |
       |	|				     |
       |	|  The $new_link parameter was added |
       |	|				     |
       +--------+------------------------------------+
EXAMPLES

       Example #1

	      mssql_connect(3) example

	      <?php
	      // Server in the this format: <computer><instance name> or
	      // <server>,<port> when using a non default port number
	      $server = 'KALLESPCSQLEXPRESS';

	      // Connect to MSSQL
	      $link = mssql_connect($server, 'sa', 'phpfi');

	      if (!$link) {
		  die('Something went wrong while connecting to MSSQL');
	      }
	      ?>

SEE ALSO

       mssql_close(3), mssql_pconnect(3).

PHP Documentation Group 													  MSSQL_CONNECT(3)