php array operations with indexes

Question

I have a array what I'm fetching with mysql query per row, each containing the same indexes and it looks as it follows

array(

    0=> array(
         'order_nr'=> 123,
         'order_date' => '2013-01-29 00:00:00',
         'prod_name' => 'prod_1',
         'prod_value' => 1200

       )

    1=> array(
         'order_nr'=> 123,
         'order_date' => '2013-01-29 00:00:00' ,
         'prod_name' => 'prod_2',
         'prod_value' => 2100
    )

)

I would like to merge theme and make the sum of prod_value and creating a new array on prod_name and at the end I would have singe array. How would I do this in php or what would be the best workaround in this case

array(
 'order_nr'=> 123,
 'order_date'=>'2013-01-29 00:00:00',
 'prod_name'=> array('prod_1', 'prod_2')
 'prod_value' => 3300

)

At least to me, isn't easy to understand what you're trying to obtain. Please, be more specific and use an "output sample" — DonCallisto
– DonCallisto, Commented Feb 5, 2013 at 8:42
if you're trying to sum up these values, I'd suggest to use GROUP BY on the database side, not on the PHP side — Zathrus Writer
– Zathrus Writer, Commented Feb 5, 2013 at 8:46

Michal Trojanowski · Accepted Answer · 2013-02-05 09:00:11Z

1

If the list of products doesn't have to be an array you can use Mysql and aggregating functions. It would be something like this:

SELECT order_no, order_data, GROUP_CONCAT(prod_name SEPARATOR ',') as prod_name, 
    SUM(prod_value) as prod_val FROM Products WHERE ... GROUP BY order_no;

If you need the product names as arrays you can then explode the string:

explode(',', $row['prod_name']);

answered Feb 5, 2013 at 9:00

Michal Trojanowski

12.5k4 gold badges30 silver badges47 bronze badges

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

3 Comments

fefe Over a year ago

and how would I do the concat if I want to select all the columns?

fefe Over a year ago

I think this would be the most elegant shortcut

Michal Trojanowski Over a year ago

It will also be more efficient than making loops in the code. I don't quite understand the question in the first comment. What do you mean you want select all the columns?

Niclas Larsson · Accepted Answer · 2013-02-05 08:54:21Z

0

$aReturn = array();

foreach( $aData as $entry ) {
 if( empty($aReturn[$entry['order_nr']]) ) {
  $entry['prod_name'] = (array) $entry['prod_name'];
  $aReturn[$entry['order_nr']] = $entry;

  continue;
 }

 $aReturn[$entry['order_nr']]['prod_name'][] = $entry['prod_name'];
 $aReturn[$entry['order_nr']]['prod_value'] += $entry['prod_value'];
}

This will group by order_nr

answered Feb 5, 2013 at 8:54

Niclas Larsson

1,3178 silver badges13 bronze badges

1 Comment

fefe Over a year ago

let me try this seems to be interesting

Prasanth Bendra · Accepted Answer · 2013-02-05 08:54:52Z

<?php

$arr = array(0=> array(
                         'order_nr'=> 123,
                         'order_date' => '2013-01-29 00:00:00',
                         'prod_name' => 'prod_1',
                         'prod_value' => 1200

                       ),
            1=> array(
                         'order_nr'=> 123,
                         'order_date' => '2013-01-29 00:00:00' ,
                         'prod_name' => 'prod_2',
                         'prod_value' => 2100
                    )

            );

$sigle_arr = array();   
foreach($arr as $val){
   $sigle_arr[$val['order_nr']]['order_nr']     = $val['order_nr'];
   $sigle_arr[$val['order_nr']]['order_date']   = $val['order_date'];
   $sigle_arr[$val['order_nr']]['prod_name'][]  = $val['prod_name'];
   $sigle_arr[$val['order_nr']]['prod_value']  += $val['prod_value'];

}
print_r($sigle_arr);
?>

rohitarora · Accepted Answer · 2013-02-05 08:57:48Z

0

use array_merge_recursive()

that is the best option for doing it

answered Feb 5, 2013 at 8:57

rohitarora

1,3752 gold badges13 silver badges22 bronze badges

1 Comment

Prasanth Bendra Over a year ago

you can not get 'prod_value' in this case, It needs to be the sum of all the product 'prod_value'

user1646111 · Accepted Answer · 2013-02-05 09:02:04Z

0

$newarray = array();
foreach($array as $v){
 if(!isset($newarray['order_nr'])){ 
 $newarray['order_nr'] = $v['order_nr'];
 }
 if(!isset($newarray['order_date'])){ 
 $newarray['order_date'] = $v['order_date'];
 }
 $newarray['prod_name'][] = $v['prod_name'];

 $newarray['prod_value'] = $newarray['prod_value'] + $v['prod_value'];
}

answered Feb 5, 2013 at 9:02

user1646111

2 Comments

Prasanth Bendra Over a year ago

what if there are two orders in the array, i mean two different 'order_nr'

user1646111 Over a year ago

the question says: same index!

j0k · Accepted Answer · 2013-02-05 09:37:50Z

0

$temp = Users::find('all', array('conditions' => array('status' => array('$elemMatch' => array('fields' => array('temp')));
foreach($whichs as $which)
{
  foreach($which['temps'] as $temp)
  {
    if($temp['_id'] == $status['temp'])
    {
    array_push($tempsArray,$temp['status']);
    }
  }
}

edited Feb 5, 2013 at 9:37

j0k

22.8k28 gold badges81 silver badges90 bronze badges

answered Feb 5, 2013 at 9:12

user2041963

1

Collectives™ on Stack Overflow

php array operations with indexes

6 Answers 6

3 Comments

1 Comment

Comments

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

3 Comments

1 Comment

Comments

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related