php json_encode is returning 0 , zero value sometimes

Question

something is going wrong , im saving json_encode response in mysql db. it sometimes saving 0 value.im 100% sure that my json_encode function does not receive 0 as a parameter because it always get empty array or associated array, so there is no any chance to receive 0 in parameter.

Problem is that why json_encode returns 0 value sometimes. i have column type longtext in db table where im saving its response. is it issue with character types? like UTF8 or non UTF8?

Here is a code snippet:

$jsonPayload = [];

if (isset($obj['answer']) && (!empty($obj['answer']) || $obj['answer'] == 0)) {
       $jsonPayload[$form_fields[$i]->id] = $obj;         
}

return json_encode($jsonPayload);

You are using a relational database completely wrong. You don't put an array, or anything encoded into a database. You put each value into their table column. That's what it means to use a relational database. — Charlotte Dunois, Apr 24 '18 at 10:11
`json_encode` doesn't return `0`, but it can return `false`. My bet is you have some non-UTF8 characters in your encode — Machavity, Apr 24 '18 at 13:15
according to my investigation its return 0 due to non-UTF8 character. but dont have such character on which i can test either json_encode return 0 on passing non-UTF8 characters or not. I wants to reproduce it. — Muhammad Ateek, Apr 25 '18 at 05:44

score 0 · Answer 1 · answered Apr 24 '18 at 10:19

0

use

json_encode($jsonPayload,JSON_UNESCAPED_SLASHES);

Probably it will work.

answered Apr 24 '18 at 10:19

Sambhaji Katrajkar

409
2
10

brother its returning 0, do you think that its character type issue? like UTF8 or non UTF8 characters. – Muhammad Ateek Apr 24 '18 at 11:28
can you please show print_r($jsonPayload); result? – Sambhaji Katrajkar Apr 24 '18 at 11:31
no brother, its on live server, i dont know whats comming in payload, but special character can be present in payload, i need such character which return 0 for json_encode – Muhammad Ateek Apr 24 '18 at 11:37
You can follow https://stackoverflow.com/questions/4663255/php-mysql-insert-into-utf-8 – Sambhaji Katrajkar Apr 24 '18 at 11:39
no its not a issue – Muhammad Ateek Apr 24 '18 at 12:05

php json_encode is returning 0 , zero value sometimes

1 Answers1

Linked