How to convert a PHP array to a JSON array

Question

I am trying to convert my PHP array that i get as a query result to a JSON array. But look like it does not work. Any help would be appriciated.

        $stmt = $db->prepare("SELECT * FROM companies WHERE companyID = ?");

        if($stmt == "false"){
            die('Query error !'.$db->error);  
        }
        $stmt->bind_param('i', $companyID);
        $stmt->execute();
        $result = $stmt -> get_result();
        $companies = $result ->fetch_all(MYSQLI_BOTH);

        echo json_encode(array('companies' => $companies));

How does it not work? What is the result of your current code? What do you expect it to look like? — John Conde
– John Conde, Commented Sep 30, 2014 at 19:30
But look like it does not work. please be even less specific if possible — njzk2
– njzk2, Commented Sep 30, 2014 at 19:32
Does $result ->fetch_all actually give you an array or just something array-like? — Quentin
– Quentin, Commented Sep 30, 2014 at 19:33
What is the result of echo json_encode(array('companies' => $companies));? — Jay Blanchard
– Jay Blanchard, Commented Sep 30, 2014 at 19:33

Community · Accepted Answer · 2017-05-23 11:49:37Z

4

It looks like what you're experiencing is JSON itself. There is an existing, excellent answer here that will explain that. The summary is that an array with string keys in PHP is an object in JSON, since arrays can only have numeric indexes.

I hope this answers your question directly enough, and I think it will change how you think of the relationship between PHP and JSON.

edited May 23, 2017 at 11:49

CommunityBot

11 silver badge

answered Sep 30, 2014 at 19:37

Shon M

1744 bronze badges

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

Collectives™ on Stack Overflow

How to convert a PHP array to a JSON array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related