关于Php数组的问题

Question

Array ( [0] => Array ( [oid] => 190 [color] => [goods_name] => 测试要 [goods_num] => 1 [goods_price] => 0.01 [id] => 44 [img] => /Public/Uploads/2017-12-13/5a30fa5763bdb.jpg [user_openid] => oWWUP0dieOLSHl3CzjyHIcIdhtVo [order_number] => 20181513226463 [tid] => 92 [status] => 1 [tuiid] => [aid] => [gid] => [corm_time] => 1514862004 ) [1] => Array ( [oid] => 191 [color] => [goods_name] => A5笔记本子 [goods_num] => 2 [goods_price] => 0.01 [id] => 43 [img] => /Public/Uploads/2017-12-06/5a27add5325d1.jpg [user_openid] => oWWUP0dieOLSHl3CzjyHIcIdhtVo [order_number] => 20181513241259 [tid] => 93 [status] => 1 [tuiid] => [aid] => [gid] => [corm_time] => 1514862004 ) [2] => Array ( [oid] => 193 [color] => [goods_name] => 测试要 [goods_num] => 1 [goods_price] => 0.01 [id] => 46 [img] => /Public/Uploads/2017-12-13/5a30fa5763bdb.jpg [user_openid] => oWWUP0dieOLSHl3CzjyHIcIdhtVo [order_number] => 20181513241259 [tid] => 93 [status] => 1 [tuiid] => [aid] => [gid] => [corm_time] => 1514862004 ) ) 如上数组是 $a ; 我需求出上面数组的 goods_num 之和 最终组合成下面这个样的数组，请大神们帮个忙吧！ Array ( [0] => Array ( [name] => 测试要 [number] => 2 ) [1] => Array ( [name] => A5笔记本子 [number] => 2 ) ) 完全没有头绪，也不知道怎么搞。。。。反正就是各种懵逼了！！！~ 我通过直接在数据库计算，出现这样的结果 Array ( [0] => Array ( [name] => 测试要 [number] => 2 ) [1] => Array ( [name] => A5笔记本子 [number] => 2 ) [2] => Array ( [name] => 测试要 [number] => 2 ) ) 但是去重又是个问题了。我实在不知道咋搞了。。还是得求大神啊！！！

Answer 1

假设你的商品表为goods

select goods_name as name,sum(goods_num) as number from goods  group by name;

Answer 2

$arr = [
        ['goods_name' => 'a', 'goods_num' => 1], 
        ['goods_name' => 'b', 'goods_num' => 1], 
        ['goods_name' => 'c', 'goods_num' => 1], 
        ['goods_name' => 'a', 'goods_num' => 2], 
        ['goods_name' => 'a', 'goods_num' => 3], 
        ['goods_name' => 'a', 'goods_num' => 5], 
        ['goods_name' => 'a', 'goods_num' => 8], 
        ['goods_name' => 'b', 'goods_num' => 8], 
        ['goods_name' => 'd', 'goods_num' => 9], 
       ];

$arr = array_reduce($arr, function($group, $item) {
    $group[$item['goods_name']][] = $item['goods_num'];
    return $group;
}, []);

$arr = array_map(function ($i) {
    return array_sum($i);
}, $arr);

print_r($arr);

Answer 3

mysql考虑一下group by；
如果只考虑你当前数组的话，可以循环当前数组，判断goods_name

Answer 4

楼上 回答的可以