stream_context_set_params(3) [php man page]

STREAM_CONTEXT_SET_PARAMS(3)						 1					      STREAM_CONTEXT_SET_PARAMS(3)

stream_context_set_params - Set parameters for a stream/wrapper/context

SYNOPSIS

       bool stream_context_set_params (resource  $stream_or_context, array  $params)

DESCRIPTION

	Sets parameters on the specified context.

PARAMETERS

	      o $stream_or_context
		- The stream or context to apply the parameters too.

	      o $params
		- An array of parameters to set.

	      Note

		     $params should be an associative array of the structure: $params['paramname'] = "paramvalue";.

SUPPORTED PARAMETERS

       +-------------+---------------------------------------------------+
       | Parameters  |							 |
       |	     |							 |
       |	     |			    Purpose			 |
       |	     |							 |
       +-------------+---------------------------------------------------+
       |	     |							 |
       |notification |							 |
       |	     |							 |
       |	     |	Name  of  user-defined	callback  function to be |
       |	     | called whenever a stream triggers a notification. |
       |	     |							 |
       |	     |							 |
       |  options    |							 |
       |	     |							 |
       |	     |	Array of  options  as  in  context  options  and |
       |	     | parameters.					 |
       |	     |							 |
       +-------------+---------------------------------------------------+
RETURN VALUES

	Returns TRUE on success or FALSE on failure.

SEE ALSO 
stream_notification_callback(3).
PHP Documentation Group 											      STREAM_CONTEXT_SET_PARAMS(3)

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)