RE: [PHP] Database search logic question
| From: | Graham Cossey | Date: | Mon, 15 Nov 2004 10:44:31 +0000 |
| Subject: | RE: [PHP] Database search logic question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-202031@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: Stuart Felenstein [mailto:stuart4m@yahoo.com]
> Sent: 15 November 2004 10:12
> To: Graham Cossey; php-general@lists.php.net
> Subject: RE: [PHP] Database search logic question
>
>
> 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 ?
[snip]
I was thinking more along the lines of storing the SQL string.
"SELECT ... FROM vendorjobs WHERE..."
Then when recalled there is no further array processing etc to be done.
However, you may want some kind of validation to prevent malicious use of
the feature.
I've never attempted to store an array in a MySQL table. But storing the
'where' is an alternative.
Other guys (and girls) on the list probably have much more experience of
this than myself.
Graham