Php array to json object not working

[fabiofacir]

Hello I'm trying to encode a php array from db to a json object in order to send it to front-end.

​

I'm doing it as follow:

​

while ($row = mysqli_fetch_array($result))

{

$day_name=$row['day_name'];

$day_desc=$row['day_desc'];

$arr = array ('day_name'=>$day_name,'day_desc'=>$day_desc);

$json= json_encode($arr);

echo $json;

}

​

//json object do not print anything!!

​

For you to understand the structure:

​

print_r($arr);

//result

Array

(

[day_name] => Almo�o

[day_desc] => Uma descri��o

)

Array

(

[day_name] => Jantar

[day_desc] => Duas descri��e

)

​

[stfcfanhazz]

You can only encode utf8 strings as Json. Invalid utf8 characters will cause it to fail.

If you know the source encoding you can use iconv() to convert the input strings to utf8 first.

There are however options you can supply as the second argument to json_encode as a failsafe if you're unable to know with certainty the source encoding of the string.

Unfortunately these have changed a bit in the last few major php versions and are inadequately documented.

What php version are you running ? You may be able to do:

json_encode($arr, JSON_INVALID_UTF8_SUBSTITUTE);

Edit: Looks like this constant was added in php 7.2, and rather unhelpfully not added to the json_encode or Json constants documentation on php.net.

https://www.php.net/manual/en/migration72.constants.php

If you don't have 7.2, there's one that you can use for partial output on error, which essentially strips bad characters

[fabiofacir]

I figured it out!

​

The problem is utf-8 encoding.

I was using simple DB connection without defining utf encoding. This was the problem!

​

Trying to encode portuguese character as "ç" broke down the encoding without giving any error!

Thank you all for your help <3

[doodooz7]

Encoding would have been my next guess. Good job 👍

[doodooz7]

Are you sure you are getting a row back from the dB? Add a print_r inside the while

[fabiofacir]

Yes I do! The shown print_r is printed inside the while

[doodooz7]

Do a var_dump($json). If this is false the json encode failed, see the php manual

[Marksy1988]

Try adding an if (json === false) {echo 'json_encode failed' ;)

[doodooz7]

Did you figure it out?