PHP array_combine

Question

Here is my PHP json output

[ {      
        "campaign_id": "4",   
        "date": "2017-04-01",   
        "name": "Dealoyal",   
        "iteration": "5149"   
    },   
....   
]

I want to make it to look like this:

[{   
    "date": "2017-04-01",   
    "Dealoyal": "5149"   
},...]

My code:

foreach ($result as $row) {
    $name[] = $row['name'];
    $iteration[] = $row['iteration'];
}
$mine[]=array_combine($name, $iteration);
echo json_encode($mine,JSON_PRETTY_PRINT);

But this only prints the last day names and iterations , when I need all days that I choose at date range. Do I need to use for loop or maybe there is another way?

Could you explain me what's wrong?

moderewer
– moderewer

2017-12-13 16:07:43 +00:00
Commented Dec 13, 2017 at 16:07 — moderewer
– moderewer, Commented Dec 13, 2017 at 16:07

SamHecquet · Accepted Answer · 2017-12-13 16:09:34Z

1

You don't need to use array_combine(), you can directly create $mine in the foreach:

$mine = array();
foreach ($result as $row) {
    $mine[] = array(
        'date' => $row['date'],
        $row['name'] => $row['iteration'],
    );
}
echo json_encode($mine, JSON_PRETTY_PRINT);

answered Dec 13, 2017 at 16:09

SamHecquet

1,8464 gold badges19 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

PHP array_combine

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest