PHP读取mssql,json数据中文乱码，-php手册-php.cn

PHP读取mssql,json数据中文乱码，

WBOY

Release： 2016-06-13 08:42:20

Original

1087 people have browsed it

PHP读取mssql,json数据中文乱码，

PHP及网页使用UTF-8编码，数据库是sql server2008,使用默认编码（936，即GBK编码）

当读取数据库数据时，使用php自带的json_encode()返回到前端，结果中文不显示。

解决办法：

<?<span>php    
    </span><span>header</span>("Content-Type: text/html;charset=utf-8"<span>);
    </span><span>//</span><span>告诉浏览器不要缓存数据</span>
    <span>header</span>("Cache-Control: no-cache"<span>);    
    
    </span><span>require</span> "../conn.php"<span>;
    </span><span>require</span> "../share/json_gbk2utf8.php"<span>;

    </span><span>$query</span> = '<span>SELECT 
                seq,
                employeeID,
                employeeName,
                department,
                position,
                sex,
                birthday,
                entryTime,
                description,
                convert(varchar(20),createTime,120) as createTime,<span>;    
    </span><span>$arr</span> = <span>Array</span><span>();
    </span><span>$query</span> = <span>iconv</span>("utf-8", "gbk//ignore", <span>$query</span>);<span>//</span><span>为了解决中文乱码问题    </span>
    <span>if</span>(<span>$result</span> = sqlsrv_query(<span>$conn</span>, <span>$query</span><span>)){
        </span><span>while</span>(<span>$row</span> = sqlsrv_fetch_array(<span>$result</span><span>)){
            </span><span>$arr</span>[] = <span>$row</span><span>;            
        }
    }
    </span><span>$data</span> = JSON(<span>$arr</span><span>);
</span><span>//</span><span>     file_put_contents("E:/mylog.log", "JSON:".$data."\r\n", FILE_APPEND);    </span>
    <span>echo</span> <span>$data</span><span>;
</span>?>

Copy after login

<?<span>php
</span><span>//</span><span>json_gbk2utf8.php</span><span>
/*</span><span>*************************************************************
 *为了实现对含有中文字符的数组进行json编码
 *
*  使用特定function对数组中所有元素做处理
*  @param  string  &$array     要处理的字符串
*  @param  string  $function   要执行的函数
*  @return boolean $apply_to_keys_also     是否也应用到key上
*  @access public
*
************************************************************</span><span>*/</span>
<span>function</span> arrayRecursive(&<span>$array</span>, <span>$function</span>, <span>$apply_to_keys_also</span> = <span>false</span><span>)
{
    </span><span>static</span> <span>$recursive_counter</span> = 0<span>;
    </span><span>if</span> (++<span>$recursive_counter</span> > 1000<span>) {
        </span><span>die</span>('possible deep recursion attack'<span>);
    }
    </span><span>foreach</span> (<span>$array</span> <span>as</span> <span>$key</span> => <span>$value</span><span>) {
        </span><span>if</span> (<span>is_array</span>(<span>$value</span><span>)) {
            arrayRecursive(</span><span>$array</span>[<span>$key</span>], <span>$function</span>, <span>$apply_to_keys_also</span><span>);
        } </span><span>else</span><span> {
</span><span>//</span><span>             file_put_contents("E:/mylog.log", "原始:".$value."\r\n", FILE_APPEND);</span>
            <span>$value</span> = <span>iconv</span>("gbk//ignore", "utf-8", <span>$value</span><span>);
</span><span>//</span><span>             file_put_contents("E:/mylog.log", "utf-8:".$value."\r\n", FILE_APPEND);</span>
            <span>$array</span>[<span>$key</span>] = <span>$function</span>(<span>$value</span><span>);
</span><span>//</span><span>             file_put_contents("E:/mylog.log", "urlencode:".$array[$key]."\r\n", FILE_APPEND);</span>
<span>        }

        </span><span>if</span> (<span>$apply_to_keys_also</span> && <span>is_string</span>(<span>$key</span><span>)) {
            </span><span>$new_key</span> = <span>$function</span>(<span>$key</span><span>);
            </span><span>if</span> (<span>$new_key</span> != <span>$key</span><span>) {
                </span><span>$array</span>[<span>$new_key</span>] = <span>$array</span>[<span>$key</span><span>];
                </span><span>unset</span>(<span>$array</span>[<span>$key</span><span>]);
            }
        }
    }
    </span><span>$recursive_counter</span>--<span>;
}

