PHP: Hypertext Preprocessor (original) (raw)

mysqli_stmt::send_long_data

mysqli_stmt_send_long_data

(PHP 5, PHP 7, PHP 8)

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

Description

Object-oriented style

public mysqli_stmt::send_long_data(int $param_num, string $data): bool

Parameters

statement

Procedural style only: A mysqli_stmt object returned by mysqli_stmt_init().

param_num

Indicates which parameter to associate the data with. Parameters are numbered beginning with 0.

data

A string containing data to be sent.

Return Values

Returns [true](reserved.constants.php#constant.true) on success or [false](reserved.constants.php#constant.false) on failure.

Examples

Example #1 Object-oriented style

<?php <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>s</mi><mi>t</mi><mi>m</mi><mi>t</mi><mo>=</mo></mrow><annotation encoding="application/x-tex">stmt = </annotation></semantics></math>stmt=mysqli->prepare("INSERT INTO messages (message) VALUES (?)"); $null = NULL; <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>s</mi><mi>t</mi><mi>m</mi><mi>t</mi><mo>−</mo><mo>></mo><mi>b</mi><mi>i</mi><mi>n</mi><msub><mi>d</mi><mi>p</mi></msub><mi>a</mi><mi>r</mi><mi>a</mi><mi>m</mi><mo stretchy="false">(</mo><mi mathvariant="normal">"</mi><mi>b</mi><mi mathvariant="normal">"</mi><mo separator="true">,</mo></mrow><annotation encoding="application/x-tex">stmt->bind_param("b", </annotation></semantics></math>stmt−>bindparam("b",null); $fp = fopen("messages.txt", "r"); while (!feof($fp)) { <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>s</mi><mi>t</mi><mi>m</mi><mi>t</mi><mo>−</mo><mo>></mo><mi>s</mi><mi>e</mi><mi>n</mi><msub><mi>d</mi><mi>l</mi></msub><mi>o</mi><mi>n</mi><msub><mi>g</mi><mi>d</mi></msub><mi>a</mi><mi>t</mi><mi>a</mi><mo stretchy="false">(</mo><mn>0</mn><mo separator="true">,</mo><mi>f</mi><mi>r</mi><mi>e</mi><mi>a</mi><mi>d</mi><mo stretchy="false">(</mo></mrow><annotation encoding="application/x-tex">stmt->send_long_data(0, fread(</annotation></semantics></math>stmt−>sendlongdata(0,fread(fp, 8192)); } fclose($fp); $stmt->execute(); ?>

Found A Problem?

ChrisH ¶

5 years ago

`If you are trying to write a single field which is above max_allowed_packet then this function will not help you (contrary to what the documentation example seems to show above).

Parameters in MySQL are still restricted by max_allowed_packet on a per-field basis so you will get an error like:

“mysqli_sql_exception: Parameter of prepared statement which is set through mysql_send_long_data() is longer than 'max_long_data_size' bytes”

The only real use case for this function seems to be if you are writing multiple long fields which when combined would go over max_allowed_packet.

Gustavo Narea ¶

18 years ago

DimeCadmium ¶

4 years ago

To ChrisH's note, you must call this function multiple times with the same $param_nr, to send the first max_allowed_packet bytes, then the next, and so on. So you might need to do a for loop over changing substr() indexes, or etc.