mssql_close(3) [php man page]

MSSQL_CLOSE(3)															    MSSQL_CLOSE(3)

mssql_close - Close MS SQL Server connection

SYNOPSIS

       bool mssql_close ([resource  $link_identifier])

DESCRIPTION

	Closes	the link to a MS SQL Server database that's associated with the specified link identifier. If the link identifier isn't specified,
       the last opened link is assumed.

	Note that this isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution.

PARAMETERS

	      o $link_identifier
		- A MS SQL link identifier, returned by mssql_connect(3).  This function will not close persistent links generated by  mssql_pcon-
		nect(3).

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      mssql_close(3) example

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

	      // Do any related operations here

	      // Close the link to MSSQL
	      mssql_close($link);
	      ?>

SEE ALSO

       mssql_connect(3), mssql_pconnect(3).

PHP Documentation Group 													    MSSQL_CLOSE(3)

MSSQL_INIT(3)															     MSSQL_INIT(3)

mssql_init - Initializes a stored procedure or a remote stored procedure

SYNOPSIS

       resource mssql_init (string  $sp_name, [resource  $link_identifier])

DESCRIPTION

	Initializes a stored procedure or a remote stored procedure.

PARAMETERS

	      o $sp_name
		- Stored procedure name, like ownew.sp_name or otherdb.owner.sp_name.

	      o $link_identifier
		- A MS SQL link identifier, returned by mssql_connect(3).

RETURN VALUES

	Returns a resource identifier "statement", used in subsequent calls to mssql_bind(3) and mssql_execute(3), or FALSE on errors.

EXAMPLES

       Example #1

	      mssql_init(3) example

	      <?php
	      // Connect to MSSQL and select the database
	      $link = mssql_connect('KALLESPCSQLEXPRESS', 'sa', 'phpfi');
	      mssql_select_db('php', $link);

	      // Create a new statement
	      $stmt = mssql_init('StatementTest', $link);

	      // Bind values here

	      // Once values are binded we execute our statement
	      // using mssql_execute:
	      mssql_execute($stmt);

	      // And we can free it like so:
	      mssql_free_statement($stmt);
	      ?>

SEE ALSO

       mssql_bind(3), mssql_execute(3), mssql_free_statement(3).

PHP Documentation Group 													     MSSQL_INIT(3)