IT. Expert System.

PHP

Sends data from parameter streams to the server


sqlsrv_send_stream_data

(No version information available, might only be in Git)

sqlsrv_send_stream_dataSends data from parameter streams to the server

Description

bool sqlsrv_send_stream_data ( resource $stmt )

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

Parameters

stmt

A statement resource returned by sqlsrv_query() or sqlsrv_execute().

Return Values

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

Examples

Example #1 sqlsrv_send_stream_data() example

<?php
$serverName 
"serverName\sqlexpress";
$connectionInfo = array( "Database"=>"dbName""UID"=>"username""PWD"=>"password" );
$conn sqlsrv_connect$serverName$connectionInfo);
if( 
$conn === false ) {
     die( 
print_rsqlsrv_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



Content

Android Reference

Java basics

Java Enterprise Edition (EE)

Java Standard Edition (SE)

SQL

HTML

PHP

CSS

Java Script

MYSQL

JQUERY

VBS

REGEX

C

C++

C#

Design patterns

RFC (standard status)

RFC (proposed standard status)

RFC (draft standard status)

RFC (informational status)

RFC (experimental status)

RFC (best current practice status)

RFC (historic status)

RFC (unknown status)

IT dictionary

License.
All information of this service is derived from the free sources and is provided solely in the form of quotations. This service provides information and interfaces solely for the familiarization (not ownership) and under the "as is" condition.
Copyright 2016 © ELTASK.COM. All rights reserved.
Site is optimized for mobile devices.
Downloads: 1852 / 248362468. Delta: 0.00624 с