maxdb_stmt_num_rows

maxdb_stmt::num_rows

(PECL maxdb >= 1.0)

maxdb_stmt_num_rows -- maxdb_stmt::num_rows — Return the number of rows in statements result set

说明

过程化风格

int maxdb_stmt_num_rows ( resource $stmt )

面向对象风格

int $maxdb_stmt->num_rows;

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.

参见

maxdb_stmt_affected_rows() - Returns the total number of rows changed, deleted, or inserted by the last executed statement
maxdb_prepare() - Prepare an SQL statement for execution
maxdb_stmt_store_result() - Transfers a result set from a prepared statement