maxdb_stmt_store_result
(PECL)
maxdb_stmt_store_result
(no version information, might be only in CVS)
maxdb->store_result -- Transfers a result set from a prepared statement
Description
Procedural style:
bool
maxdb_stmt_store_result ( resource stmt )
Object oriented style (method):
class
maxdb {
object
store_result ( void )
}
maxdb_stmt_store_result() 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.
Example
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\n", 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.\n", $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\n", 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.\n", 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 examples would produce the following output: