create nested array with PHP

Question

i have a problem here. so, i try to make nested array for my json using php and this is what im getting

[
  {
    "ID":"3301",
    "NAME":"cust 01",
    "ID2":"33"
   },
   {
    "ID":"3301",
    "NAME":"cust 01",
    "ID2":"33"
   }
 ]

but i want to make it like this

[
  {
    "ID":"3301",
    "NAME":"cust 01",
     "attribut":
     [
       {
         "ID2":"33"
       }
     ]
   },
   {
    "ID":"3301",
    "NAME":"cust 01",
    "attribut":
     [
       {
         "ID2":"33"
       }
     ]
   }
 ]

this is the code

//Query
$sql = 'select * from mytable';
$query = mysqli_query($con,$sql);
while($data=mysqli_fetch_array($query,MYSQLI_ASSOC))
$output[]=$data;
// json
echo json_encode($output);

can someone help me?

Is attribut always just an array with one element? If so, change 'ID2' => $value to 'attribut' => [['ID2' => $value]] — Barmar
– Barmar, Commented May 11, 2022 at 3:34
@Barmar im sorry, i already update my question with the code — Samuel
– Samuel, Commented May 11, 2022 at 3:36

Barmar · Accepted Answer · 2022-05-11 03:40:43Z

1

Move the ID2 value into the nested array in the attribut key before pushing onto the $output array.

while($data=mysqli_fetch_array($query,MYSQLI_ASSOC)) {
    $data['attribut'] = [['ID2' => $data['ID2']];
    unset($data['ID2']);
    $output[]=$data;
}

answered May 11, 2022 at 3:40

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

Comments

difw · Accepted Answer · 2022-05-11 04:00:54Z

0

like this?

$str = '[
  {
    "ID":"3301",
    "NAME":"cust 01",
    "ID2":"33"
   },
   {
    "ID":"3301",
    "NAME":"cust 01",
    "ID2":"33"
   }
 ]';
        $arr = json_decode($str,true);
        $ret =[];
        foreach ($arr as $item){
            $res = [];
            $res['ID'] = $item['ID'];
            $res['NAME'] = $item['NAME'];
            $temp['ID2'] = $item['ID2'];
            $res['attribut'][]=$temp;
            $ret[] = $res;
        }
        var_dump(json_encode($ret));

answered May 11, 2022 at 4:00

difw

11 bronze badge

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

create nested array with PHP

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related