</span><span>/*</span><span>*************************************************************
 *
*  将数组转换为JSON字符串（兼容中文）
*  @param  array   $array      要转换的数组
*  @return string      转换得到的json字符串
*  @access public
*
************************************************************</span><span>*/</span>
<span>function</span> JSON(<span>$array</span><span>) {
    arrayRecursive(</span><span>$array</span>, 'urlencode', <span>true</span><span>);
    </span><span>$json</span> = json_encode(<span>$array</span><span>);
    </span><span>return</span> <span>urldecode</span>(<span>$json</span><span>);
}
</span><span>/*</span><span>
$array = array
(
        'Name'=>'希亚',
        'Age'=>20
);


echo JSON($array);
</span><span>*/</span>
?>

Copy after login

这样，sql server 2008中的中文就可以在网页正常显示了。

如果要将中文正常插入到sql server 2008中，还要加入一条代码：$query = iconv("utf-8", "gbk//ignore", $query);//为了解决中文乱码问题

完整代码如下：

<?<span>php 
    </span><span>/*</span><span>*
     * 如果员工编号在MySql中不存在则在MySql中插入员工记录
     * 如果该员工编号已经存在则进行更新操作
     </span><span>*/</span>
    <span>//</span><span>如果用JSON格式则要使用text/html，不能使用text/xml</span>
    <span>header</span>("Content-Type: text/html;charset=utf-8"<span>);
</span><span>//</span><span>     header("Content-Type: text/html;charset=GBK");
    //告诉浏览器不要缓存数据</span>
    <span>header</span>("Cache-Control: no-cache"<span>);
    
    </span><span>require</span> '../conn.php'<span>;
    </span><span>$seq</span> = <span>$_POST</span>["seq"<span>];
    </span><span>$employeeID</span> = <span>$_POST</span>["employeeID"<span>];
    </span><span>$employeeName</span> = <span>$_POST</span>["employeeName"<span>];
    </span><span>$department</span> = <span>$_POST</span>["department"<span>];

    </span><span>if</span>(!<span>isset</span>(<span>$seq</span>) || <span>$seq</span> == ""){<span>//</span><span>seq不存在则插入新记录</span>
        <span>$query</span> = "<span>INSERT INTO employees (employeeID, employeeName, department, 
                    createTime, updateTime)
                VALUES (N'</span><span>$employeeID</span>',N'<span>$employeeName</span>',N'<span>$department</span><span>', 
                    getdate(), getdate())</span>"<span>;
    }</span><span>else</span>{<span>//</span><span>如果seq已存在则更新已有记录</span>
        <span>$query</span> = "UPDATE employees SET employeeID='<span>$employeeID</span><span>', 
                employeeName='</span><span>$employeeName</span>',department='<span>$department</span><span>',
                updateTime=getdate()  
            WHERE seq='</span><span>$seq</span>'"<span>;
    }
    
</span><span>//</span><span>     file_put_contents("E:/mylog.log", $query."\r\n",FILE_APPEND);//用于调试</span>
    <span>$query</span> = <span>iconv</span>("utf-8", "gbk//ignore", <span>$query</span>);<span>//</span><span>为了解决中文乱码问题</span></span>
    <span>if</span>(<span>$result</span> = sqlsrv_query(<span>$conn</span>, <span>$query</span><span>)){
        </span><span>echo</span> <span>true</span><span>;
    }</span><span>else</span><span>{
        </span><span>echo</span> <span>false</span><span>;
    }
</span><span>//</span><span>     echo $query;</span>
?>

Copy after login