ingres_result_seek

(PECL ingres >= 2.1.0)

ingres_result_seek — Set the row position before fetching data

説明

boolean ingres_result_seek ( resource $result , integer $position )

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().

注意: 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 を返します。

例

例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);

?>

参考

ingres_query() - Ingres に SQL クエリを送信する
ingres_fetch_array() - 1 行分の結果を配列に取得する
ingres_fetch_assoc() - Fetch a row of result into an associative array
ingres_fetch_object() - 1 行分の結果をオブジェクトとして取得する
ingres_fetch_row() - 1 行分の結果を数値添字配列として取得する

add a note User Contributed Notes
ingres_result_seek

There are no user contributed notes for this page.

ingres_rollback

ingres_query

Last updated: Fri, 13 Nov 2009