©
This document uses PHP Chinese website manual Release
(PECL maxdb >= 1.0)
maxdb_stmt_store_result -- maxdb_stmt::store_result — Transfers a result set from a prepared statement
过程化风格
$stmt
)面向对象风格
maxdb_stmt_store_result() has no functionally effect and should not be used for retrieving data from MaxDB server.
成功时返回 TRUE
, 或者在失败时返回 FALSE
。
Example #1 面向对象风格
<?php
$maxdb = new maxdb ( "localhost" , "MONA" , "RED" , "DEMODB" );
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 )) {
$stmt -> execute ();
$stmt -> store_result ();
printf ( "Number of rows: %d.\n" , $stmt -> num_rows );
$stmt -> free_result ();
$stmt -> close ();
}
$maxdb -> close ();
?>
Example #2 过程化风格
<?php
$link = maxdb_connect ( "localhost" , "MONA" , "RED" , "DEMODB" );
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 )) {
maxdb_stmt_execute ( $stmt );
maxdb_stmt_store_result ( $stmt );
printf ( "Number of rows: %d.\n" , maxdb_stmt_num_rows ( $stmt ));
maxdb_stmt_free_result ( $stmt );
maxdb_stmt_close ( $stmt );
}
maxdb_close ( $link );
?>
以上例程的输出类似于:
Number of rows: 25.