©
This document uses PHP Chinese website manual Release
(PECL maxdb >= 1.0)
maxdb_num_rows -- maxdb::num_rows — Gets the number of rows in a result
过程化风格
$result
)面向对象风格
Returns the number of rows in the result set.
The use of maxdb_num_rows() depends on whether you use buffered or unbuffered result sets. In case you use unbuffered resultsets maxdb_num_rows() will not correct the correct number of rows until all the rows in the result have been retrieved.
Returns number of rows in the result set.
Note:
If the number of rows is greater than maximal int value, the number will be returned as a string.
Example #1 面向对象风格
<?php
$maxdb = new maxdb ( "localhost" , "MONA" , "RED" , "DEMODB" );
if ( maxdb_connect_errno ()) {
printf ( "Connect failed: %s\n" , maxdb_connect_error ());
exit();
}
if ( $result = $maxdb -> query ( "SELECT cno, name FROM hotel.customer ORDER BY name" )) {
$row_cnt = $result -> num_rows ;
printf ( "Result set has %d rows.\n" , $row_cnt );
$result -> 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();
}
if ( $result = maxdb_query ( $link , "SELECT cno, name FROM hotel.customer ORDER BY name" )) {
$row_cnt = maxdb_num_rows ( $result );
printf ( "Result set has %d rows.\n" , $row_cnt );
maxdb_free_result ( $result );
}
maxdb_close ( $link );
?>
以上例程的输出类似于:
Result set has 15 rows.