PHP manuál : function.maxdb-stmt-store-result.html
maxdb_stmt_store_result 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:
Webmail
Zaujímavé linky
inzerat.sk - bezplatna inzercia, inzeraty, autobazar, reality
Slovak companies and manufacturers directory Katalog slovenskych firiem a vyrobkov
Suppliers and products directory