©
本文档使用 PHP中文网手册 发布
(No version information available, might only be in Git)
sqlsrv_send_stream_data — Sends data from parameter streams to the server
$stmt
)Send data from parameter streams to the server. Up to 8 KB of data is sent with each call.
stmt
A statement resource returned by sqlsrv_query() or sqlsrv_execute() .
Returns TRUE
if there is more data to send and FALSE
if there is not.
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_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." ;
?>