Data pagination with "saved" search

Question

I'm creating a page that's a search result...

When you're viewing one of the results, at the bottom of the page, I need to insert "Next result" and "Previous result" links, like a pagination... But from [I think] a saved search, right?

How you people would do this?

Obs.: I'll use CakePHP (PHP) and MySQL

--

Update: The problem is not how to paginate the search results like "20 results per page"... I need to jump from one record to another, sequentally in the same search result.

Let's say that I found the records 3, 5, 8 and 9 with my search... Then I click to view the #5 record and I can click on the "next result" link to jump to #8 record.

--

Possible solution #1

Create a array with the results IDs like:

$results = array(3, 5, 8, 9);

And store this array in the session or cookies with a token (SHA1, MD5 or UUID) and pass this token as GET param in the URL.

Answer 1

I dunno about cake, but all you have to do - is use GET method for the search form and preserve query string values in the URL.

In plain PHP I'd use http_build_query() function, say,

if (isset($_GET['page'])) unset($_GET['page']);
$qs=http_build_query_string($_GET);
$url="?$qs&page=$page";

as for the pagination code, you can find nearly thousand topics here on SO

Answer 2

Using query limits and offsets. For example, on page 1 the offset is 0, and the limit is the amount of results you want. As the pagination progresses,so does the offset. The offset states that you want to retrieve a determined ammount of results starting from the 11th results, for example.
I never used CakePHP, but this article seems to explain well how to do the pagination.