Search function with CI

[eluser]simshaun[/eluser]
Just to clarify, storing arrays in a serialized form is BAD for long term storage.

Why? Ask anyone who stored serialized arrays in the database from PHP4, upgraded to PHP5, and tried to unserialize...

So long as its only short-term storage (such as caching results for a short period of time).. its ok.

I posted this just in case an inexperienced programmer comes along and decides hes gonna start storing everything in a serialized form...

[eluser]Pascal Kriete[/eluser]
You could download EE core and take a look .

It actually doesn't store any results at all.

The pertinent stuff: the id (hash), keywords (what you searched for), search date (for pruning), total results (the count), and the query.

As well as a few more EE related things. You can probably piece together how it works from there. The stored query doesn't include the limit clause (for obvious reasons).