SQLSRV_SEND_STREAM_DATA(3)												SQLSRV_SEND_STREAM_DATA(3)

sqlsrv_send_stream_data - Sends data from parameter streams to the server

SYNOPSIS

       bool sqlsrv_send_stream_data (resource  $stmt)

DESCRIPTION

	Send data from parameter streams to the server. Up to 8 KB of data is sent with each call.

PARAMETERS

	      o $stmt
		- A statement resource returned by sqlsrv_query(3) or sqlsrv_execute(3).

RETURN VALUES

	Returns TRUE if there is more data to send and FALSE if there is not.

EXAMPLES

       Example #1

	      sqlsrv_send_stream_data(3) example

	      <?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));
	      }

	      $sql = "UPDATE Table_1 SET data = ( ?) WHERE id = 100";

	      // Open parameter data as a stream and put it in the $params array.
	      $data = fopen( "data://text/plain,[ Lengthy content here. ]", "r");
	      $params = array( &$data);

	      // Prepare the statement. Use the $options array to turn off the
	      // default behavior, which is to send all stream data at the time of query
	      // execution.
	      $options = array("SendStreamParamsAtExec"=>0);
	      $stmt = sqlsrv_prepare( $conn, $sql, $params, $options);

	      sqlsrv_execute( $stmt);

	      // Send up to 8K of parameter data to the server
	      // with each call to sqlsrv_send_stream_data.
	      $i = 1;
	      while( sqlsrv_send_stream_data( $stmt)) {
		    $i++;
	      }
	      echo "$i calls were made.";
	      ?>

SEE ALSO

       sqlsrv_prepare(3), sqlsrv_query(3).

PHP Documentation Group 												SQLSRV_SEND_STREAM_DATA(3)