如何在放入数据库之前将表单中输入的特殊字符转换为相似的英文字符？

Question

e.g. we have form that ask for first name last name country, country is drop down list, but name is free entry. We need to make sure we have no special characters in input field. And instead convert them to english. e.g.

Á -> A,á -> a,Č -> C,č -> c,ď -> d,é -> e,ě -> e,É -> E,Ě -> E,í -> i,Í
-> i,Ň -> N,ň -> n,Ó -> O,ó -> o,Ř -> R,ř -> r,Š -> S,š -> s,ť -> t,Ú -> U,ú -> u,Ů -> U,ů -> u,
Ý -> Y,ý -> y,Ž -> Z,ž -> z

Is there some way to do it in php or mysql?

Answer 1

Use php function utf8_encode

Or detect encoding and change it if it is not utf-8, like below:

<?php
//$s is a string from whatever source
mb_detect_encoding($s, "UTF-8") == "UTF-8" ? : $s = utf8_encode($s);
?>