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 cubrid 函数 read blob/clob data and send straight to browser php cubrid 过时的别名和函数 read data from glo and send it to std output php mcve 函数 perform communication with mcve send/receive data non blocking 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 execute 的别名 php 别名和过时的 mysqli 函数 mysqli stmt fetch 的别名。php 别名和过时的 mysqli 函数 mysqli stmt send long data 的别名 php mysqli stmt returns the total number of rows changed deleted or inserted by the last executed statement php mysqli stmt used to get the current value of a statement attribute php mysqli stmt returns the number of field in the given statement php mysqli stmt frees stored result memory for the given statement handle php mysqli stmt gets a result set from a prepared statement php mysqli stmt get result of show warnings php mysqli stmt get the id generated from the previous insert operation php mysqli stmt send data in blocks php mysqli 设置 load data local infile 命令的回调函数 php swoole server send data to the task worker processes.php swoole server send data to the task worker processes in blocking way.