create style of JSON object with PHP

Question

my JSON currently looks like this

{   
"customers":
 [
    {
        "customer_id":3,
        "customer_name":"Rick",
        "Address":"333 North Road"
    },
    {
        "customer_id":4,
        "customer_name":"Robby",
        "Address":"444 North West Road"
    }
 ]
}

and I would like it to look like this

{
    "customers":
    [
        {
            "customer":
             {
                 "customer_id":3,
                 "customer_name":"Rick",
                 "Address":"333 North Road"
             }
        },
        {
            "customer":
            {
                  "customer_id":4,
                  "customer_name":"Robby",
                  "Address":"444 North West Road"
            }
        }
    ]
}

It is being created in this php script but I'm unsure how to add the customer attribute to each JSON object programmtically. help please?

//populate results
$json = array();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
    $array = array(
            'customer_id' => $row['CustomerID'],
            'customer_name' => $row['Name'],
            'Address' => $row['Address']
        );
    array_push($json, $array);
  foreach ($row as $r) {

  }
}

$jsonstring = '{"customers":'. json_encode($json). "}";
return $jsonstring;

I'm trying to get the syntax to match a solution to another problem I am having to try and eliminate possibilities. — john
– john, Commented Apr 18, 2016 at 23:14

Ronen Ness · Accepted Answer · 2016-04-18 22:54:43Z

1

//populate results
$json = array();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
    $array = array("customer" => array(    // <-- change is here
               'customer_id' => $row['CustomerID'],
               'customer_name' => $row['Name'],
               'Address' => $row['Address']
            )
        );
    array_push($json, $array);
  foreach ($row as $r) {

  }
}

$jsonstring = '{"customers":'. json_encode($json). "}";
return $jsonstring;

answered Apr 18, 2016 at 22:54

Ronen Ness

10.9k4 gold badges36 silver badges51 bronze badges

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

1 Comment

john Over a year ago

Had to wait for the timer to go up.

Collectives™ on Stack Overflow

create style of JSON object with PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related