mssql_select_db(3) [php man page]

MSSQL_SELECT_DB(3)														MSSQL_SELECT_DB(3)

mssql_select_db - Select MS SQL database

SYNOPSIS

       bool mssql_select_db (string  $database_name, [resource	$link_identifier])

DESCRIPTION

       mssql_select_db(3) sets the current active database on the server that's associated with the specified link identifier.

	Every subsequent call to mssql_query(3) will be made on the active database.

PARAMETERS

	      o $database_name
		-  The	database name.	To escape the name of a database that contains spaces, hyphens ("-"), or any other exceptional characters,
		the database name must be enclosed in brackets, as is shown in the example, below.  This  technique  must  also  be  applied  when
		selecting a database name that is also a reserved word (such as primary).

	      o $link_identifier
		-  A  MS  SQL  link  identifier,  returned by mssql_connect(3) or mssql_pconnect(3).  If no link identifier is specified, the last
		opened link is assumed. If no link is open, the function will try to establish a link as if mssql_connect(3) was called,  and  use
		it.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      mssql_select_db(3) example

	      <?php
	      // Create a link to MSSQL
	      $link = mssql_connect('KALLESPCSQLEXPRESS', 'sa', 'phpfi');

	      // Select the database 'php'
	      mssql_select_db('php', $link);
	      ?>

       Example #2

	      Escaping the database name with square brackets

	      <?php
	      // Create a link to MSSQL
	      $link = mssql_connect('KALLESPCSQLEXPRESS', 'sa', 'phpfi');

	      // Select the database 'my.database-name'
	      mssql_select_db('[my.database-name]', $link);
	      ?>

SEE ALSO

       mssql_connect(3), mssql_pconnect(3), mssql_query(3).

PHP Documentation Group 													MSSQL_SELECT_DB(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)