fbsql_data_seek

(PHP 4 >= 4.0.6, PHP 5, PHP 7)

fbsql_data_seek — Move internal result pointer

说明

bool fbsql_data_seek ( resource $result , int $row_number )

Moves the internal row pointer of the FrontBase result associated with the specified result identifier to point to the specified row number.

The next call to fbsql_fetch_row() would return that row.

参数

result: 由 fbsql_query() 或 fbsql_db_query() 返回的结果标识符。
row_number: The row number. Starts at 0.

返回值

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

范例

Example #1 fbsql_data_seek() example

  <?php
$link  =  fbsql_pconnect ( "localhost" ,  "_SYSTEM" ,  "secret" )
    or die( "Could not connect" );

 fbsql_select_db ( "samp_db" )
    or die( "Could not select database" );

 $query  =  "SELECT last_name, first_name FROM friends;" ;
 $result  =  fbsql_query ( $query )
    or die( "Query failed" );

 // fetch rows in reverse order

 for ( $i  =  fbsql_num_rows ( $result ) -  1 ;  $i  >= 0 ;  $i --) {
    if (! fbsql_data_seek ( $result ,  $i )) {
         printf ( "Cannot seek to row %d\n" ,  $i );
        continue;
    }

    if (!( $row  =  fbsql_fetch_object ( $result )))
        continue;

    echo  $row -> last_name  .  $row -> first_name  .  "<br />\n" ;
}

 fbsql_free_result ( $result );
 ?>