PDA

View Full Version : Advanced search for three letter word like BMW?



rosegarden
July 28, 2012, 07:21 AM
Can I reduce the search letter to three?

For example If u search title .... BMW ... it will be problem as the minimum 4 letters

Petrache Nicolae
July 29, 2012, 03:43 PM
I assume that this limitation is to prevent false results. I have HP for instance as producer and to overcome this i used Field-bound Boxes to create a filter based on the producer. Better than nothing.

Viktor
July 30, 2012, 03:40 AM
Hello Desmond Lim,

I have changed it on your site.
But if anybody want same follow to my instruction.

Go to Ftp://includes>>classes>>rlSearch.class.php
method with name 'search'

find code:


case 'text':
if ( $fKey == 'keyword_search' )
{
if ( !$this -> keywordSearch($f, $data['keyword_search_type'], $type) )
{
return false;
}
}
else
{
if ( is_numeric($f) )
{
$sql .= "AND `T1`.`{$fKey}` LIKE '%". $f ."%' ";
}
else
{
$sql .= "AND (MATCH (`T1`.`{$fKey}`) AGAINST('". $f ."' IN BOOLEAN MODE)) ";
}
}
break;

and replace to:

case 'text':
if ( $fKey == 'keyword_search' )
{
if ( !$this -> keywordSearch($f, $data['keyword_search_type'], $type) )
{
return false;
}
}
elseif( $fKey == 'search_account' )
{
$sql .="AND `T7`.`Username` = '{$f}' ";
}
else
{
$sql .= "AND `T1`.`{$fKey}` LIKE '%". $f ."%' ";
}
break;

rosegarden
July 30, 2012, 06:26 AM
hi Viktor

Thanks can you help to look into the reset button

http://www.flynax.com/forum/showthread.php?529-How-to-create-a-clear-button-using-Jquery-for-refine-search

It should be like the reset button found on the admin listing page below for filter ...

http://general.demoflynax.com/admin/index.php?controller=listings

Reset is deeply helpful for users