[SummerL]

My search should accept "" to create phrases? It allows matching of keywords in " " phrases that is..

It should allow me to search in exact phrases

Records with "crack situated" would be returned
This is a 2mm Crack situated at the DB Engine Latch Cowling

and not
This is a 2mm Crack and it is situated at the DB Engine Latch Cowling.

Now the thing is whenever i do a search, there is this extra \ between them.. The textfield which i key my value in .. "Car situated" was replaced with a \
Advanced Search Keyword: \"Crack situated\"

Code:

 

$Keyword = (isset($_GET['Keyword'])) ? $_GET['Keyword'] : ''; 
$trimmedKeyword = trim($Keyword); 
$trimmedKeyword = stripslashes($trimmedKeyword); 
$trimmedKeyword = str_replace('"', '', $trimmedKeyword); 
//trim whitespace from the stored variable 
$trimmedKeyword = preg_replace('#\s+#',' ',$trimmedKeyword); 
$trimmed_arrayKeyword = explode(" ",$trimmedKeyword); 

// Build SQL Query for each keyword entered 
foreach ($trimmed_arrayKeyword as $trimmKeyword => $word){ 
if(strtolower($word )){ 
$trimmed_arrayKeyword[$trimmKeyword] = "/\b(?<!<)($word)(?!>)\b/i"; 
}//end if 
else $trimmed_arrayKeyword[$trimmKeyword] = '/\b('.preg_quote($word,'/').')\b/i'; 

$queryKeyword = "SELECT * FROM report WHERE AircraftTailNo REGEXP '[[:<:]]{$word}[[:>:]]' OR DefectInfo REGEXP '[[:<:]]{$word}[[:>:]]' OR Rectifications REGEXP '[[:<:]]{$word}[[:>:]]' OR Comments REGEXP '[[:<:]]{$word}[[:>:]]' OR RelatedDoc REGEXP '[[:<:]]{$word}[[:>:]]'";

[darkfreak]

[edit: Sorry, didn't notice you already had stripslashes... ]

You probably have magic_quotes_gpc setting on in your php.ini, which automatically adds \'s in front of quote marks in GET/POST data. See manual for that.

For quick fix, instead of your

Code:

 
$Keyword = (isset($_GET['Keyword'])) ? $_GET['Keyword'] : '';

You can try

Code:

 
$Keyword = (isset($_GET['Keyword'])) ? stripslashes($_GET['Keyword']) : '';

[SummerL]

Thanks i actually got that \ thing solved

But i just can't get my codes to do a exact keywords search with the " "

that is to say whenever i do a search "crack situated"(with the " " on) it should only match records that are like this

This is a 2mm Crack situated at the DB Engine Latch Cowling

[darkfreak]

Your code looks quite complex. Wouldn't it be enough to first strip off the (possibly automatically added) slashes from the trimmed string, then removing the quotation marks and finally, granted you have the string to search in $text, use a query like:

PHP Code:

$query = "SELECT * FROM table WHERE field1 LIKE '%$text%' OR field2 LIKE '%$text%' ... OR fieldN '%$text%' "; 

Of course, making it case-insensitive would require something like:

PHP Code:

$text = strtolower($text);

$query = "SELECT * FROM table WHERE LOWER(field1) LIKE '%$text%' OR LOWER(field2) LIKE '%$text%' ... OR LOWER(fieldN) '%$text%' "; 

I hope it helps!