pg_result

说明

array pg_result_seek ( resource result, int offset )

pg_result_seek() 在结果资源中设定内部行偏移量。如果出错则返回 FALSE。

参见 pg_fetch_row()，pg_fetch_assoc()，pg_fetch_array()，pg_fetch_object() 和 pg_fetch_result()。

add a note User Contributed Notes

duke at spacebox dot net
09-Dec-2005 06:20


Unfortunately you're limited to a loop with a counter - all the pg_fetch functions increment the row counter *before* fetching a row, so something like



while ($row = pg_fetch_assoc($result)) {...}



is no longer possible after seeking or after fetching one or more results.  IMHO, the while loop is much better to look at than a for loop.



It'd be nice if there were a function to reset the current row to -1.  Perhaps the offset argument to the seek function could be optional; if left out the offset is set to -1.



bool pg_result_seek ( resource result[, int offset] )

andrew-php dot net at andrew dot net dot au
18-Sep-2004 11:01


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