How to find data in multi-dimensional array in php?

Question

Let's say, I have something like below (quantities can be variable):

Product Color   XS   S    M    L    XL
   A    RED     100  200  200  200  100
   A    WHITE    50  100  200  100   20
   B    RED      50  200  200  100   50
   B    WHITE   100  200  300  200  100

If I saved them into array such as like this:

$product_array[] = 
    array('product' => 'A', 'color'  => 'RED',
          'XS'      => 100, 'S'      => 200,
          'M'       => 200, 'L'      => 200, 
          'XL' =>100);

What is the easiest way to find size quantity and update their given Product id and color? Let's say, (A, RED) sold XS size 10 qty?

Further than just the name as index - make each product name an index to a sub-array, and each product color a sub-array of that, which contains the sizes as keys. So $products['A']['RED']['XL'] (really though, it would be simplest in a database) — Michael Berkowski
– Michael Berkowski, Commented Feb 1, 2013 at 19:08
all products and qty are read from database. now want to display to users given conditions — user1084885
– user1084885, Commented Feb 1, 2013 at 19:18

fsw · Accepted Answer · 2013-02-01 19:15:09Z

1

As noted in comments you could use item name + color as an index. If you need to use given format you can create array of references to fasten things up.

$product_array[] = 
    array('product' => 'A', 'color'  => 'RED',
      'XS'      => 100, 'S'      => 200,
      'M'       => 200, 'L'      => 200, 
      'XL' =>100);
$product_array[] = 
    array('product' => 'B', 'color'  => 'GREEN',
      'XS'      => 100, 'S'      => 200,
      'M'       => 200, 'L'      => 200, 
      'XL' =>100);

foreach($product_array as &$product)
{
    $product_by_name_and_color[$product['product']][$product['color']] =& $product;
}

and then:

$product_by_name_and_color['B']['GREEN']['XS'] += 5;
print_r($product_array);

EDIT:

If your products are red from database, most probably you want to update values in database and you are asking the wrong question.

answered Feb 1, 2013 at 19:15

fsw

3,7253 gold badges23 silver badges35 bronze badges

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

3 Comments

user1084885 Over a year ago

no, I do not want to update to db. once read from db. I need to perform totally different operation. I need to re-distribute them by given condition. back to your code, in foreach statement, how to match product and color after find it how to update qty for that matched item?

user1084885 Over a year ago

I guess this is what you meant foreach($product_array as &$p) { if( $p['product'] == 'A' && $p['color'] == 'RED' ) { $qty = $p['XS']+$p['S']+$p['M']+$p['L']+$p['XL']; } }

fsw Over a year ago

foreach loop is just too create $product_by_name_and_color, an array of references. next bit of code shows how to update products.

Collectives™ on Stack Overflow

How to find data in multi-dimensional array in php?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related