mysql utf8 汉字转拼音_php mysql中utf8编码汉字转换成拼音
例子，php mysql实现编码转换。 代码示例:
require_once('pinyin_table.php');
function get_pinyin_array($string)
{
global $pinyin_table;
$flow = array();
for ($i=0;$i
{
if (ord($string[$i]) >= 0x81 and ord($string[$i]) <= 0xfe)
{
$h = ord($string[$i]);
if (isset($string[$i+1]))
{
$i++;
$l = ord($string[$i]);
if (isset($pinyin_table[$h][$l]))
{
array_push($flow,$pinyin_table[$h][$l]);
}
else
{
array_push($flow,$h);
array_push($flow,$l);
}
}
else
{
array_push($flow,ord($string[$i]));
}
}
else
{
array_push($flow,ord($string[$i]));
}
}
//print_r($flow);
$pinyin = array();
$pinyin[0] = '';
for ($i=0;$i
{
if (is_array($flow[$i]))
{
if (sizeof($flow[$i]) == 1)
{
foreach ($pinyin as $key => $value)
{
$pinyin[$key] .= $flow[$i][0];
}
}
if (sizeof($flow[$i]) > 1)
{
$tmp1 = $pinyin;
foreach ($pinyin as $key => $value)
{
$pinyin[$key] .= $flow[$i][0];
}
for ($j=1;$j
{
$tmp2 = $tmp1;
for ($k=0;$k
{
$tmp2[$k] .= $flow[$i][$j];
}
array_splice($pinyin,sizeof($pinyin),0,$tmp2);
}
}
}
else
{
foreach ($pinyin as $key => $value)
{
$pinyin[$key] .= chr($flow[$i]);
}
}
}
return $pinyin;
}
function GetGB2312String($name)
{
$tostr = "";
for($i=0;$i
{
$curbin = ord(substr($name,$i,1));
if($curbin < 0x80)
{
$tostr .= substr($name,$i,1);
}elseif($curbin < bindec("11000000")){
$str = substr($name,$i,1);
$tostr .= "".ord($str).";";
}elseif($curbin < bindec("11100000")){
$str = substr($name,$i,2);
$tostr .= "".GetUnicodeChar($str).";";
$i += 1;
}elseif($curbin < bindec("11110000")){
$str = substr($name,$i,3);
$gstr= iconv("UTF-8","GB2312",$str);
if(!$gstr)
{
$tostr .= "".GetUnicodeChar($str).";";
}else{
$tostr .= $gstr;
}
$i += 2;
}elseif($curbin < bindec("11111000")){
$str = substr($name,$i,4);
$tostr .= "".GetUnicodeChar($str).";";
$i += 3;
}elseif($curbin < bindec("11111100")){
$str = substr($name,$i,5);
$tostr .= "".GetUnicodeChar($str).";";
$i += 4;
}else{
$str = substr($name,$i,6);
$tostr .= "".GetUnicodeChar($str).";";
$i += 5;
}
}
return $tostr;
}
function GetUnicodeChar($str)
{
$temp = "";
for($i=0;$i
{
$x = decbin(ord(substr($str,$i,1)));
if($i == 0)
{
$s = strlen($str)+1;
$temp .= substr($x,$s,8-$s);
}else{
$temp .= substr($x,2,6);
}
}
return bindec($temp);
}
$db = mysql_connect("127.0.0.1:3307", "root","123");
mysql_select_db("qq",$db);
$result = mysql_query("set names utf8",$db);
$result = mysql_query("select title,group_id from groups",$db);
while ($myrow = mysql_fetch_array($result)) {
$text1="$myrow[0]";
$text= GetGB2312String($text1);//获得GB2312编码串
$flow = get_pinyin_array($text);//获得拼音
$result2 = mysql_query("update groups set titlepinyin='$flow[0]' where group_id = $myrow[1]",$db);
printf("%s
%s
",$text1,$flow[0]);
}
?>
表中加入一个字段titlepinyin 代码示例:
mysql>alter table groups add titlepinyin varchar(1000);
rpc.php改为 代码示例:
$db = mysql_connect("127.0.0.1:3307", "root","123");
if(!$db) {
// Show error if we cannot connect.
echo 'ERROR: Could not connect to the database.';
} else {
// Is there a posted query string?
if(isset($_POST['queryString'])) {
$queryString = $_POST['queryString'];
$length=strlen($queryString);
mysql_select_db("qq",$db);
$result = mysql_query("set names utf8");
// Is the string length greater than 0?
if($length>0) { (脚本学堂 www.# 编辑整理)
$sql="";
if(!ereg("^[A-Za-z0-9_.-]+$",$queryString))//如果有汉字的话
{$sql="SELECT title FROM groups WHERE title LIKE '$queryString%' LIMIT 10";
}else{//英文数字符号
$sql="SELECT title FROM groups WHERE titlepinyin LIKE '$queryString%' LIMIT 10";
}
$query = mysql_query($sql);
// Run the query: We use LIKE ‘$queryString%’
if($query) {
while ($myrow = mysql_fetch_array($query)) {
// Format the results, im using
for the list, you can change it.// The onClick function fills the textbox with the result.
echo '
'.$myrow[0].'';}
} else {
echo "ERROR: There was a problem with the query $sql.";
}
} else {
}
} else {
echo 'There should be no direct access to this script!';
}
}
?>