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

78. function GetGB2312String($name)

79. {
80. $tostr = "";
81. for($i=0;$i {
82. $curbin = ord(substr($name,$i,1));
83. if($curbin < 0x80)
84. {
85. $tostr .= substr($name,$i,1);
86. }elseif($curbin < bindec("11000000")){
87. $str = substr($name,$i,1);
88. $tostr .= "&#".ord($str).";";
89. }elseif($curbin < bindec("11100000")){
90. $str = substr($name,$i,2);
91. $tostr .= "&#".GetUnicodeChar($str).";";
92. $i += 1;
93. }elseif($curbin < bindec("11110000")){
94. $str = substr($name,$i,3);
95. $gstr= iconv("UTF-8","GB2312",$str);
96. if(!$gstr)
97. {
98. $tostr .= "&#".GetUnicodeChar($str).";";
99. }else{
100. $tostr .= $gstr;
101. }
103. $i += 2;
104. }elseif($curbin < bindec("11111000")){
105. $str = substr($name,$i,4);
106. $tostr .= "&#".GetUnicodeChar($str).";";
108. $i += 3;
109. }elseif($curbin < bindec("11111100")){
110. $str = substr($name,$i,5);
111. $tostr .= "&#".GetUnicodeChar($str).";";
113. $i += 4;
114. }else{
115. $str = substr($name,$i,6);
116. $tostr .= "&#".GetUnicodeChar($str).";";
118. $i += 5;
119. }
120. }
122. return $tostr;
123. }
125. function GetUnicodeChar($str)
126. {
127. $temp = "";
128. for($i=0;$i {
129. $x = decbin(ord(substr($str,$i,1)));
130. if($i == 0)
131. {
132. $s = strlen($str)+1;
133. $temp .= substr($x,$s,8-$s);
134. }else{
135. $temp .= substr($x,2,6);
136. }
137. }
139. return bindec($temp);
140. }

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

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

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

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

146. $text1="$myrow[0]";
147. $text= GetGB2312String($text1);//获得GB2312编码串
148. $flow = get_pinyin_array($text);//获得拼音
149. $result2 = mysql_query("update groups set titlepinyin='$flow[0]' where group_id = $myrow[1]",$db);
150. printf("%s
     %s
     ",$text1,$flow[0]);
151. }
152. ?>

表中加入一个字段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. ?>