pg_result_seek

(PHP 4 >= 4.3.0, PHP 5)

pg_result_seek — Set internal row offset in result resource

Descrierea

bool pg_result_seek ( resource $result , int $offset )

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

Parametri

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.

Valorile întoarse

Întoarce valoarea TRUE în cazul succesului sau FALSE în cazul eșecului.

Exemple

Example #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($result, 2);

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

Vedeți de asemenea

pg_fetch_row() - Get a row as an enumerated array
pg_fetch_assoc() - Fetch a row as an associative array
pg_fetch_array() - Fetch a row as an array
pg_fetch_object() - Fetch a row as an object
pg_fetch_result() - Returns values from a result resource

add a note User Contributed Notes pg_result_seek - [1 notes]

down

andrew-php dot net at andrew dot net dot au ¶

8 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...

add a note