doudou8081 2016-11-25 07:16
浏览 103
已采纳

俄语字符的json_encode错误

I am having trouble with the output of json_encode. I need to output Russian characters.

In my database table only Russian characters. In the output I am getting only "????????" question marks replaced Russian characters. I read many similar questions but none of them offered a real solution. I tried the following but none of them helped.

Below is my php code.

  1. added ``header ('Content-type: application/json; charset=utf-8');`
  2. used json_encode($albums, JSON_UNESCAPED_UNICODE);
  3. tried mb_convert_encoding($str, 'UTF-8', 'auto'); json_encode($albums, JSON_UNESCAPED_UNICODE);
<?php
    $host ="localhost";
    $user ="misollar_user";
    $pass="12345";
    $db="misollar_db";
    header ('Content-type: application/json; charset=utf-8');
    $con = mysqli_connect($host,$user,$pass,$db);
    $query = "select * from albums;";
    $result = mysqli_query($con, $query);
    $albums = array();
    while ($row = mysqli_fetch_array($result)){
        array_push($albums,array('id'=>$row[0], 'name'=>$row[1], 'songs_count'=>$row[2]));
    }
    mysqli_close($con);
    echo json_encode($albums, JSON_UNESCAPED_UNICODE);
?>
  • 写回答

1条回答 默认 最新

  • douzoudang1511 2016-11-25 07:40
    关注

    You need to set UTF8 before retrieving results from mysql.

    Just before you retrieve results from albums table, fire below query:

    mysqli_query($con, 'SET names UTF8');
    

    After this you can fetch your album results:

    $query = "select * from albums;";
    $result = mysqli_query($con, $query);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

    报告相同问题?

    悬赏问题

    • ¥15 电脑锁屏时vba运行SAP,excel数据不能复制到SAP
    • ¥50 74LS系列 74LS00 74LS04设计一个RS485电路(关键词-差分)
    • ¥30 各位help写一下代码
    • ¥15 在运行SDEdit模型下载不了
    • ¥15 求51控制l298n驱动的小车中超声波避障怎么写
    • ¥15 电脑连上WIFI却用不了
    • ¥30 MATLAB在RLC电路的固有响应和阶跃响应GUI仿真报告
    • ¥15 hyper-v出现的问题
    • ¥15 有能用的可加酬金,求可以批量下载懒人听书的软件,能登录自己帐号的。
    • ¥100 高博一起做RGB-D SLAM(5)VO无法出visualisation问题