免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
› 论坛 › 程序设计 › PHP › 急,辛苦一晚没解决的== 中文乱码问题
最近访问板块 发新帖
查看: 1957 | 回复: 9
打印 上一主题 下一主题

急,辛苦一晚没解决的== 中文乱码问题 [复制链接]

LiveHappy

论坛徽章:
0
跳转到指定楼层
1楼 [收藏(0)] [报告]
发表于 2006-10-11 00:35 |只看该作者 |倒序浏览
可能我的方法有问题.

要从数据库里需数据,通过这些数据生成xml文件.
我是通过循环生成一个字符串,然后写入到一个文件里

但是得到的文件在浏览器里有时打不开,有时可以直接打开
通过mb_detect_encoding($str)检测到字符串是ASCII 的,通过iconv()和mb_convert_encoding()和utf8_encode()转换过,转换后可以在浏览器中打开时,其中的  中文  是乱码,


  2. $content = '<?xml version="1.0"?>'."\n";
  3. $content.="<data>\n";

  5. $sql = "select * from parts where parts_sn in(select Sn from Daiguan where sellers_id = ".$seller_id.") order by parts_sn";
  6. $DB->query($sql);
  7. $data = $DB->Get_Rows_Array();
  8.        
  9. foreach($data as $row)
  10. {
  11. $content .="<node>\n";
  12.         $content .='<parts property="sn">'.$row['parts_sn']."</parts>\n";
  13.         $content .='<parts property="oldno">'.$row['parts_old_No']."</parts>\n";
  14.         $content .='<parts property="name">'.$row['parts_name']."</parts>\n";
  15.         $content .='<parts property="type">'.$row['parts_type']."</parts>\n";
  16.         $content .='<parts property="note">'.$row['parts_notes_i']."</parts>\n";
  17.         $content .='<parts property="no1">'.$row['parts_No_1']."</parts>\n";
  18.         $content .='<parts property="no2">'.$row['parts_No_2']."</parts>\n";
  19.         $content .='<parts property="no3">'.$row['parts_No_3']."</parts>\n";
  20.         $content .='<parts property="unit">'.$row['parts_unit']."</parts>\n";
  21. $content .="</node>\n";
  22. }
  23. $content.="</data>";

  25. fwrite($file_handle,$content);
复制代码

[ 本帖最后由 LiveHappy 于 2006-10-11 00:52 编辑 ]
LiveHappy

论坛徽章:
0
2楼 [报告]
发表于 2006-10-11 00:38 |只看该作者
下面这种写法也不行


  3. $content1 = '<?xml version="1.0"?>'."\n";
  4. $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);

  6. $content1="<data>\n";
  7. $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);

  9. $sql = "select * from parts where parts_sn in(select Sn from Daiguan where sellers_id = ".$seller_id.") order by parts_sn";
  10. $DB->query($sql);
  11. $data = $DB->Get_Rows_Array();

  13. foreach($data as $row)
  14. {
  15. $content1="<node>\n";
  16. $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);

  18.         $content1='<parts property="sn">';
  19.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);

  21.         $content1=$row['parts_sn'];
  22.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  23.         $content1="</parts>\n";
  24.         $content1='<parts property="oldno">';
  25.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  26.         $content1=$row['parts_old_No'];
  27.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  28.         $content1="</parts>\n";
  29.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  30.         $content1=='<parts property="name">';
  31.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  32.         $content1=$row['parts_name'];
  33.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  34.         $content1="</parts>\n";
  35.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  36.         $content1=='<parts property="type">';
  37.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  38.         $content1=$row['parts_type'];       
  39.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  40.         $content1="</parts>\n";
  41.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  42.         $content1='<parts property="note">';
  43.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  44.         $content1=$row['parts_notes_i'];
  45.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  46.         $content1="</parts>\n";
  47.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  48.         $content1='<parts property="no1">';
  49.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  50.         $content1=$row['parts_No_1'];
  51.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  52.         $content1="</parts>\n";
  53.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  54.         $content1='<parts property="no2">';
  55.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  56.         $content1=$row['parts_No_2'];
  57.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  58.         $content1="</parts>\n";
  59.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  60.         $content1='<parts property="no3">';
  61.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  62.         $content1=$row['parts_No_3'];
  63.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  64.         $content1="</parts>\n";
  65.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  66.         $content1='<parts property="unit">';
  67.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  68.         $content1=$row['parts_unit'];
  69.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  70.         $content1="</parts>\n";
  71.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  72. $content1="</node>\n";
  73. $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  74. }
  75. $content1="</data>";
  76. $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
