[RESOLVED] Array Values Help Required

[kbc1]

Hi all

I have an array which contains items for a shopping basket as such:

Array
(
    [314:Black/Graphite-M] => Array
        (
            [quantity] => 1
            [productprice] => 17.99
        )

[314:Black/Graphite-L] => Array
    (
        [quantity] => 4
        [productprice] => 17.99
    )

[321:Bright@Blue/Blue-S] => Array
    (
        [quantity] => 3
        [productprice] => 22.00
    )

)

The array key contains the Product ID : Product Colour - Product Size values.

You can also see I store the quantitiy and product price against each of those keys.

What I need is help with is looping through this array and obtaining a count of all unique product id's and multiply them by the combined quantity assigned to the product ids.

So in the example array above, the result I need to get would be:

Product ID 314 has a total quantity of 5
Product ID 321 has a total quantity of 3

How on EARTH would I write a function that would pull this out??

Any advice would be greatly appreciated and save me hours of frustration.

regards
kbc

[bradgrafelman]

You could do a [man]foreach[/man] loop over the array (using the $key => $value notation), [man]explode/man the key on the first ':' to grab the product ID, and then use that product ID as a key in a temporary array whose value will be a sum of quantities. In other words, you'd add the quantity of each item in the foreach() loop onto the existing value in that array, if it exists, e.g.:

if(isset($array[$prod_id]))
    $array[$prod_id] += $value['quantity'];
else
    $array[$prod_id] = $value['quantity'];

[johanafm]

In my opinion you'd be better off building the array based on product id alone as key, where each element is an array with color-size as key and an array of price and quantity as value.

$basket = array();
while ($item = fetchNext($items))
{
	if (isset($basket[$item['id']] &&
		isset($basket[$item['id']][$item['color'].'-'.$item['size']])
	{
		$basket[$item['id']][$item['color'].'-'.$item['size']]['quantity'] += $item['quantity']
	}
	else
	{
		$basket[$item['id']][$item['color'].'-'.$item['size']] =
			array('quantity' => $item['quantity'], 'price' => $item['price']);
	}
}

foreach ($basket as $id => $item)
{
	printf('Product ID %d has a total quantity of %d',
		$id, count($item));
}

[kbc1]

Hi

Thanks for the responses. I chose to go with bradgrafelman's suggestions as this slots directly into the code I have.

Changing the basket structure of an existing shop would cause more work further down th eline however i agree the structure should be simpler.

Thanks again.