(PHP 5)
mysqli_stmt::send_long_data -- mysqli_stmt_send_long_data — Send data in blocks
Stile orientato agli oggetti
$param_nr
, string $data
)Stile procedurale
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.
stmtSolo nello stile procedurale: un identificatore di statement restituito da 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.
Restituisce TRUE in caso di successo, FALSE in caso di fallimento.
Example #1 Stile orientato agli oggetti
<?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();
?>