How to form Json array from sql pdo data in php?

Question

The code that I have does not display what I need, tell me what I'm doing wrong

   $new_array =[];
  foreach($result as $row)
   {
    $array =[
        'id'=> $row["id"],
        'summ' => $row["summ"],
    ];
    foreach($array AS $key => $val) {
     $new_array[] = $val;
    }
   }
   echo json_encode($new_array);

Outputs the following result

["26","180","25","35","24","50","23","50","22","100"]

But I need the result to be different, and I can't. Here's an example of how it should be:

[
{"26","180"},
{"25","35"},
{"24","50"},
{"23","50"},
{"22","100"}
]

Please tell me how to achieve this?

The expected result isn't valid JSON. Instead of {"26", "180"}, don't you mean ["26", "180"]? — M. Eriksson
– M. Eriksson, Commented Jan 10, 2022 at 7:27
What have you tried so far? Is there any rule behind this formatting? — Nico Haase
– Nico Haase, Commented Jan 10, 2022 at 7:56

behzad m salehi · Accepted Answer · 2022-01-10 07:30:28Z

1

check this :

foreach($result as $row)
   $array[] = ['id'=>$row["id"], 'summ'=>$row["summ"]];
echo json_encode($array);

for example if your $result contains such a array :

$result    = [['id'=>1, 'summ'=>2] , ['id'=>3, 'summ'=>4] , ['id'=>5, 'summ'=>6]];

the scripts output will be :

[
    {"id":1,"summ":2},
    {"id":3,"summ":4},
    {"id":5,"summ":6}
]

answered Jan 10, 2022 at 7:30

behzad m salehi

1,08610 silver badges24 bronze badges

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

Comments

M. Eriksson · Accepted Answer · 2022-01-10 07:31:14Z

1

You can skip the inner loop:

$new_array = [];

foreach($result as $row)
{
    $new_array[] = [
        $row['id'],
        $row['summ']
    ];
}

echo json_encode($new_array);

That should give you the result:

[
    ["26","180"],
    ["25","35"],
    ...
]

answered Jan 10, 2022 at 7:31

M. Eriksson

13.7k4 gold badges31 silver badges42 bronze badges

Comments

ikhvjs · Accepted Answer · 2022-01-10 08:11:41Z

1

Beside other answer,

I usually use array_map for this kind of array transformation.

$result = [['id' => 1, 'summ' => 2], ['id' => 3, 'summ' => 4], ['id' => 5, 'summ' => 6]];

$output = array_map(function ($item) {
    return [$item['id'], $item['summ']];
}, $result);

edited Jan 10, 2022 at 8:11

answered Jan 10, 2022 at 7:51

ikhvjs

6,0874 gold badges24 silver badges53 bronze badges

Collectives™ on Stack Overflow

How to form Json array from sql pdo data in php?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related