php mysql中utf8编码汉字转换成拼音

3. require_once('pinyin_table.php');

5. function get_pinyin_array($string)
6. {
7. global $pinyin_table;
8. $flow = array();
9. for ($i=0;$i {
10. if (ord($string[$i]) >= 0x81 and ord($string[$i]) {
11. $h = ord($string[$i]);
12. if (isset($string[$i+1]))
13. {
14. $i++;
15. $l = ord($string[$i]);
16. if (isset($pinyin_table[$h][$l]))
17. {
18. array_push($flow,$pinyin_table[$h][$l]);
19. }
20. else
21. {
22. array_push($flow,$h);
23. array_push($flow,$l);
24. }
25. }
26. else
27. {
28. array_push($flow,ord($string[$i]));
29. }
30. }
31. else
32. {
33. array_push($flow,ord($string[$i]));
34. }
35. }
37. //print_r($flow);
39. $pinyin = array();
40. $pinyin[0] = '';
41. for ($i=0;$i {
42. if (is_array($flow[$i]))
43. {
44. if (sizeof($flow[$i]) == 1)
45. {
46. foreach ($pinyin as $key => $value)
47. {
48. $pinyin[$key] .= $flow[$i][0];
49. }
50. }
51. if (sizeof($flow[$i]) > 1)
52. {
53. $tmp1 = $pinyin;
54. foreach ($pinyin as $key => $value)
55. {
56. $pinyin[$key] .= $flow[$i][0];
57. }
58. for ($j=1;$j {
59. $tmp2 = $tmp1;
60. for ($k=0;$k {
61. $tmp2[$k] .= $flow[$i][$j];
62. }
63. array_splice($pinyin,sizeof($pinyin),0,$tmp2);
64. }
65. }
66. }
67. else
68. {
69. foreach ($pinyin as $key => $value)
70. {
71. $pinyin[$key] .= chr($flow[$i]);
72. }
73. }
74. }
75. return $pinyin;
76. }

77. function GetGB2312String($name)

78. {
79. $tostr = "";
80. for($i=0;$i {
81. $curbin = ord(substr($name,$i,1));
82. if($curbin {
83. $tostr .= substr($name,$i,1);
84. }elseif($curbin $str = substr($name,$i,1);
85. $tostr .= "".ord($str).";";
86. }elseif($curbin $str = substr($name,$i,2);
87. $tostr .= "".GetUnicodeChar($str).";";
88. $i += 1;
89. }elseif($curbin $str = substr($name,$i,3);
90. $gstr= iconv("UTF-8","GB2312",$str);
91. if(!$gstr)
92. {
93. $tostr .= "".GetUnicodeChar($str).";";
94. }else{
95. $tostr .= $gstr;
96. }
98. $i += 2;
99. }elseif($curbin $str = substr($name,$i,4);
100. $tostr .= "".GetUnicodeChar($str).";";
102. $i += 3;
103. }elseif($curbin $str = substr($name,$i,5);
104. $tostr .= "".GetUnicodeChar($str).";";
106. $i += 4;
107. }else{
108. $str = substr($name,$i,6);
109. $tostr .= "".GetUnicodeChar($str).";";
111. $i += 5;
112. }
113. }
115. return $tostr;
116. }
118. function GetUnicodeChar($str)
119. {
120. $temp = "";
121. for($i=0;$i {
122. $x = decbin(ord(substr($str,$i,1)));
123. if($i == 0)
124. {
125. $s = strlen($str)+1;
126. $temp .= substr($x,$s,8-$s);
127. }else{
128. $temp .= substr($x,2,6);
129. }
130. }
132. return bindec($temp);
133. }

134. $db = mysql_connect("127.0.0.1:3307", "root","123");

135. mysql_select_db("qq",$db);

136. $result = mysql_query("set names utf8",$db);
137. $result = mysql_query("select title,group_id from groups",$db);

138. while ($myrow = mysql_fetch_array($result)) {

139. $text1="$myrow[0]";
140. $text= GetGB2312String($text1);//获得GB2312编码串
141. $flow = get_pinyin_array($text);//获得拼音
142. $result2 = mysql_query("update groups set titlepinyin='$flow[0]' where group_id = $myrow[1]",$db);
143. printf("%s
     %s
     ",$text1,$flow[0]);
144. }
145. ?>

复制代码

表中加入一个字段titlepinyin

2. mysql>alter table groups add titlepinyin varchar(1000);

复制代码

rpc.php改为

3. $db = mysql_connect("127.0.0.1:3307", "root","123");

4. if(!$db) {
5. // Show error if we cannot connect.
6. echo 'ERROR: Could not connect to the database.';
7. } else {
8. // Is there a posted query string?
9. if(isset($_POST['queryString'])) {
10. $queryString = $_POST['queryString'];
11. $length=strlen($queryString);

12. mysql_select_db("qq",$db);

13. $result = mysql_query("set names utf8");

14. // Is the string length greater than 0?

15. if($length>0) { （程序员之家 bbs.it-home.org 编辑整理）
16. $sql="";
17. if(!ereg("^[A-Za-z0-9_.-]+$",$queryString))//如果有汉字的话
18. {$sql="SELECT title FROM groups WHERE title LIKE '$queryString%' LIMIT 10";
19. }else{//英文数字符号
20. $sql="SELECT title FROM groups WHERE titlepinyin LIKE '$queryString%' LIMIT 10";
21. }
22. $query = mysql_query($sql);
23. // Run the query: We use LIKE ‘$queryString%’
24. if($query) {
25. while ($myrow = mysql_fetch_array($query)) {
26. // Format the results, im using
27. for the list, you can change it.
28. // The onClick function fills the textbox with the result.
29. echo '
30. '.$myrow[0].'
';
31. }
32. } else {
33. echo "ERROR: There was a problem with the query $sql.";
34. }
35. } else {
36. }
37. } else {
38. echo 'There should be no direct access to this script!';
39. }
40. }
41. ?>

复制代码