首頁(yè) 猿問(wèn) 關(guān)于Php數(shù)組的問(wèn)題

關(guān)于Php數(shù)組的問(wèn)題

PHP

呼啦一陣風(fēng) 2019-03-13 01:28:11

Array ( [0] => Array ( [oid] => 190 [color] => [goods_name] => 測(cè)試要 [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] => 測(cè)試要 [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 ) ) 如上數(shù)組是 $a ; 我需求出上面數(shù)組的 goods_num 之和最終組合成下面這個(gè)樣的數(shù)組，請(qǐng)大神們幫個(gè)忙吧！ Array ( [0] => Array ( [name] => 測(cè)試要 [number] => 2 ) [1] => Array ( [name] => A5筆記本子 [number] => 2 ) ) 完全沒(méi)有頭緒，也不知道怎么搞。。。。反正就是各種懵逼了?。?！~ 我通過(guò)直接在數(shù)據(jù)庫(kù)計(jì)算，出現(xiàn)這樣的結(jié)果 Array ( [0] => Array ( [name] => 測(cè)試要 [number] => 2 ) [1] => Array ( [name] => A5筆記本子 [number] => 2 ) [2] => Array ( [name] => 測(cè)試要 [number] => 2 ) ) 但是去重又是個(gè)問(wèn)題了。我實(shí)在不知道咋搞了。。還是得求大神?。。?！

查看完整描述

4 回答

慕田峪4524236

TA貢獻(xiàn)1875條經(jīng)驗(yàn) 獲得超5個(gè)贊

假設(shè)你的商品表為goods

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

反對(duì) 回復(fù) 2019-03-18

小怪獸愛(ài)吃肉

TA貢獻(xiàn)1852條經(jīng)驗(yàn) 獲得超1個(gè)贊

$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);

反對(duì) 回復(fù) 2019-03-18