CakePHP json output

Question

I am trying to output the content i get from my Controller in my view as json, but i think i is outputting weird.

On the web i search json and it comes up with output looking like this:

{"menu": {
  "id": "file",
  "value": "File",
  "popup": {
    "menuitem": [
      {"value": "New", "onclick": "CreateNewDoc()"},
      {"value": "Open", "onclick": "OpenDoc()"},
      {"value": "Close", "onclick": "CloseDoc()"}
    ]
  }
}}

However mine is just not formatted and looks like this.

[{"Customer":{"id":"1","first_name":"Ian","last_name":"Smith","address_1":"10 High Streets","address_2":"","town_city":"Plymouth","county":"Devon","postcode":"PL1 2JD"}},{"Customer":{"id":"2","first_name":"David","last_name":"Smith","address_1":"52 Low Avenue","address_2":"","town_city":"Exeter","county":"Devon","postcode":"EX2 1KO"}}]

How can i output it so it looks like the first one?

EDIT

Controller

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

View

<?php echo json_encode($user); ?>

Why do you care what it looks like? It's the correct data in the correct format - visual appearance of code shouldn't matter in this case, and you want it as condensed as possible. — Dave
– Dave, Commented Mar 8, 2013 at 16:55
Those coming from Google: this helps stackoverflow.com/questions/64659636/… — ᴍᴇʜᴏᴠ
– ᴍᴇʜᴏᴠ, Commented Mar 1, 2023 at 15:21

Karisters · Accepted Answer · 2013-03-08 17:24:30Z

3

There is no sense to beautify your json on output step. If it matters, you may use external tools to make a pretty look of json.

Also, consider using (JSON View) in Cake. In short, you set a special view variable with content you want to jsonify:

for local effect, write in your action Router::parseExtensions()
specify variable which contains your data to be output $this->set('_serialize', array('response')); (in json, there will be a root object called "response" with content of $response variable).

With such approach, you won't need to create view files - json will be output automatically if request has "Accept: application/json" header.

answered Mar 8, 2013 at 17:24

Karisters

1865 bronze badges

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

4 Comments

Costa Over a year ago

More details on this approach: stackoverflow.com/questions/10099449/…

Carlos Morales Over a year ago

@Costa links seems broken

Costa Over a year ago

@CarlosBarcelona for some reason the whole question was removed (even though the answer had 15+ upvotes) -- Stackoverflow is very anal about deleted questions so it's pretty much gone forever.

Denis Valdenaire aka Joe Linux Over a year ago

For those who land here, Router::parseExtensions() has been removed in 3.5 version; you got to put $routes->setExtensions(['json', 'xml', 'html']); in routes.php BEFORE the routes are connected.

Kishor Kundan · Accepted Answer · 2013-03-08 16:59:24Z

0

Only difference in those json responses are that the first one is JSON object with sub objects and second one is an array of JSON objects with their sub objects.

The code below retrieves all records for customers. And when you encode it into json object, it is encoded as array of Cutomers

$this->Customer->find( 'all' );

You can achieve response like the first one by

$this->Customer->find( 'first' );

The above code will only yield one Customer object.

answered Mar 8, 2013 at 16:59

Kishor Kundan

3,1651 gold badge25 silver badges30 bronze badges

Collectives™ on Stack Overflow

CakePHP json output

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related