Re: spliting keywords by GET method and SQL query
| From: | Brian | Date: | Thu, 30 Sep 2004 13:54:59 +0000 |
| Subject: | Re: spliting keywords by GET method and SQL query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-36481@lists.php.net to get a copy of this message | ||
$whereStatement=str_replace("+", " AND message LIKE ", $strToParse);
$whereStatement=str_replace(",", " OR message LIKE ", $whereStatement);
SELECT * FROM mytable WHERE message LIKE $whereStatement
As for your invalid input example, good luck, I don't see any easy way
of doing that.
On Wed, 29 Sep 2004 18:47:28 +0300, Murat BIYIKLI
<admin@muratbiyikli.name.tr> wrote:
> I need to split the keyword on search input and generate an sql query,
> for ex: the input value is: europe+america,asia
> so I want to generate an sql like this:
> SELECT * FROM mytable WHERE message LIKE %europe% AND message LIKE %america%
> OR message LIKE %asia%
>
> The + (plus) means AND and , (comma) means OR. Also I need to control input
> variables to prevent error on sql query forexample an input value like:
> ,,,europe+america,+asia+ should not generate an error.
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>