我搜索了几个小时也没找到适合我的答案,所以我来这里请教。我来自匈牙利,我们的语言中使用以下重音字符: áéíóöőúüű(当然还有大写字母)。我想在PHP中实现智能搜索,使用户可以输入一个搜索词,并在MySQL表或搜索字段中查找结果,无论是否有重音。因此……
我的MySQL表使用utf8_hungarian_ci。我可以进行PHP转换,使得无论用户键入'bla'或'blá'都会返回'bla',并且在MySQL数据库中进行搜索。
但是我的问题是……我的数据库可能会有'bla fér'或'bláter'字段条目。但如果我们使用从PHP搜索的'bla',它只返回'bla fer'。如何转换我正在搜索的字段,使'bla fér' -> 'bla fer'和'bláter' -> 'blater'。因此,实质上……
我想去掉重音符号,并将其转换为没有重音符号的字符。但是当然,仅仅是为了搜索。请帮帮我!谢谢!
编辑:
我的MySQL表使用utf8_hungarian_ci。我可以进行PHP转换,使得无论用户键入'bla'或'blá'都会返回'bla',并且在MySQL数据库中进行搜索。
但是我的问题是……我的数据库可能会有'bla fér'或'bláter'字段条目。但如果我们使用从PHP搜索的'bla',它只返回'bla fer'。如何转换我正在搜索的字段,使'bla fér' -> 'bla fer'和'bláter' -> 'blater'。因此,实质上……
我想去掉重音符号,并将其转换为没有重音符号的字符。但是当然,仅仅是为了搜索。请帮帮我!谢谢!
编辑:
<?php
$search = $_GET["search"]; // May contain áéíóöőúüű
$accented= array("Ö","ö","Ü","ü","ű","Ó","ó","O","o","Ú","ú","Á","á","U","u","É","é","Í","í"," ","+","'","ő", "Ű", "Ő", "ä","Ä","ű","Ű","ő","Ő");
$nonaccented=array("O","o","U","u","u","O","o","O","o","U","u","A","a","U","u","E","e","I","i","_","_","_","o", "U", "O", "a","A","u","u","o","o");
$search = str_replace($accented,$nonaccented,$search);
$query = "SELECT id, name FROM people WHERE name LIKE '%$search%'"; // Database column 'name' may also contain áéíóöőúüű
?>