[Resolved] Strip/Add lashes and boolean mode....

[thedream]

Hi there,

In a past thread, I had resolved with the community the problem doing a query containing an apostroph - ' -.
For example, be able to do a reserach on - Jean Richard's Circus -

But I discover a new problem, after solving the precedent one: in fact I can't do know a research like this: -"mortus cubitus"- with the quotations marks, the result tell me it can't find anything like -"mortus cubitus"-
But in the mysql manual putting the quotations marks perfom a query like find absolutely this sentence....

How can I do?

Here is my code:

....
if (isSet($_GET['search'])) {
$search = $_GET['search'];
$search = ' ' . strtolower($search) . ' ';
$search = trim($search);
$search = addSlashes($search);
} else {$search = '';}

....

My mysql database is in FUULTEXT, and I am doing the query in BOOLEAN MODE.

Please help me,

Marc-André
😕

[stolzyboy]

post your query...

[thedream]

here my code:

if (isSet($_GET['search'])) {
$search = $_GET['search'];
$search = ' ' . strtolower($search) . ' ';
$search = trim($search);
$search = addSlashes($search);
$search = str_replace('+', ' +', $search);
//$search = str_replace('-', ' -', $search);
$search = str_replace(' and ', ' +', $search);
$search = str_replace(' not ', ' -', $search);
$search = str_replace(', ', ' ', $search);
$search = str_replace(',', ' ', $search);
$search = str_replace(':', ' ', $search);
$search = str_replace(';', ' ', $search);
$search = str_replace('.', ' ', $search);
$search = str_replace('%', ' ', $search);

$search = str_replace('\"', '"', $search);

} else {$search = '';}

/* here the important part of the query: */
if (empty($search)) {
$addmatch = '';
} else {
//$search = addSlashes($search);
$addmatch = "AND MATCH(phototek.im_name, phototek.comments, phototek.keywords, cat.im_cat,
 catgen.im_catgen, cont.im_cont, pays.im_pays, ville.im_ville,
 format.im_format, color.im_color, photo.photo) AGAINST('$search' IN BOOLEAN MODE)";
}

and in my form I have:

<input name="search" type="text" value="<?php $search = stripSlashes($search); echo $search; ?>" size="15" class="text">

My problem is always that the query --- "o'reilly book" ----(with double qute) doesn't work.

And now when i use double quote, my field doesn't show the content of $search !

Any Idea?
Marc

[thedream]

I have found the solution:

You just have to replace the double quote (") by &quot !
that's all !

Thanks to all
Marc