maxdb_num_rows

maxdb::num_rows

(PECL maxdb >= 1.0)

maxdb_num_rows -- maxdb::num_rows — Gets the number of rows in a result

说明

过程化风格

int maxdb_num_rows ( resource $result )

面向对象风格

int $maxdb->num_rows;

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.

参见

maxdb_affected_rows() - Gets the number of affected rows in a previous MaxDB operation
maxdb_store_result() - Transfers a result set from the last query
maxdb_use_result() - Initiate a result set retrieval
maxdb_query() - Performs a query on the database