RE: [PHP] Database search logic question
| From: | Stuart Felenstein | Date: | Mon, 15 Nov 2004 10:11:57 +0000 |
| Subject: | RE: [PHP] Database search logic question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-202029@lists.php.net to get a copy of this message | ||
Please see inline:
--- Graham Cossey <graham@cossey.plus.com> wrote:
> A couple of possibilities are:
>
> Store search criteria (form entries) in MySQL
> Store query string in MySQL
So with my current form, the where statement is built
from conditions that are set (or not set) in the form.
Perhaps I grab that one array ?
> 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.
>
I have something like that set up now. The user must
be registered and logged in, the difference is I'm
saving the query string from URL.
Stuart