Convert Array to json using foreach loop

Question

I am Trying to convert array to json but not getting exact result I am looking for.

Here,

<?php
      $result=array();
      $result[status]=1;
      $data=array(
                array("ucode" => "123","name" => "abc","lname" => "xyz"),
                array("ucode" => "431","name" => "cdb","lname" => "zsa")
              );
      foreach($data as $res){ 
          $data=array();
           $data[ucode]=$res['ucode'];
           $data[name]= $res['name'];
           $data[lname]= $res['lname'];
           $result[content]=$data;
        }

echo $res=json_encode($result);

?>

Actul Result:

{"status":1,"content":{"ucode":"431","name":"cdb","lname":"zsa"}}

My expected Result:

{"status":1,"content":[{"ucode":"123","name":"abc","lname":"xyz"},{"ucode":"431","name":"cdb","lname":"zsa"}]}

please, Guide me where is mistake, not getting the expected result.

@NigelRen And wrapp a json_encode() round that and Bob's yer Uncle — RiggsFolly
– RiggsFolly, Commented May 14, 2019 at 11:15

Rahul · Accepted Answer · 2019-05-14 11:17:01Z

5

Why need loop, if you can directly push data into content index of result.

$result         = [];
$result["status"] = 1;
$data           = [
    ["ucode" => "123", "name" => "abc", "lname" => "xyz"],
    ["ucode" => "431", "name" => "cdb", "lname" => "zsa"],
];
$result['content'] = $data;
echo $res = json_encode($result);

Short form of it,

$result = ['status' => 1, 'content' => $data];
echo json_encode($result);

Working demo.

Output

{"status":1,"content":[{"ucode":"123","name":"abc","lname":"xyz"}, 
 {"ucode":"431","name":"cdb","lname":"zsa"}]}

edited May 14, 2019 at 11:17

answered May 14, 2019 at 11:10

Rahul

18.6k7 gold badges43 silver badges64 bronze badges

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

2 Comments

B001ᛦ Over a year ago

Working perfectly for me

Nigel Ren Over a year ago

I think as the original answer did not have any explanation with it was (I think) the problem.

Antony Thompson · Accepted Answer · 2019-05-14 11:18:56Z

3

Your reusing the variable $data which is causing your problem. Also when you append to the $result['content'] array, you need to use [].

<?php
    $result = array(
        'content' => array(),
        'status' => 1
    );
    $data= array(
        array("ucode" => "123","name" => "abc","lname" => "xyz"),
        array("ucode" => "431","name" => "cdb","lname" => "zsa")
    );
    foreach($data as $res){ 
        $tmp = array(
            'ucode' => $res['ucode'],
            'name' => $res['name'],
            'lname' => $res['lname']
        );
        $result['content'][] = $tmp;
    }
    echo $res = json_encode($result);
?>

edited May 14, 2019 at 11:18

answered May 14, 2019 at 11:13

Antony Thompson

1,6381 gold badge13 silver badges22 bronze badges

4 Comments

Rahul Over a year ago

What is the need of loop in your code, can you explain?

Antony Thompson Over a year ago

@quickSwap There is no need. But I suspect this is not exactly what the OP is trying to do in their original code. It's probably a simplified version.

Antony Thompson Over a year ago

Yes but the actual code probably is not like that. I suspect the $data is just for our benifit. It's probably coming from a database or some other source. Either way, if the OP is actually just looping over the same data pointlessly then the other answers are showing he doesn't need to do that. I'm just showing another point of view.

Ghanshyam Nakiya Over a year ago

Yes, It is coming from database

Ghanshyam Nakiya · Accepted Answer · 2019-05-14 11:51:14Z

I got another way solution, just with you guys,

because I want rename my variables names when pass in api with json_encode().

  <?php
            $result=array();
            $result['status']=1;
            $data=array(
                      array("ucode" => "123","name" => "abc","lname" => "xyz"),
                      array("ucode" => "431","name" => "cdb","lname" => "zsa"),
                    );
            $ar=array();
            foreach($data as $res){
                $data=array();
                 $data['u_code']=$res['ucode'];
                 $data['u_name']= $res['name'];
                 $data['u_lname']= $res['lname'];
                 $ar[]=$data;
              }
            $result['content']=$ar;
            echo $res=json_encode($result);

      ?>

Collectives™ on Stack Overflow

Convert Array to json using foreach loop

3 Answers 3

2 Comments

4 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

4 Comments

Comments

Related