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...
pg_result_seek
(PHP 4 >= 4.3.0, PHP 5, PHP 7)
pg_result_seek — Set internal row offset in result resource
Descrierea
pg_result_seek
( resource
$result
, int $offset
) : boolpg_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
resultresource. 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);
?>
A se vedea și
- 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 1 note
andrew-php dot net at andrew dot net dot au ¶
20 years ago
