Return Json with special characters [duplicate]

Question

Return Json with special characters [duplicate]

Navigation

#1 by (0 votes)

1

I am doing a query in the database (Php, Mysql and Ajax), the return of this query is a Json, however all the accents are coming with special characters, I put a log to see the result. Below is the code that fills my array.

$sql = mysqli_query($conn,$query_somente_alunos_presentes);
$linhas=mysqli_num_rows($sql); 

if( $linhas > 0 ) {
    while($resultado = mysqli_fetch_assoc($sql)){
        $vetor[]= array_map('utf8_encode', $resultado); 
}    
    //Passando vetor em forma de json
    echo   json_encode($vetor);
}

See log out on page:

Array (2)

0
:
{id: "1", nome: "TimÃ³teo da Silva", imagem: "TimÃ_1520692755.jpg"}
1
:
{id: "10", nome: "JoÃ£o Barretos", imagem: "JoÃ£o_1520689587.jpg"}
2
:
{id: "11", nome: "JoÃ£o Pedro", imagem: "JoÃ£o_1520689891.jpg"}

I've tried using mysql's set caracters, utf8 anyway ....

php mysql ajax json

asked by anonymous 26.03.2018 / 22:11

1 answer

Error creating new project Laravel How to effectively and efficiently integrate Travis-ci with Docker Hub?

score 0 · Answer 1

I changed only one line of code:

if( $linhas > 0 ) {
    while($resultado = mysqli_fetch_assoc($sql)){
      //  $vetor[]= array_map('utf8_encode', $resultado); 
        $vetor[] =$resultado;  // <- apenas isso..
}    
    //Passando vetor em forma de json

    echo   json_encode($vetor);
}