I want to merge two array's using key(product_id) and adding that values(usage). Array 1
Array ( [0] => Array ( [name] => Reschedule A Service [usage] => 1 [product_id] => 8 ) [1] => Array ( [name] => Adding An Image [usage] => 1 [product_id] => 5 ) [2] => Array ( [name] => Each Calendar Event [usage] => 1 [product_id] => 14 ) )
Array 2
Array ( [0] => Array ( [name] => Adding An Image [usage] => 1 [product_id] => 5 ) [1] => Array ( [name] => Schedule A Service [usage] => 3 [product_id] => 11 ) [2] => Array ( [name] => Each Calendar Event [usage] => 2 [product_id] => 14 ) [3] => Array ( [name] => Sales Performance Dashboard [usage] => 2 [product_id] => 30 ) [4] => Array ( [name] => Quote [usage] => 1 [product_id] => 32 ) )
I need an out put like this merging and adding usage values.
Array ( [0] => Array ( [name] => Adding An Image [usage] => 2 [product_id] => 5 ) [1] => Array ( [name] => Schedule A Service [usage] => 3 [product_id] => 11 ) [2] => Array ( [name] => Each Calendar Event [usage] => 3 [product_id] => 14 ) [3] => Array ( [name] => Sales Performance Dashboard [usage] => 2 [product_id] => 30 ) [4] => Array ( [name] => Quote [usage] => 1 [product_id] => 32 ) [5] => Array ( [name] => Reschedule A Service [usage] => 1 [product_id] => 8 ) )
This is my code for creating arrays
foreach($query->rows as $product){ $top_products[]=array( 'name'=>$product['name'], 'usage'=>$product['pusage'], 'product_id'=>$product['product_id'] ); }
foreach($query_2->rows as $product){ $top_point_products[]=array( 'name'=>$product['name'], 'usage'=>$product['p_usage'], 'product_id'=>$product['product_id'] ); }