复制代码
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
LiveHappy

论坛徽章:
0
3楼 [报告]
发表于 2006-10-11 00:43 |只看该作者
把iconv()换成mb_convert_encoding()也不行;
使用utf8_encode()也是不行的.
用EditPlus打开是没问题的,但是在浏览器中打开时,中文就是乱码.
如果不转换成utf8,浏览器就无法直接打开.

  2. $content = '<?xml version="1.0"?>'."\n";
  3. $content.="<data>\n";

  5. $sql = "select * from parts where parts_sn in(select Sn from Daiguan where sellers_id = ".$seller_id.") order by parts_sn";
  6. $DB->query($sql);
  7. $data = $DB->Get_Rows_Array();
  8.        
  9. foreach($data as $row)
  10. {
  11. $content .="<node>\n";
  12.         $content .='<parts property="sn">'.$row['parts_sn']."</parts>\n";
  13.         $content .='<parts property="oldno">'.$row['parts_old_No']."</parts>\n";
  14.         $content .='<parts property="name">'.$row['parts_name']."</parts>\n";
  15.         $content .='<parts property="type">'.$row['parts_type']."</parts>\n";
  16.         $content .='<parts property="note">'.$row['parts_notes_i']."</parts>\n";
  17.         $content .='<parts property="no1">'.$row['parts_No_1']."</parts>\n";
  18.         $content .='<parts property="no2">'.$row['parts_No_2']."</parts>\n";
  19.         $content .='<parts property="no3">'.$row['parts_No_3']."</parts>\n";
  20.         $content .='<parts property="unit">'.$row['parts_unit']."</parts>\n";
  21. $content .="</node>\n";
  22. }
  23. $content.="</data>";


  26. fwrite($file_handle,utf8_encode($content));
复制代码
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
LiveHappy

论坛徽章:
0
4楼 [报告]
发表于 2006-10-11 00:51 |只看该作者
下面是没有转换,在浏览器里直接打开的效果
其中的name应该是中文

  2. <?xml version="1.0" ?>
  3. - <data>
  4. - <node>
  5.   <parts property="sn">2721</parts>
  6.   <parts property="oldno">986006</parts>
  7.   <parts property="name">&raquo;·&sup1;&iquest;</parts>
  8.   <parts property="type">51-70</parts>
  9.   <parts property="note" />
  10.   <parts property="no1">Q67570</parts>
  11.   <parts property="no2">0</parts>
  12.   <parts property="no3" />
  13.   <parts property="unit">&cedil;&ouml;</parts>
  14.   </node>
  15.   </data>
复制代码

在EditPlus里打开是完整的


  2. <?xml version="1.0"?>
  3. <data>
  4. <node>
  5. <parts property="sn">2721</parts>
  6. <parts property="oldno">986006</parts>
  7. <parts property="name">环箍</parts>
  8. <parts property="type">51-70</parts>
  9. <parts property="note"> </parts>
  10. <parts property="no1">Q67570</parts>
  11. <parts property="no2">0</parts>
  12. <parts property="no3"> </parts>
  13. <parts property="unit">个</parts>
  14. </node>
  15. </data>
复制代码

不知道有什么办法,可以不需要转换编码,直接生成xml文件.
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
LiveHappy

论坛徽章:
0
5楼 [报告]
发表于 2006-10-11 00:52 |只看该作者
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
legend9

论坛徽章:
0
6楼 [报告]
发表于 2006-10-11 06:46 |只看该作者
应该声明一下xml文件的编码
<?xml version="1.0" encoding="utf-8" ?>

另外mb_detect_encoding并不是很准确。
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
achun.shx

论坛徽章:
0
7楼 [报告]
发表于 2006-10-11 08:55 |只看该作者
楼主你连接数据库后有没有
set charset utf8;
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
LiveHappy

