ingres_result_seek

(PECL ingres >= 2.1.0)

ingres_result_seek — Set the row position before fetching data

说明

ingres_result_seek ( resource $result , int $position ) : bool

This function is used to position the cursor associated with the result resource before issuing a fetch. If ingres.array_index_start is set to 0 then the first row is 0 else it is 1. ingres_result_seek() can be used only with queries that make use of scrollable cursors. It cannot be used with ingres_unbuffered_query().

Note: Related Configurations

See also the ingres.scrollable and ingres.array_index_start directives in Runtime Configuration.

参数

result

The result identifier for a query

position

The row to position the cursor on. If ingres.array_index_start is set to 0, then the first row is 0, else it is 1

返回值

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

范例

Example #1 Position the cursor on the 3rd row

<?php

$result=ingres_query($link, "select * from airport where ap_ccode = 'ES' order by ap_place asc");

/* goto row 3 */
if (!ingres_result_seek($result, 3))
{
    echo ingres_errno() . " - " . ingres_error . "\n";
    die("i died");
}
else
{
    $airport = ingres_fetch_object ($result);
    {
        echo $airport->ap_iatacode . " - " .  $airport->ap_name . "\n";
    }
}

ingres_commit($link);

?>

参见

相关文章
php ibm db2 函数 returns an array indexed by column position representing a row in a result setphp ibm db2 函数 returns an array indexed by both column name and position representing a row in a result setphp ibm db2 函数 returns a result set listing the unique row identifier columns for a tablephp ingres 函数 fetch a row of result into an arrayphp ingres 函数 fetch a row of result into an associative arrayphp ingres 函数 fetch a row of result into an objectphp ingres 函数 fetch a row of result into an enumerated arrayphp ingres 函数 set the row position before fetching dataphp ingres 函数 set environment features controlling output optionsphp maxdb 函数 returns the lengths of the columns of the current row in the result setphp maxdb 函数 returns the current row of a result set as an objectphp maxdb 函数 seeks to an arbitray row in statement result setphp semaphore 函数 set information in the message queue data structurephp ncurses 函数 set new position and draw a horizontal line using an attributed character and max. n characters longphp ncurses 函数 set new position and draw a vertical line using an attributed character and max. n characters longphp pdf 函数 set text positionphp sqlite 函数 fetches the next row from a result set as an arrayphp sqlite 函数 fetches the next row from a result set as an objectphp sqlite 函数 seek to the previous row number of a result setphp sqlsrv 函数 retrieves the next row of data in a result set as an object
关注编程学问公众号