JSON array accent display

Question

I'm trying to display a json array with contents from my database but when their is accents in the database the json array doesn't want to be displayed, their is my code:

<?php

include 'connect.php';

header('Content-Type: text/plain; charset=UTF-8') ;

$serial = 1;

$statment = mysqli_prepare($conn, "SELECT * FROM lesson WHERE serial = ?");
mysqli_stmt_bind_param($statment, "i", $serial);
mysqli_stmt_execute($statment);

mysqli_stmt_store_result($statment);
mysqli_stmt_bind_result($statment, $serial, $by, $type, $description, $lesson, $nb_q);

$response = array();
$response["success"] = false;

while(mysqli_stmt_fetch($statment)){
    $response["success"] = true;
    $response["serial"] = $serial;
    $response["by"] = $by;
    $response["type"] = $type;
    $response["lesson"] = $lesson;
    $response["description"] = $description;
    $response["nb_q"] = $nb_q;
    for ($i = 1; $i <= $nb_q; $i++) {

        $statment2 = mysqli_prepare($conn, "SELECT * FROM question WHERE 4_l_id = ? AND q_num = ?");
        mysqli_stmt_bind_param($statment2, "ii", $serial, $i);
        mysqli_stmt_execute($statment2);

        mysqli_stmt_store_result($statment2);
        mysqli_stmt_bind_result($statment2, $question, $nb_answer, $type, $correct_1, $for_l_id, $id, $q_num);
        while(mysqli_stmt_fetch($statment2)){
            $response["q".$i] = $question;
        }
    }
}

echo json_encode($response, JSON_UNESCAPED_UNICODE);

?>

Thank you for your answers

Your issue might be duplicated, take a look on this https://stackoverflow.com/questions/6771938/any-way-to-return-php-json-encode-with-encode-utf-8-and-not-unicode — Francisco de Castro, Feb 25 '18 at 19:09
Can you please post output of `SHOW VARIABLES LIKE 'character_set%';` query from your page? It mights as well be related to mysql's connection set to latin1 or sthg similar. — Cemal, Feb 25 '18 at 19:10

score 0 · Answer 1 · answered Feb 25 '18 at 19:56

I found a good code but thank you for your help,

<?php

include 'connect.php';


$serial = 1;

$statment = mysqli_prepare($conn, "SELECT * FROM lesson WHERE serial = ?");
mysqli_stmt_bind_param($statment, "i", $serial);
mysqli_stmt_execute($statment);

mysqli_stmt_store_result($statment);
mysqli_stmt_bind_result($statment, $serial, $by, $type, $description, $lesson, $nb_q);

$response = array();
$response["success"] = false;

function utf8_encode_all(&$value)
{
  if (is_string($value)) return utf8_encode($value);
  if (!is_array($value)) return $value;
  $ret = array();
  foreach($dat as $i=>$d) $ret[$i] = utf8_encode_all($d);
  return $ret;
}

while(mysqli_stmt_fetch($statment)){
    $response["success"] = true;
    $response["serial"] = $serial;
    $response["by"] = utf8_encode_all($by);
    $response["type"] = utf8_encode_all($type);
    $response["lesson"] = utf8_encode_all($lesson);
    $response["description"] = utf8_encode_all($description);
    $response["nb_q"] = $nb_q;
    for ($i = 1; $i <= $nb_q; $i++) {

        $statment2 = mysqli_prepare($conn, "SELECT * FROM question WHERE 4_l_id = ? AND q_num = ?");
        mysqli_stmt_bind_param($statment2, "ii", $serial, $i);
        mysqli_stmt_execute($statment2);

        mysqli_stmt_store_result($statment2);
        mysqli_stmt_bind_result($statment2, $question, $nb_answer, $type, $correct_1, $for_l_id, $id, $q_num);
        while(mysqli_stmt_fetch($statment2)){
            $response["q".$i] = utf8_encode_all($question);
        }
    }
}

$array = array_map('htmlentities',$response);

$json = html_entity_decode(json_encode($array));

echo $json;

?>

JSON array accent display

1 Answers1