©
                    本文档使用
                    php中文网手册 发布
                
(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.