Customizing JSON output CakePHP

Question

    $user = $this->User->find( 'all' );
    $this->set( 'users', $user );

I have this code in my controller.

In my view I have this.

echo json_encode( compact( 'users' ) );

It outputs json like this

    {
    "users": [{
        "User": {
            "user_id": "2",
            "email": "[email protected]",
            "name": "Blah"
        }]
    }
}

Is there anyway to format this to remove the entire array wrapped in "users", and also remove every object being a member of "User".

This makes it harder to use on the front end. I'd like it to look like this.

[{
    "user_id": "2",
    "email": "[email protected]",
    "name": "Blah"
}]

Thanks for any help.

ndm · Accepted Answer · 2012-10-21 20:18:28Z

I don't fully understand what you mean by "remove the entire array wrapped in "users"" and "remove every object being a member of "User"", but according to your desired output format example, you'll need to extract and pass the exact data that you want to be encoded to json_encode, instead of passing everything using compact.

Extracting could be done with the Set or the Hash class (depending on your Cake version)

Assuming your model returns the data in the default CakePHP format, this for example:

json_encode(Set::extract('/User/.', $users));

should give you a structure like this:

[{
    "user_id": "2",
    "email": "[email protected]",
    "name": "Blah"
}]

and with multiple users it should look like this

[{
    "user_id": "1",
    "email": "[email protected]",
    "name": "Bar"
},
{
    "user_id": "2",
    "email": "[email protected]",
    "name": "Blah"
}]

Aditya P Bhatt · Accepted Answer · 2014-05-20 08:41:29Z

0

Use like this:

$users= (Set::extract('/User/.', $users));
pr($users);

It will remove Model from result Array and then json_encode or whatever further usage.

More library functions Set class Here and Hash class Here

answered May 20, 2014 at 8:41

Aditya P Bhatt

22.2k20 gold badges88 silver badges104 bronze badges

Collectives™ on Stack Overflow

Customizing JSON output CakePHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related