Heim >Backend-Entwicklung >PHP-Tutorial >PHP读取mssql,json数据中文乱码,_PHP教程
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>?>
<?<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> ?>
这样,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> ?>