mysqli_stmt::send_long_data

mysqli_stmt_send_long_data

(PHP 5, PHP 7)

mysqli_stmt::send_long_data -- mysqli_stmt_send_long_data — Send data in blocks

说明

面向对象风格

mysqli_stmt::send_long_data ( int $param_nr , string $data ) : bool

过程化风格

mysqli_stmt_send_long_data ( mysqli_stmt $stmt , int $param_nr , string $data ) : bool

Allows to send parameter data to the server in pieces (or chunks), e.g. if the size of a blob exceeds the size of max_allowed_packet. This function can be called multiple times to send the parts of a character or binary data value for a column, which must be one of the TEXT or BLOB datatypes.

参数

stmt: 仅以过程化样式：由 mysqli_stmt_init() 返回的 statement 标识。
param_nr: Indicates which parameter to associate the data with. Parameters are numbered beginning with 0.
data: A string containing data to be sent.

返回值

成功时返回 TRUE，或者在失败时返回 FALSE。

范例

Example #1 面向对象风格

 <?php
$stmt = $mysqli->prepare("INSERT INTO messages (message) VALUES (?)");
$null = NULL;
$stmt->bind_param("b", $null);
$fp = fopen("messages.txt", "r");
while (!feof($fp)) {
    $stmt->send_long_data(0, fread($fp, 8192));
}
fclose($fp);
$stmt->execute();
?>

参见

mysqli_prepare() - 准备执行一个 SQL 语句
mysqli_stmt_bind_param() - Binds variables to a prepared statement as parameters

php eventbufferevent create a new ssl buffer event to send its data over another buffer event php eventhttprequest send another data chunk as part of an ongoing chunked reply php maxdb 函数别名 maxdb stmt send long data php maxdb 函数 ends a sequence of maxdb stmt send long data php maxdb 函数 send data in blocks php 别名和过时的 mysqli 函数 mysqli stmt send long data 的别名 php gearmanjob send data for a running job deprecated php gearmantask send data for a task deprecated php gearmantask send data for a task php mysqli stmt returns a list of errors from the last statement executed php mysqli stmt returns a string description for last statement error php mysqli stmt executes a prepared query php mysqli stmt fetch results from a prepared statement into the bound variables php mysqli stmt send data in blocks php mysqli stmt returns sqlstate error from previous statement operation php mysqli stmt transfers a result set from a prepared statement php swoole http response send data for the http request and finish the response.php swoole server send data to the remote udp address.php swoole server send data to the remote socket in the blocking way.php swoole websocket server get a pack of binary data to send in a single frame.