Format JsonArray php

Question

i would like to format it this way but i am unable to at the moment it looks like this:

    {"success":true,"user":"tom","gender":"male","age":"2"}
{"success":true,"user":"anna","gender":"female","age":"3"}

but it should look like this

  {
      "result":[ 
                 {"success":true,"user":"tom","gender":"male"},
                 {"success":true,"user":"anna","gender":"female"}
               ]
    }

this is my code

if ($result->num_rows > 0)
  {
    while($row = $result->fetch_assoc())
     {
       $user= $row["user"];
       $gender= $row["gender"];

       $response["user"] = $user;
       $response["gender"] = $gender;
       $response["success"] = true;

       echo json_encode($response); 

     }
   }

I fail to see how your examples and your code are related.

Julien Lachal
– Julien Lachal

2017-06-23 14:32:24 +00:00
Commented Jun 23, 2017 at 14:32 — Julien Lachal
– Julien Lachal, Commented Jun 23, 2017 at 14:32
Question is fine as is, and makes perfect sense.

Enstage
– Enstage

2017-06-23 14:36:39 +00:00
Commented Jun 23, 2017 at 14:36 — Enstage
– Enstage, Commented Jun 23, 2017 at 14:36

Enstage · Accepted Answer · 2017-06-23 14:36:08Z

1

if ($result->num_rows > 0)
  {
    while($row = $result->fetch_assoc())
     {
       $user= $row["user"];
       $gender= $row["gender"];

       $response['result'][] = [
           'user' => $user,
           'gender' => $gender,
           'success' => true
       ];

     }
     echo json_encode($response);
   }

You were formatting it on each loop, which will output entirely separate sets of JSON.

answered Jun 23, 2017 at 14:36

Enstage

2,13715 silver badges20 bronze badges

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

2 Comments

craftx27 Over a year ago

thank you so much i have been stuck at this for hours really appreciate your answer :) :)

Enstage Over a year ago

If my answer solved your problem, then please mark it as such by checking the tick below the voting buttons when it becomes available.

Collectives™ on Stack Overflow

Format JsonArray php

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related