论坛徽章:
0
8楼 [报告]
发表于 2006-10-11 09:46 |只看该作者
原帖由 achun.shx 于 2006-10-11 08:55 发表
楼主你连接数据库后有没有
set charset utf8;


我用的是ms sql 应该不用set吧
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
LiveHappy

论坛徽章:
0
9楼 [报告]
发表于 2006-10-11 09:49 |只看该作者
原帖由 legend9 于 2006-10-11 06:46 发表
应该声明一下xml文件的编码
<?xml version="1.0" encoding="utf-8" ?>

另外mb_detect_encoding并不是很准确。



加了声明encoding="utf-8"后可以打开,中文可以正确显示,但是有些显示的出来,有些显示不出来.
代码如下

  2. foreach($data as $row)
  3. {
  4. $content1="<node>\n";
  5. $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);

  7.         $content1='<parts property="sn">';
  8.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  9.         $content1=$row['parts_sn'];
  10.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  11.         $content1="</parts>\n";
  12.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  13.         $content1='<parts property="oldno">';
  14.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  15.         $content1=$row['parts_old_No'];
  16.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  17.         $content1="</parts>\n";
  18.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  19.         $content1='<parts property="name">';
  20.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  21.         $content1=$row['parts_name'];
  22.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  23.         $content1="</parts>\n";
  24.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  25.         $content1='<parts property="type">';
  26.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  27.         $content1=$row['parts_type'];       
  28.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  29.         $content1="</parts>\n";
  30.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  31.         $content1='<parts property="note">';
  32.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  33.         $content1=$row['parts_notes_i'];
  34.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  35.         $content1="</parts>\n";
  36.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  37.         $content1='<parts property="no1">';
  38.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  39.         $content1=$row['parts_No_1'];
  40.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  41.         $content1="</parts>\n";
  42.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  43.         $content1='<parts property="no2">';
  44.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  45.         $content1=$row['parts_No_2'];
  46.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  47.         $content1="</parts>\n";
  48.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  49.         $content1='<parts property="no3">';
  50.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  51.         $content1=$row['parts_No_3'];
  52.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  53.         $content1="</parts>\n";
  54.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  55.         $content1='<parts property="unit">';
  56.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  57.         $content1=$row['parts_unit'];
  58.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  59.         $content1="</parts>\n";
  60.         $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  61. $content1="</node>\n";
  62. $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);
  63. }
  64. $content1="</data>";
  65. $content .=iconv(mb_detect_encoding($content1), "UTF-8",$content1);

复制代码

结果如下

  2. <?xml version="1.0" encoding="utf-8" ?>
  3. - <data>
  4. - <node>
  5.   <parts property="sn">458</parts>
  6.   <parts property="oldno">843003</parts>
  7.   <parts property="name" />
  8.   <parts property="type" />
  9.   <parts property="note" />
  10.   <parts property="no1">8401013-**</parts>
  11.   <parts property="no2">1</parts>
  12.   <parts property="no3">3044</parts>
  13.   <parts property="unit">件</parts>
  14.   </node>
  15. - <node>
  16.   <parts property="sn">459</parts>
  17.   <parts property="oldno">843007</parts>
  18.   <parts property="name">发动机罩锁总成</parts>
  19.   <parts property="type" />
  20.   <parts property="note" />
  21.   <parts property="no1">8402100-**</parts>
  22.   <parts property="no2">1</parts>
  23.   <parts property="no3">3044</parts>
  24.   <parts property="unit" />
  25.   </node>
  26. - <node>
  27.   <parts property="sn">461</parts>
  28.   <parts property="oldno">842002</parts>
  29.   <parts property="name" />
  30.   <parts property="type">B=400</parts>
  31.   <parts property="note" />
  32.   <parts property="no1">8403012-**</parts>
  33.   <parts property="no2">1</parts>
  34.   <parts property="no3">3044</parts>
  35.   <parts property="unit">件</parts>
  36.   </node>

复制代码

[ 本帖最后由 LiveHappy 于 2006-10-11 10:13 编辑 ]
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
solr.china

论坛徽章:
0
10楼 [报告]
发表于 2006-10-11 21:27 |只看该作者
过滤敏感字符。。。
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号：11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们：huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP