(PHP 5, PHP 7)
mysqli_stmt::send_long_data -- mysqli_stmt_send_long_data — Send data in blocks
Estilo orientado à objeto
$param_nr
, string $data
)Estilo procedural
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.
stmtSomente no estilo procedural: Um recurso statement retornado por mysqli_stmt_init().
param_nrIndicates which parameter to associate the data with. Parameters are numbered beginning with 0.
dataA string containing data to be sent.
Retorna TRUE em caso de sucesso ou FALSE em caso de falha.
Exemplo #1 Estilo orientado à objeto
<?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();
?>