maxdb_data_seek

maxdb_result::data_seek

(PECL maxdb >= 1.0)

maxdb_data_seek -- maxdb_result::data_seek — Adjusts the result pointer to an arbitary row in the result

说明

过程化风格

bool maxdb_data_seek ( resource $result , int $offset )

面向对象风格

bool maxdb_result::data_seek ( int $offset )

The maxdb_data_seek() function seeks to an arbitrary result pointer specified by the offset in the result set represented by result. The offset parameter must be between zero and the total number of rows minus one (0.. maxdb_num_rows() - 1).

返回值

成功时返回 TRUE ，或者在失败时返回 FALSE 。

范例

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 name, state FROM hotel.city ORDER BY name" ;
if ( $result  =  $maxdb -> query (  $query )) {

    
    $result -> data_seek ( 10 );

    
    $row  =  $result -> fetch_row ();

    printf  ( "City: %s  State: %s\n" ,  $row [ 0 ],  $row [ 1 ]);

    
    $result -> close ();
}

 
 $maxdb -> close ();
 ?>

Example #2 过程化风格

  <?php
$link  =  maxdb_connect ( "localhost" ,  "MONA" ,  "RED" ,  "DEMODB" );

 
 if (! $link ) {
    printf ( "Connect failed: %s\n" ,  maxdb_connect_error ());
   exit();
}

 $query  =  "SELECT name, state FROM hotel.city ORDER BY name" ;

if ( $result  =  maxdb_query ( $link ,  $query )) {

    
    maxdb_data_seek ( $result ,  10 );

    
    $row  =  maxdb_fetch_row ( $result );

    printf  ( "City: %s  State: %s\n" ,  $row [ 0 ],  $row [ 1 ]);

    
    maxdb_free_result ( $result );
}

 
 maxdb_close ( $link );
 ?>

以上例程的输出类似于：

City: Irvine  State: CA

参见

maxdb_store_result() - Transfers a result set from the last query
maxdb_fetch_row() - Get a result row as an enumerated array
maxdb_num_rows() - Gets the number of rows in a result