PHP Json Encode PDO::FETCH_ASSOC

Question

I'm attempting to return all the rows of my MSSQL database table and spit them out in a JSON_ENCODE.

When I use this and echo the $json I get a blank page. When I do a var_dump on that var I get a bool, false.

$sth = $db->prepare("SELECT * FROM dbo.Devices");
$sth->execute();

$array = $sth->fetchAll( PDO::FETCH_ASSOC );
$json = json_encode($array);

However, if I was to place the same fetchAll into a result var and print it, it works fine!

Working using print function.
$result = $sth->FetchAll();
print_r($result);

I've read of others having similar issues and that it was a UTF8 encoding issue so I attempted to do a utf8_encode on the $array before a json_encode but with the same result of a blank page. Can anyone explain this?

You don't use `PDO::FETCH_ASSOC` in the second example. Does removing that option allow you to `json_encode()` the result? — WillardSolutions, May 05 '16 at 15:03
Wait, are you getting a blank page because you're not printing out the json_encoded results? `print_r` prints to screen, `json_encode` does not. — WillardSolutions, May 05 '16 at 15:09
Why do you think it's an encoding issue? What does your data look like? — miken32, May 05 '16 at 21:36

score 2 · Accepted Answer · edited May 23 '17 at 12:22

2

json_encode is character encoding sensitive. It will fail if it can't handle the encoding. print_r is not. It will happily print out whatever you give it.

The utf8_encode fix will only work if the strings in your source data are encoded as ISO-8859-1. Assuming that's true it should work. Make sure you do it like this... https://stackoverflow.com/a/2790107/111755

edited May 23 '17 at 12:22

Community

1
1

answered May 05 '16 at 15:13

dellsala

932
1
9
16

PHP Json Encode PDO::FETCH_ASSOC

1 Answers1

Linked

Related