


This article mainly introduces the solution to garbled characters in thinkphp3 query mssql database. Friends who need it can refer to it
The reason why thinkphp queries mssql database with garbled characters is that ThinkPHP defaults to UTF-8, and the msmsql database is simplified The Chinese version stores GB2312 encoding
Solution:
1: Open Db.class.php in ThinkPHP\Lib\Core and add
2 at the end: Db.class.php finds function select(), add $result=iconv2utf8($result) after $result = $this->query($sql);, and it’s OK.
The code is as follows:
public function iconv2utf8($Result) { $Row=array(); $key1=array_keys($Result); //取查询结果$Result的数组的键值 //print_r($key1); $key2=array_keys($Result[$key1[0]]); //取查询结果$Result的第一个数组($key1[0])的键值 //print_r($key2); for($i=0;$i<count($key1);$i++) { for($j=0;$j<count($key2);$j++) { //取查询结果编码改为UTF-8,并存入$Row,且$Row与$Result键与值一致 $Row[$key1[$i]][$key2[$j]]=iconv('gb2312','utf-8',$Result[$key1[$i]][$key2[$j]]); } } retrun $Row; }
The above is the entire content of this article. I hope it will be helpful to everyone's study. For more related content, please pay attention to the PHP Chinese website!
Related recommendations:
About thinkPHP’s method of implementing batch deletion
About thinkPHP3.2’s implementation of paging custom styles Method
About thinkPHP’s built-in string interception function method
##
The above is the detailed content of How to solve the problem of garbled characters in thinkphp3 query mssql database. For more information, please follow other related articles on the PHP Chinese website!

php导入csv乱码问题的解决办法:1、构造一个解析函数“function tb_str_getcsv($string, $delimiter=',', $enclosure='"') {...}”;2、读取文件到变量;3、通过“substr($s,2)”去掉BOM头即可。

cmd php乱码的解决办法:1、在windows平台的cmd或shellpower中,执行php脚本并检查是否乱码;2、通过在php脚本里执行“exec("CHCP 65001");”命令去修改当前页码字符集即可。

php+fread()乱码是因为输出页面的编码和被读文件的编码不一致,其解决办法:1、打开相应的PHP文件;2、通过fread函数读取文件;3、通过“iconv('gbk', 'utf-8', $data)”方法将读取的内容转码即可。

php写入数据库中文乱码的解决办法:1、创建数据库并设置“utf8_general_ci”编码;2、用PHP读写数据库,然后设置“mysql_query("set names 'utf8'");”即可。

linux命令行显示乱码的解决办法:1、通过“echo $LANG”命令查看当前支持的语言;2、使用“LANG=en_US”命令修改语言为英语语系即可解决乱码问题。

wordpress后台乱码的解决办法:1、在wordpress的“wp-admin”文件夹下找到“admin.header.php”文件;2、将“charset”属性值设置为“UTF-8”格式即可恢复正常。

mysql注释乱码问题的解决办法:1、通过“show variables like '%colla%';show variables like '%char%';”命令查看数据库与服务端的字符集设置;2、通过“set character_set_client=utf8;”设置结果集为utf8即可。

php dompdf中文乱码的解决办法:1、打开前端文件;2、通过设置“@font-face {font-family:ttt;src: url(/static/font/simkai.ttf)}”引用中文字体;3、删除“dompdf_font_family_cache.php”即可。


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Dreamweaver Mac version
Visual web development tools

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

Zend Studio 13.0.1
Powerful PHP integrated development environment

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.

SublimeText3 English version
Recommended: Win version, supports code prompts!
