JSON Encoding of an array

Question

I am trying to fetch results from the database into an array and then encoding that array into a json string but it does not echo any results. Can anybody figure out why?

$result=mysql_query($sql,$conn);

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    $unique_array[] = array('id'=>$row['id'], 'name'=>$row['name'],'province'=>$row['province']);
}

echo(json_encode($unique_array));

Add var_dump($unique_array); right before the echo(json_ , just in order to make sure that the while loop is running and populating that variable. — Ofir Baruch
– Ofir Baruch, Commented May 11, 2015 at 7:29
also stop using deprecated Mysql functionalities and switch to Mysqli or better PDO — user2399035
– user2399035, Commented May 11, 2015 at 7:32

Krycke · Accepted Answer · 2015-05-11 07:41:09Z

2

If the encoding fails, the function will return FALSE, and nothing will be echoed.

You can check errors with: json_last_error() and find the meaning here: http://php.net/manual/en/function.json-last-error.php

or for humans with this: json_last_error_msg();

$encoded_array = json_encode($unique_array);
if( json_last_error() ) {
    echo(json_last_error_msg());
    var_dump($unique_array);
}
else {
    echo($encoded_array);
}

edited May 11, 2015 at 7:41

answered May 11, 2015 at 7:34

Krycke

3,2061 gold badge19 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3480127 Over a year ago

Thanks alot! the error was "Malformed UTF-8 characters, possibly incorrectly encoded". Adding this line after setting the connection with database solved it: mysql_set_charset("utf8");

Krycke Over a year ago

Glad to here it. It's usually not what you think is the problem at actually is the problem.

Collectives™ on Stack Overflow

JSON Encoding of an array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related