sqlsrv_client_info(3) [php man page]

SQLSRV_CLIENT_INFO(3)													     SQLSRV_CLIENT_INFO(3)

sqlsrv_client_info - Returns information about the client and specified connection

SYNOPSIS

       array sqlsrv_client_info (resource  $conn)

DESCRIPTION

	Returns information about the client and specified connection

PARAMETERS

	      o $conn
		- The connection about which information is returned.

RETURN VALUES

	Returns an associative array with keys described in the table below. Returns FALSE otherwise.

       Array returned by sqlsrv_client_info

       +--------------+-------------------------------------------------+
       |     Key      | 						|
       |	      | 						|
       |	      | 		  Description			|
       |	      | 						|
       +--------------+-------------------------------------------------+
       |DriverDllName | 						|
       |	      | 						|
       |	      | 		 SQLNCLI10.DLL			|
       |	      | 						|
       |DriverODBCVer | 						|
       |	      | 						|
       |	      | 	     ODBC version (xx.yy)		|
       |	      | 						|
       |  DriverVer   | 						|
       |	      | 						|
       |	      | SQL Server Native Client DLL version (10.5.xxx) |
       |	      | 						|
       |ExtensionVer  | 						|
       |	      | 						|
       |	      |       php_sqlsrv.dll version (2.0.xxx.x)	|
       |	      | 						|
       +--------------+-------------------------------------------------+
EXAMPLES

       Example #1

	      sqlsrv_client_info(3) example

	      <?php
	      $serverName = "serverNamesqlexpress";
	      $connOptions = array("UID"=>"username", "PWD"=>"password");
	      $conn = sqlsrv_connect( $serverName, $connOptions );

	      if( $conn === false ) {
		  die( print_r( sqlsrv_errors(), true));
	      }

	      if( $client_info = sqlsrv_client_info( $conn)) {
		  foreach( $client_info as $key => $value) {
		      echo $key.": ".$value."<br />";
		  }
	      } else {
		  echo "Error in retrieving client info.<br />";
	      }
	      ?>

SEE ALSO

       sqlsrv_server_info(3).

PHP Documentation Group 												     SQLSRV_CLIENT_INFO(3)

SQLSRV_BEGIN_TRANSACTION(3)											       SQLSRV_BEGIN_TRANSACTION(3)

sqlsrv_begin_transaction - Begins a database transaction

SYNOPSIS

       bool sqlsrv_begin_transaction (resource	$conn)

DESCRIPTION

	The  transaction  begun  by sqlsrv_begin_transaction(3) includes all statements that were executed after the call to sqlsrv_begin_transac-
       tion(3) and before calls to sqlsrv_rollback(3) or sqlsrv_commit(3). Explicit transactions should be started and committed  or  rolled  back
       using  these  functions instead of executing SQL statements that begin and committ/roll back transactions. For more information, see SQLSRV
       Transactions.

PARAMETERS

	      o $conn
		- The connection resource returned by a call to sqlsrv_connect(3).

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      sqlsrv_begin_transaction(3) example

	       The following example demonstrates how to use sqlsrv_begin_transaction(3) together with sqlsrv_commit(3) and sqlsrv_rollback(3).

	      <?php
	      $serverName = "serverNamesqlexpress";
	      $connectionInfo = array( "Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
	      $conn = sqlsrv_connect( $serverName, $connectionInfo);
	      if( $conn === false ) {
		  die( print_r( sqlsrv_errors(), true ));
	      }

	      /* Begin the transaction. */
	      if ( sqlsrv_begin_transaction( $conn ) === false ) {
		   die( print_r( sqlsrv_errors(), true ));
	      }

	      /* Initialize parameter values. */
	      $orderId = 1; $qty = 10; $productId = 100;

	      /* Set up and execute the first query. */
	      $sql1 = "INSERT INTO OrdersTable (ID, Quantity, ProductID)
			VALUES (?, ?, ?)";
	      $params1 = array( $orderId, $qty, $productId );
	      $stmt1 = sqlsrv_query( $conn, $sql1, $params1 );

	      /* Set up and execute the second query. */
	      $sql2 = "UPDATE InventoryTable
			SET Quantity = (Quantity - ?)
			WHERE ProductID = ?";
	      $params2 = array($qty, $productId);
	      $stmt2 = sqlsrv_query( $conn, $sql2, $params2 );

	      /* If both queries were successful, commit the transaction. */
	      /* Otherwise, rollback the transaction. */
	      if( $stmt1 && $stmt2 ) {
		   sqlsrv_commit( $conn );
		   echo "Transaction committed.<br />";
	      } else {
		   sqlsrv_rollback( $conn );
		   echo "Transaction rolled back.<br />";
	      }
	      ?>

	      The above example will output something similar to:

SEE ALSO

       sqlsrv_commit(3), sqlsrv_rollback(3).

PHP Documentation Group 											       SQLSRV_BEGIN_TRANSACTION(3)