Charset Utf8无法使用json编码

Question

I have a php file to return json but the result given not correctly.

Ex: Lập Trình Ứng Dụng in database => L?p Trình ?ng D?ng in view

Here it's php file

  <?php 
    $mysql = new mysqli('localhost','root','','freelancer');
    $result = $mysql->query("select * from tag");
    $rows = array();
    while($row = $result->fetch_array(MYSQL_ASSOC)) {
        $rows[] = array_map("utf8_encode", $row);
    }
    echo json_encode($rows);
    ?>

Hope everyone can help me with this.Thanks for read

Answer 1

utf8_encode() only works for strings that are iso-8895-1 encoded. As your string contains non-latin characters, your data can't be encoded in iso-8895-1, so utf8_encode() certainly won't work.

Instead, you need to ask MySQL to return its data encoded in UTF-8 already by adding set_charset("utf8") to your connection configuration. Now you have UTF-8 encoded strings, you no longer need to re-encode it.

Your new code should look like:

<?php 
    $mysql = new mysqli('localhost','root','','freelancer');
    $mysql->set_charset("utf8")

    $result = $mysql->query("select * from tag");
    $rows = array();
    while($row = $result->fetch_array(MYSQL_ASSOC)) {
        $rows[] = $row;
    }
    echo json_encode($rows);
?>