PHP array manipulation help required

Question

I've got a foreach loop (returning the details of products in the cart). What it's returning is this (I've cut it down a bit):

array(2) {
  [0]=>
  array(4) {
    ["retailer"]=>
    string(1) "2"
    ["productid"]=>
    int(400)
    ["quantity"]=>
    string(1) "1"
    ["discount"]=>
    int(0)
  }
  [1]=>
  array(4) {
    ["retailer"]=>
    string(1) "2"
    ["productid"]=>
    int(470)
    ["quantity"]=>
    int(1)
    ["discount"]=>
    int(0)
  }
}

What I'd like is for the array key to be the retailer ID and the content to be the product information. Any idea how to resort this array?

Clarification: I can't edit the original foreach loop as it's used for something else, therefore how do I sort that data into an array that's useful for other stuff? — ScottMcGready
– ScottMcGready, Commented Jul 29, 2013 at 22:45

AlexP · Accepted Answer · 2013-07-29 23:04:13Z

1

Assuming the array you posted is $data, this will give you an associative array with the key being the retailer id.

As the retailer is non unique, it will be an array of one or more "products".

$result = array();
foreach ($data as $row) {

  $id = $row['retailer'];  
  if (! isset($result[$id])) $result[$id] = array();

  $result[$id][] = array(
    'productid' => $row['productid'],
    'quantity'  => $row['quantity'],
    'discount'  => $row['discount'],
  );
}

edited Jul 29, 2013 at 23:04

answered Jul 29, 2013 at 22:57

AlexP

9,8571 gold badge28 silver badges44 bronze badges

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

2 Comments

ScottMcGready Over a year ago

Unfortunately that just overwrites the data in the array as the customer could have more than one product in their basket from the same retailer.

ScottMcGready Over a year ago

Man this is why I love Stack.

Collectives™ on Stack Overflow

PHP array manipulation help required

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related