maxdb_stmt_data_seek

maxdb_stmt::data_seek

(PECL maxdb >= 1.0)

maxdb_stmt_data_seek -- maxdb_stmt::data_seek — Seeks to an arbitray row in statement result set

说明

过程化风格

bool maxdb_stmt_data_seek ( resource $statement , int $offset )

面向对象风格

bool maxdb_stmt::data_seek ( int $offset )

The maxdb_stmt_data_seek() function seeks to an arbitrary result pointer specified by the offset in the statement result set represented by statement. The offset parameter must be between zero and the total number of rows minus one (0.. maxdb_stmt_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, zip FROM hotel.city ORDER BY name" ;
if ( $stmt  =  $maxdb -> prepare ( $query )) {

    
    $stmt -> execute ();

    
    $stmt -> bind_result ( $name ,  $code );

    
    $stmt -> store_result ();

    
    $stmt -> data_seek ( 5 );

    
    $stmt -> fetch ();

    printf  ( "City: %s  Zip: %s\n" ,  $name ,  $code );

    
    $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 name, zip FROM hotel.city ORDER BY name" ;
if ( $stmt  =  maxdb_prepare ( $link ,  $query )) {

    
    maxdb_stmt_execute ( $stmt );

    
    maxdb_stmt_bind_result ( $stmt ,  $name ,  $code );

    
    maxdb_stmt_store_result ( $stmt );

    
    maxdb_stmt_data_seek ( $stmt ,  5 );

    
    maxdb_stmt_fetch ( $stmt );

    printf  ( "City: %s  Zip: %s\n" ,  $name ,  $code );

    
    maxdb_stmt_close ( $stmt );
}

 
 maxdb_close ( $link );
 ?>

以上例程的输出类似于：

City: Dallas  Zip: 75243

参见

maxdb_prepare() - Prepare an SQL statement for execution