[Resolved] Transforming foo to foo* in a search query....

[thedream]

Hi there,

I need your brilliant brain to resolve this:

I am working on my Mysql database with a full text searching in boolean mode, and the configuration file of the mysql database
is set to ft_min_word_len=4 and I CAN'T change it, the administrator of the provider won't want to do it,
because I am not the only one using this.

So I am tring to find a solution to make a query like "ice cube".
What I've found is to add an asterix to the words containing less than 4 characters, but my code doesn't work, here it is:

$keys = explode(" ", $search);
foreach($keys as $detail) {
if (strlen($detail) <= 3) {
$detail = $detail ."*";
} else {
$detail = detail;
}
}
$search = implode(" ", $keys);

I am not good with array.
Could someone will be kind enough to help me?

Marc 😕

[Drakla]

$keys = explode(" ", $search);
foreach($keys as $detail) {
if (strlen($detail) <= 3) {
$detail = $detail ."*";
} else {
$detail = detail;  //What the hell is this line about?
}
}
$search = implode(" ", $keys);

Change to:

$keys = explode(" ", $search);
for( $i=0; $i<count($keys); $i++ )
{
    if (strlen($keys[$i]) <= 3)
    {
        $keys[$i] = $keys[$i]."*";
    }
}
$search = implode(" ", $keys);

Think that should work

[thedream]

You are a great guy !

Works perfectly...
Thank you very much.

Marc