Partial search on extra field

Hi 68 Classifieds,

I needed to make a small mod to the listing.php file so that I could perform a partial match search on an extra field. The mod works fine and Mike suggested I put it forward as a possibility for inclusion in a future version. See trail and working code below.

Cheers,
Matt

Hi there,

When a user searches on an "extra field" it seems that they need to enter the exact term to find a match. Is it possible to make 68 do a partial search on an extra field?

eg. I would like a search on "Town" to find "Big Town", "Small Town", "Any Town" etc.

Thanks - if this has been covered before just point me to it (I couldn't find it).

Cheers,
Matt

mattp008, Yesterday at 8:02 PM Edit Report
#1 Reply

Mike-N-Tosh Developer & Moderator
New

Yes, this has come up a few times. I believe that this is specific to only a text field. As far as I can tell, the only way to resolve this is to actually modify the core, "Listings.php" file. [upload/includes/classes/kernel/Listings.php]

I normally DO NOT RECOMMEND modifying php files directly as this makes it much more difficult to apply any updates/upgrades in the future as you would need to modify the same new file. So if you do make a modification to a ".php" file, PLEASE take the following precautions:
1) ALWAYS ONLY WORK FROM A COPY OF THE FILE!
2) Document your changes with comments inline with your modified code (e.g. //Modification start [explanation] [date] ...the new code... //Modification end) to easily find what you did and why. It is also good practice to keep a separate file of a list of files that you have modified for reference.

I HAVE NOT TESTED THIS CODE! USE AT YOUR OWN RISK!
In the Listings.php file in the 'function getAllListings()' around line #323 find this code:
PHP:
$field_where .= ' AND field'.$fid.'.fID ='.$fid.' AND field'.$fid.'.sValue = '.Filter::mysql_quote(Filter::no_html($value)).' ';
Change the line to this code:
PHP:
//Modification start to add search like for the text 2012-06-30$field_where .= ' AND field'.$fid.'.fID ='.$fid.' AND field'.$fid.'.sValue LIKE '.Filter::mysql_quote('%'.Filter::no_html($value).'%').' ';//Modification end
If you test this and it works as you would like, I would recommend that you submit this to 68 Classifieds as a new "Feature Request" in the appropriate forum. This modification would still find the exact text as it does now as well as match anything before and after the specified text as far as I can tell.