Formatting multi-d array in CodeIgniter

Question

I am trying to get the following output format from a CI query and subsequent JSON_encode:

{"clients":{"id":"3","name":"Client Number1"},{"id":"2","name":"Client Number2"},{"id":"1","name":"Test Client"},{"id":"4","name":"Test Client2"}}

Combining the small functions in the controller and the model, I am using:

$query = $this->db->query('SELECT id, name FROM clients ORDER BY name ASC');
        foreach ($query->result() as $row)
        {
            $arr['clients'][] = $row;
        }

        $json = json_encode($arr, JSON_FORCE_OBJECT);
        echo $json;

This code outputs (below) which includes the array index values ("1", "2"... etc.) How can I remove these index values from the result? Thanks for any help you may be able to give. This one is not a deal-breaking crisis. I could parse them out on the other side of the transaction... but thought the omniscient SO might know how to do this more elegantly!!

{"clients":{"0":{"id":"3","name":"Client Number1"},"1":{"id":"2","name":"Client Number2"},"2":{"id":"1","name":"Test Client"},"3":{"id":"4","name":"Test Client2"}}}

Community · Accepted Answer · 2023-11-17 19:22:09Z

2

Edit: I was wrong.

Apparently all objects in PHP's json_encode print as associative arrays, and thus it always prints the keys. At least, that's the vibe I got from the page on json_encode in the PHP manual.

Removing JSON_FORCE_OBJECT (and using $query->result_array()) gets rid of the keys, but isn't exactly what you're looking for:

{"clients":[{"id":"3","name":"Client Number1"},{"id":"2","name":"Client Number2"},{"id":"1","name":"Test Client"},{"id":"4","name":"Test Client2"}]}

edited Nov 17, 2023 at 19:22

CommunityBot

11 silver badge

answered Mar 5, 2011 at 0:05

Trevor

1481 silver badge10 bronze badges

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

1 Comment

ctgScott Over a year ago

Ha! Thanks! You must have been typing at the same time as me. :) I'll happily give you the up arrow and check mark!

ctgScott · Accepted Answer · 2011-03-13 20:24:45Z

1

Thanks Trevor... I appreciate the help. You actually pointed me in the right direction. I had forgotten that the 'JSON_FORCE_OBJECT' parameter might be messin' things up. In fact it was... see below:

$query = $this->db->query('SELECT id, name FROM clients ORDER BY name ASC');
        foreach ($query->result() as $row)
        {
            $arr['clients'][] = $row;
        }

        $json = json_encode($arr); // Note JSON_FORCE_OBJECT removed
        echo $json;

This code outputs:

{"clients":[{"id":"3","name":"Client Number1"},{"id":"2","name":"Client Number2"},{"id":"1","name":"Test Client"},{"id":"4","name":"Test Client2"}]}

I think that simply allowed a JSONArray (hence the square brackets) to live inside the JSONObject... I can live with that.

Thanks again Trevor!

edited Mar 13, 2011 at 20:24

answered Mar 5, 2011 at 0:30

ctgScott

2313 gold badges6 silver badges18 bronze badges

Collectives™ on Stack Overflow

Formatting multi-d array in CodeIgniter

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related