On Sat, Jul 12, 2008 at 10:29 AM, tedd <tedd.sperling@xxxxxxxxx> wrote:> At 9:36 AM +0200 7/12/08, Giulio Mastrosanti wrote:>>>> Hi,>> I have a php page that asks user for a key ( or a list of keys ) and then>> shows a list of items matching the query.>>>> every item in the list shows its data, and the list of keys it has ( a>> list of comma-separated words )>>>> I would like to higlight, in the list of keys shown for every item, the>> words matching the query,>>>> this can be easily achieved with a search and replace, for every search>> word, i search it in the key list and replace it adding a style tag to>> higlight it such as for example to have it in red color:>>>> if ( @stripos($keylist,$keysearch!== false ) {>> $keylist = str_ireplace($keysearch,'<span style="color:>> #FF0000">'.$keysearch.'</span>',$keylist);>> }>>>> but i have some problem with accented characters:>>>> i have mysql with character encoding utf8, and all the php pages are>> declared as utf8>>>> mysql in configured to perform queries in a case and accent insensitive>> way.>> this mean that if you search for the word 'cafe', you have returned rows>> that contains in the keyword list 'cafe', but also 'café' with the accent. (>> I think it has to do with 'collation' settings, but I'm not investigating at>> the moment because it is OK for me the way it works ).>>>> now my problem is to find a way ( I imagine with some kind of regular>> expression ) to achieve in php a search and replace accent-insensitive, so>> that i can find the word 'cafe' in a string also if it is 'café', or 'CAFÉ',>> or 'CAFE', and vice-versa.>>>> hope the problem is clear and well-explained in english,>>>> thank you for any tip,>>>> Giulio>> Giulio:>> Three things:>> 1. Your English is fine.>> 2. Try using mb_ereg_replace()>> http://www.php.net/mb_ereg_replace>> Place the accents you want to change in that and change them to whatever you> want.>> 3. Change:>> <span style="color: #FF0000">'.$keysearch.'</span>'>> to>> <span class="keysearch">'.$keysearch.'</span>'>> and add>> .keysearch> {> color: #FF0000;> }>> to your css.>> Cheers,>> tedd
I may be mistaken (and if I am, then just ignore this as ignorantrambling), but I don't think he's wanting to replace the accentedcharacters in the original string. I think he's just wanting thepattern to find all variations of the same string and highlight themwithout changing them. For example, his last paragraph would look likethis:
[quote]now my problem is to find a way ( I imagine with some kind of regularexpression ) to achieve in php a search and replaceaccent-insensitive, so that i can find the word '<spanclass="keysearch">cafe</span>' in a string also if it is '<spanclass="keysearch">café</span>', or '<spanclass="keysearch">CAFÉ</span>', or '<spanclass="keysearch">CAFE</span>', and vice-versa.[/quote]
The best I can think of right now is something like this:
<?php
function highlight_search_terms($word, $string) { $search = preg_quote($word); $search = str_replace('a', '[aàáâãäå]', $search); $search = str_replace('e', '[eèéêë]', $search); /* repeat for each possible accented character */
return preg_replace('/\b' . $search . '\b/i', '<spanclass="keysearch">$0</span>', $string); }
$string = "now my problem is to find a way ( I imagine with some kindof regular expression ) to achieve in php a search and replaceaccent-insensitive, so that i can find the word 'cafe' in a stringalso if it is 'café', or 'CAFÉ', or 'CAFE', and vice-versa.";
echo highlight_search_terms('cafe', $string);
?>
Andrew
