php mysql search approach

Question

I am trying to implement a search on my website. Getting started, I have some beginner questions.

If I use a pagination script, does those scripts find all results when search is triggered and simply display the results as pages?
Is it better to keep the keywords in a session variable and do search, bring say 10 results everytime user hits "More results" Button?

Thanks for any insights.

It is useful question for me too.

SaidbakR
– SaidbakR

2012-10-31 00:12:04 +00:00
Commented Oct 31, 2012 at 0:12 — SaidbakR
– SaidbakR, Commented Oct 31, 2012 at 0:12

Marc B · Accepted Answer · 2012-08-05 03:38:29Z

2

Unless you cache the results the first time the search is run, the "paged" results generally re-run the search query, then throw away the rows that aren't being displayed
There's no point in using a session variable to store the keywords, unless you don't plan on displaying the search box alongside the results (e.g. as Google search result pages do).

answered Aug 5, 2012 at 3:38

Marc B

362k44 gold badges433 silver badges508 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

aVC Over a year ago

Understood #1. About #2, I was thinking: If I save the keywords, then I can limit the search to say 10 results, and if user clicks on 'more', I can redo a search LIMIT 10,20. Or you think that is not a good idea?

Marc B Over a year ago

that'd be part of #1, actually.

aVC Over a year ago

Thanks for the response. Getting started on it now.

Collectives™ on Stack Overflow

php mysql search approach

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related