case and accent - insensitive regular expression?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux