X-Cart forums

[xcart-dev]

I've been looking around for an answer to this but can't seem to find one.

You can set the search results to be for 'any', 'all' or the exact phrase. What I need is to set the search to be the exact phrase and a whole word.

In php this would be

PHP Code:

if (preg_match("/\b$search_string\b/i", $database_output)) 


which results in a case insensitive result but only for whole words.

Now there must be somewhere in X-Carts many files where I can take the search result and change it into a 'whole word' requirement. This is important for part numbers such as the following:
Searching "EC-22" should only show up part number EC-22, not part number EC-22542.

Any suggestions how and where ... ?

[cflsystems]

include/search.php

[xcart-dev]

It was indeed include.search.php.

For anyone who stumbles on this thread I wanted to have whole word matches but only in the extra fields. So I changed:

foreach ($data['extra_fields'] as $k => $v) { 
$condition[] = '(' . $sql_tbl['extra_field_values'] . '.value LIKE \'%' . $data['substring'] . '%\' AND ' . $sql_tbl['extra_fields'] . '.fieldid = \'' . $k . '\')';
            }

To:

foreach ($data['extra_fields'] as $k => $v) { 
$condition[] = '(' . $sql_tbl['extra_field_values'] . '.value REGEXP \'[[:<:]]' . $data['substring'] . '[[:>:]]\' AND ' . $sql_tbl['extra_fields'] . '.fieldid = \'' . $k . '\')';
            }

The Regexp now demands that only whole words are found rather than words 'like'