©
This document uses PHP Chinese website manual Release
(PECL maxdb >= 1.0)
maxdb_stmt_num_rows -- maxdb_stmt::num_rows — Return the number of rows in statements result set
过程化风格
$stmt
)面向对象风格
Returns the number of rows in the result set.
An integer representing the number of rows in result set.
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 zip, name 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 -> 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 zip, name 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_close ( $stmt );
}
maxdb_close ( $link );
?>
以上例程的输出类似于:
Number of rows: 25.