ScotlandPHP

pg_result_seek

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

pg_result_seekSet internal row offset in result resource

Açıklama

bool pg_result_seek ( resource $result , int $offset )

pg_result_seek() sets the internal row offset in a result resource.

Değiştirgeler

result

PostgreSQL query result resource, returned by pg_query(), pg_query_params() or pg_execute() (among others).

offset

Row to move the internal offset to in the result resource. Rows are numbered starting from zero.

Dönen Değerler

Başarı durumunda TRUE, başarısızlık durumunda FALSE döner.

Örnekler

Örnek 1 pg_result_seek() example

<?php

// Connect to the database
$conn pg_pconnect("dbname=publisher");

// Execute a query
$result pg_query($conn"SELECT author, email FROM authors");

// Seek to the 3rd row (assuming there are 3 rows)
pg_result_seek($result2);

// Fetch the 3rd row
$row pg_fetch_row($result);
 
?>

Ayrıca Bakınız

add a note add a note

User Contributed Notes 1 note

up
3
andrew-php dot net at andrew dot net dot au
13 years ago
Ah, this is a handy feature for resetting the record index, for example, if you're used pg_fetch_{row,array,assoc} to iterate over the result set, and you want to do it again later on, without reexecuting your query. Something like:

<?php pg_result_seek($result, 0); ?>

will allow you to iterate over the result set all over again...
To Top