A couple of possibilities are:

Store search criteria (form entries) in MySQL
Store query string in MySQL

If the user has to log-in then the MySQL table would
be keyed on the user_id or similar.

If the user does not have to log-in then you will most
likely need to store something in a client-side cookie 
that references the saved query details.

On one of my sites I allow users to either build a query
via a step-by-step procedure or manually enter a query
statement. It is the statement that I store in the 
database together with a name they supply and their user 
id. This allows the user to save multiple queries and 
recall them at a later date by a name that they supplied.

HTH
Graham


> -----Original Message-----
> From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
> Sent: 15 November 2004 09:10
> To: [EMAIL PROTECTED]
> Subject: [PHP] Database search logic question
> 
> 
> For those who recognize this topic from me and perhaps
> are sick of it , my apologies :)
> 
> This is actually a different question more about logic
> then syntax or functionality.
> 
> One of the uses of my search form is that users may
> save their search parameters. Typical benefits, they
> don't have to re-enter all the criteria.  Hitting one
> link or receiving an email can get them the results
> they need.  
> 
> The way I was approaching this was to grab the url,
> the part after the ? , so not the referer.  Whatever
> the second part is called. 
> Only now that I've created a search and results page
> via Post method, of course there is nothing going to
> the URL. I'm wondering at this point if I should
> create a way to let users save their search
> parameters, by grabbing the variables and storing them
> as an array in the database or go back to the URL
> method.
> 
> Curious if anyone sees benefits or negatives with
> either.
> 
> Stuart
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to