首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >PHP根据id重新排列数据

问PHP根据id重新排列数据
EN

Stack Overflow用户
提问于 2020-07-21 23:26:58
回答 1查看 31关注 0票数 0
代码语言:javascript
复制
Array
(
    [0] => Array
        (
            [id] => 1
            [member_id] => 8
            [total] => 5
            [mainroomid] => 2         
        )

    [1] => Array
        (
            [id] => 2
            [member_id] => 11
            [total] => 2
            [mainroomid] => 2
        )

    [2] => Array
        (
            [id] => 3
            [member_id] => 8
            [total] => 8
            [mainroomid] => 2

        )

    [3] => Array
        (
            [id] => 4
            [member_id] => 11
            [total] => 3
            [mainroomid] => 2
        )

    [4] => Array
        (
            [id] => 5
            [member_id] => 29
            [total] => 4
            [mainroomid] => 2

        )

    [5] => Array
        (
            [id] => 6
            [member_id] => 8
            [total] => 5
            [mainroomid] => 1
        )

    [6] => Array
        (
            [id] => 7
            [member_id] => 11
            [total] => 3
            [mainroomid] => 1
        )
)

上面的数据是从MySQL数据库返回的,我的逻辑卡在这里了,我想相应地循环数据,并将数据重新排列到一个新的数组中。这是否意味着所有相同的成员id,我需要将所有总数相加,并根据mainroomid分开。任何人都可以帮助你:(?下面是我需要显示的数据。

最终数据

代码语言:javascript
复制
[0] => Array

    (
      [0] => Array(

               [member_id] => 8
               [total] => 13
               [mainroomid] => 2 
            )

      [1] => Array(

               [member_id] => 11
               [total] => 5
               [mainroomid] => 2 
            )

      [2] => Array(

             [member_id] => 29
             [total] => 4
             [mainroomid] => 2 
          )
     )

[1] => Array

    (
      [0] => Array(

               [member_id] => 8
               [total] => 5
               [mainroomid] => 1 
            )

      [1] => Array(

               [member_id] => 11
               [total] => 3
               [mainroomid] => 1
            )
     )
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2020-07-21 23:48:51

通过使用sortBy和groupBy方法,您可以轻松地使用laravel的集合完成此操作。

代码语言:javascript
复制
// Lets say $data contains the data you listed above.

$sorted = collect($data)->sortBy('member_id')->groupBy('mainroomid')->values()->toArray();
票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/63017875

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档