sqlsrv_send_stream_data

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

sqlsrv_send_stream_data — Sends data from parameter streams to the server

说明

sqlsrv_send_stream_data ( resource $stmt ) : bool

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.";
?>

参见

相关文章
php apc 函数 retrieves cached information from apc s data storephp apcu 函数 retrieves cached information from apcu s data storephp cubrid 函数 import blob/clob data from a filephp cubrid 过时的别名和函数 read data from glo and send it to std outputphp filepro 函数 retrieves data from a filepro databasephp firebird/interbase 函数 get len bytes data from open blobphp mailparse 函数 streams data from source file pointer apply encoding and write to destfpphp mssql 函数 returns the last message from the serverphp postgresql 函数 looks up a current parameter setting of the serverphp sqlite 函数 encode binary data before returning it from an udfphp sqlsrv 函数 retrieves the next row of data in a result set as an objectphp sqlsrv 函数 gets field data from the currently selected rowphp sqlsrv 函数 sends data from parameter streams to the serverphp sqlsrv 函数 returns information about the serverphp stream 函数 receives data from a socket connected or notphp 杂项 函数 unpack data from binary stringphp sam 函数 disconnects from a messaging serverphp sdo 函数 get the changed data objects from a change summaryphp swoole server stop receiving data from the connection.php swoole server start receving data from the connection.
关注编程学问公众号