drny60365 2016-06-06 10:04
浏览 54
已采纳

获取关键php数组具有相同值的值的总和

I have below array,

Array ( [0] => Array ( [report_id] => 1 [amount] => 100.00 [category_name] => Trial1 ) [1] => Array ( [report_id] => 1 [amount] => 150.00 [category_name] => Trial2 ) [2] => Array ( [report_id] => 1 [amount] => 200.00 [category_name] => Trial2 ) 

What i want to send to have JSON with below format

It will get some of Equal category name and then send it as json.

[{'category_name': 'Trial1', 'Sum':100]}, {'category_name':'Trial2', 'Sum':350]

How can i achieve this? Was thinking to get foreach loop and then make compare of category_name and use .=+ to get sum? but i lost there,

Thanks,

  • 写回答

3条回答 默认 最新

  • dongshi1188 2016-06-06 10:19
    关注

    Try below solution:

    <?php
    $array = array ( 
    '0' => Array ( 'report_id' => 1, 'amount' => '100.00', 'category_name' => 'Trial1' ) ,
    '1' => Array ( 'report_id' => 1, 'amount' => '150.00' ,'category_name' => 'Trial2' ),
    '2' => Array ( 'report_id' => 1, 'amount' => '200.00' ,'category_name' => 'Trial2' ) ,
    );
    
    $new_array = array();
    foreach($array as $a){
        if(!isset($new_array[$a['category_name']]['amount'])){
            $new_array[$a['category_name']]['amount'] = 0;
        }
        $new_array[$a['category_name']] = array(
            'category_name' => $a['category_name'],
            'amount' => $new_array[$a['category_name']]['amount'] + $a['amount'],
        );
    }
    
    //print_r(array_values($new_array));
    
    echo json_encode(array_values($new_array));
    

    Output

    [{"category_name":"Trial1","amount":100},{"category_name":"Trial2","amount":350}]
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 MATLAB怎么通过柱坐标变换画开口是圆形的旋转抛物面?
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