Home  >  Article  >  php教程  >  笔记:PHP查询mysql数据后中文字符乱码

笔记:PHP查询mysql数据后中文字符乱码

WBOY
WBOYOriginal
2016-06-06 19:48:50939browse

新建表Clubs CREATE TABLE `Clubs` ( `id` int ( 11 ) NOT NULL AUTO_INCREMENT, `name` varchar ( 30 ) CHARACTER SET utf8 NOT NULL DEFAULT '' , PRIMARY KEY (`id`)) ENGINE = MyISAM AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8 COLLATE = utf8_unicode

 

新建表Clubs

<span>CREATE</span> <span>TABLE</span><span> `Clubs` (
  `id` </span><span>int</span>(<span>11</span>) <span>NOT</span> <span>NULL</span><span> AUTO_INCREMENT,
  `name` </span><span>varchar</span>(<span>30</span>) <span>CHARACTER</span> <span>SET</span> utf8 <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>,  
  </span><span>PRIMARY</span> <span>KEY</span><span> (`id`)
) ENGINE</span><span>=</span>MyISAM AUTO_INCREMENT<span>=</span><span>1</span> <span>DEFAULT</span> CHARSET<span>=</span>utf8 COLLATE<span>=</span>utf8_unicode_ci;

 

id  name

1   程序员
2   架构师
3   产品经理
4   测试

如果在phpMyAdmin中查看name字段内容就是?,修改MySQL 字符集选择UTF8,MySQL 连接校对选择utf8_general_ci

 

在mysql中查看字段内容为正确的中文字符后,通过mysql_query('select * from clubs')查询

用var_dump打印查询结果如下,所有的中文汉字都变成了?

<span>array</span> (size=4<span>)
  </span>0 => 
    <span>array</span> (size=2<span>)
      </span>'id' => <span>string</span> '1' (length=1<span>)
      </span>'name' => <span>string</span> '???' (length=3<span>)
  </span>1 => 
    <span>array</span> (size=2<span>)
      </span>'id' => <span>string</span> '2' (length=1<span>)
      </span>'name' => <span>string</span> '???' (length=3<span>)
  </span>2 => 
    <span>array</span> (size=2<span>)
      </span>'id' => <span>string</span> '3' (length=1<span>)
      </span>'name' => <span>string</span> '????' (length=4<span>)
  </span>3 => 
    <span>array</span> (size=2<span>)
      </span>'id' => <span>string</span> '4' (length=1<span>)
      </span>'name' => <span>string</span> '??' (length=2)

解决办法:在执行mysql_query之前先执行

<span>mysql_query</span>("set names utf8");

 

如果还不行,请确认php文件编码格式是否是utf8格式,同时在php文件头增加

<span>header</span>("Content-Type:text/html;charset=utf-8");

 

解决问题的根本办法就是把相关的编码格式都统一为utf8。

 

查询结果中文字符没问题了,但是$clubs转化为json时,name字段中文字符却又变了

<span>$clubs</span>=json_encode(<span>$clubs</span><span>);
</span><span>echo</span>(<span>$clubs</span>);

输出内容如下

[{"id":"1","name":"\u7a0b\u5e8f\u5458"},{"id":"2","name":"\u67b6\u6784\u5e08"},{"id":"3","name":"\u4ea7\u54c1\u7ecf\u7406"},{"id":"4","name":"\u6d4b\u8bd5"}]

解决方案:

<span>foreach</span> ( <span>$clubs</span> <span>as</span> <span>$key</span> => <span>$value</span><span> ) {             
                 
    </span><span>foreach</span>(<span>$value</span> <span>as</span> <span>$k</span>=><span>$v</span><span>){
                     
        </span><span>$clubs</span>[<span>$key</span>][<span>$k</span>] = <span>urlencode</span>(<span>$v</span><span>);
    }              
                 
}             

</span><span>$clubs</span>=json_encode(<span>$clubs</span><span>);
</span><span>echo</span>(<span>urldecode</span>(<span>$clubs</span>));

原因:

json_encode只支持UTF8编码的字符,使用JSON作为提交和接收的数据格式时,字符都采用UTF8编码处理,当我们的页面编码和数据库编码不是采用UTF8的时候,就极容易出现中文乱码的问题。解决办法是在用js或者PHP处理JSON数据的时候都采用UTF8的形式。

 

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn