Mysql / PHP / json_encode boolean string conversion

Question

I have a mysql query lets say:

SELECT cca_id AS id, cca_title AS text,IF((SELECT count(*) from crm_categories WHERE cca_id_prev = id),'TRUE','FALSE') AS children FROM crm_categories WHERE...

now I get an array back with true / false as a string

If I use json_encode the result is like {"id":"false"}

But I need true/false without quotes - the problem is if i use true false in the mysql query as a boolean it returns 0/1 - but I don't want that either...

Of course I can run a str_replace to the json string - but i think there are alternatives isn't it?

how are you going to end up using the boolean? in JavaScript? — adamS
– adamS, Commented Apr 18, 2014 at 11:43
i use jstree and jstree demands a notation like {"children":false} — Atural
– Atural, Commented Apr 18, 2014 at 11:45
If you use php you can do like: $result[]['children'] = $data['children']? true: false; What do you think? — Alexey Palamar
– Alexey Palamar, Commented Apr 18, 2014 at 11:45
yes i think i can do that - but i've to iterate through the array - in this case i can use str_replace too which seems not the best solution here - i don't want to iterate through the given array just because of that — Atural
– Atural, Commented Apr 18, 2014 at 11:48

deceze · Accepted Answer · 2014-04-18 11:44:05Z

19

Well, you are selecting from the database as string. So that's what gets encoded. Use SQL true/false boolean values, which in PHP become 0/1, and cast them to PHP booleans before JSON encoding them:

$data['id'] = (bool)$data['id']; // 0/1 -> PHP false/true

echo json_encode($data); // {'id':true}

answered Apr 18, 2014 at 11:44

deceze♦

525k89 gold badges806 silver badges954 bronze badges

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

1 Comment

Atural Over a year ago

yeah in this case i've to iterate through the array too - but i guess you r right - this seems the best solution for now

Vishwa Ratna · Accepted Answer · 2019-01-11 05:07:41Z

0

I had the same problem :

I used PHP for convert value gettype, example with POST :

foreach ($_POST as $k => $v) {
        settype($_POST[$k], gettype($v));
}}
echo json_encode($_POST);

http://php.net/manual/en/function.settype.php

edited Jan 11, 2019 at 5:07

Vishwa Ratna

6,5205 gold badges41 silver badges64 bronze badges

answered Jan 11, 2019 at 4:26

Intranets

11 silver badge1 bronze badge

Comments

Lucas Green · Accepted Answer · 2014-04-18 11:45:12Z

-1

The problem here is that the data returned from mysql is a string, not a boolean. If you know that it is always going to be either 'true' or 'false', you can compare it with a string literal to get the correct type:

$row = $stmt->fetch(PDO::FETCH_ASSOC);
$boolval = ($row['boolval'] === 'true');

And then later, when it is json_encoded() it will be represented as a primitive boolean, instead of a string.

answered Apr 18, 2014 at 11:45

Lucas Green

3,95924 silver badges27 bronze badges

Collectives™ on Stack Overflow

Mysql / PHP / json_encode boolean string conversion

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related