PHP Syntax for assigning string to variable for boolean search

binzy

Hello

As you can probably see from the way I have written the title for this thread, I am new at this. And hopefully I have a simple problem with a simple enough solution.

I have a working code with category pages being generated with different search strings, for example, the 'baby' category page code has a query run with the keyword as "baby", and results in all baby products.

This is the part of my code that is relevant:

if (isset($_GET['page'])) { $page  = $_GET['page']; } else { $page=1; }; 

  $var = "baby";   

  $trimmed = trim($var); //trim whitespace from the stored variable

//Query from database

 $query = "SELECT * FROM Test_Travel WHERE MATCH (name,keywords,description) AGAINST ('%$trimmed%') ORDER BY price";

My problem is I dont know what syntax to use for boolean search, I mean , if my query uses AGAINST('+baby +bib'), I dont understand how to assign this value to $var in the php code. Simply $var = "+baby +bib" doesnt work because this is treated as baby OR bib, and I want it to be treated as baby AND bib. Please help me with the correct syntax for assigning this value to $var. I have been unable to find it on the internet. Thanks!

sneakyimp

Not sure what you mean by "boolean search" or "assigning this value to $var".

To assign a value to $var, you simply assign something as you did in this line:

  $var = "baby";

If you want a query that will locate records in Test_Travel where some_field contains the string 'baby' and the string 'bib', then this query might work:

SELECT * FROM Test_Travel WHERE MATCH(name, keywords, description) AGAINST ('+baby +bib' IN BOOLEAN MODE)

If not then try this one:

SELECT * FROM Test_Travel WHERE some_field LIKE '&#37;baby%' AND some_field LIKE '%baby%'

If you want to check other fields besides some_field then you will multiply the number of LIKE clauses in your sql query.

binzy

Hello, I think I did not explain myself correctly. Anyways, it doesnt matter now, as I have understood what you are trying to say. Thanks for the help.