MAXDB_STMT_SEND_LONG_DATA(3) 1 MAXDB_STMT_SEND_LONG_DATA(3)maxdb_stmt_send_long_data - Send data in blocks
Procedural style
SYNOPSIS
bool maxdb_stmt_send_long_data (resource $stmt, int $param_nr, string $data)
DESCRIPTION
Object oriented style
bool maxdb_stmt::stmt_send_long_data (int $param_nr, string $data)
Allows to send parameter data to the server in pieces (or chunks). This function can be called multiple times to send the parts of a char-
acter or binary data value for a column, which must be one of the TEXT or BLOB datatypes.
$param_nr indicates which parameter to associate the data with. Parameters are numbered beginning with 0. $data is a string containing data
to be sent.
Note
For efficiency reasons, this function should be used after calling maxdb_execute(3). In this case, the data is not stored on the
client side. The end of the sequence must end with a call to maxdb_stmt_close_long_data(3).
RETURN VALUES
Returns TRUE on success or FALSE on failure.
SEE ALSO maxdb_prepare(3), maxdb_stmt_bind_param(3).
PHP Documentation Group MAXDB_STMT_SEND_LONG_DATA(3)
Check Out this Related Man Page
MAXDB_STMT_STORE_RESULT(3) 1 MAXDB_STMT_STORE_RESULT(3)maxdb_stmt_store_result - Transfers a result set from a prepared statement
Procedural style
SYNOPSIS
bool maxdb_stmt_store_result (resource $stmt)
DESCRIPTION
Object oriented style
object maxdb_stmt::store_result (void )
maxdb_stmt_store_result(3) has no functionally effect and should not be used for retrieving data from MaxDB server.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Object oriented style
<?php
/* Open a connection */
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
$query = "SELECT name, zip FROM hotel.city ORDER BY name";
if ($stmt = $maxdb->prepare($query)) {
/* execute query */
$stmt->execute();
/* store result */
$stmt->store_result();
printf("Number of rows: %d.
", $stmt->num_rows);
/* free result */
$stmt->free_result();
/* close statement */
$stmt->close();
}
/* close connection */
$maxdb->close();
?>
Example #2
Procedural style
<?php
/* Open a connection */
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
$query = "SELECT name, zip FROM hotel.city ORDER BY name";
if ($stmt = maxdb_prepare($link, $query)) {
/* execute query */
maxdb_stmt_execute($stmt);
/* store result */
maxdb_stmt_store_result($stmt);
printf("Number of rows: %d.
", maxdb_stmt_num_rows($stmt));
/* free result */
maxdb_stmt_free_result($stmt);
/* close statement */
maxdb_stmt_close($stmt);
}
/* close connection */
maxdb_close($link);
?>
The above example will output something similar to:
Number of rows: 25.
SEE ALSO maxdb_prepare(3), maxdb_stmt_result_metadata(3), maxdb_fetch(3).
PHP Documentation Group MAXDB_STMT_STORE_RESULT(3)