(PHP 5)
mysqli_stmt::send_long_data -- mysqli_stmt_send_long_data — Send data in blocks
Stil obiect-orientat
$param_nr
, string $data
)Stil 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.
stmtNumai stilul procedural: Un identificator al declarației întors de 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.
Întoarce valoarea TRUE în cazul
succesului sau FALSE în cazul eșecului.
Example #1 Stil obiect-orientat
<?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();
?>