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

问根据id重新排列php多维数组
EN

Stack Overflow用户
提问于 2020-09-29 13:12:22
回答 2查看 89关注 0票数 0

-I无法弄清楚如何将此数组重新组合为ids。

  • 这个数组来自mysql表。数字17和20是表中的外键。

代码语言:javascript
复制
$orginal_arr = 

Array
(
    [0] => Array
        (
            [id] => 17
            [content] => string...?
        )

    [1] => Array
        (
            [id] => 20
            [content] => hello
        )

    [2] => Array
        (
            [id] => 20
            [content] => string...?
        )

    [3] => Array
        (
            [id] => 20
            [content] => string...string...??
        )

    [4] => Array
        (
            [id] => 17
            [content] => string...
        )

    [5] => Array
        (
            [id] => 17
            [content] => string...
        )

);

我想将上面的$orginal_arr数组转换为下面的$desired_arr数组.

代码语言:javascript
复制
$desired_arr = Array (

          [0] => Array
              (
                  [17] => Array
                      (
                          [0] => string...?
                      )
              )
          [1] => Array
              (
                  [20] => Array
                      (
                          [0] => hello
                          [1] => string...?
                          [2] => string... string...??
                      )
              )
          [2] => Array
              (
                  [17] => Array
                      (
                          [0] => string...
                          [1] => string...
                      )
              )

      );

到目前为止,我正在尝试以下方法:

代码语言:javascript
复制
function group_by_key($key, $data)
{
    $result = array();
    $j      = 0;
    foreach ($data as $val) {
        if (array_key_exists($key, $val)) {
            $result[$val[$key]][$j] = $val;
        } else {
            $result[""][] = $val;
        }
        $j++;
    }
    return $result;
}


$desired_arr = group_by_key("id", $orginal_arr);

$desired_arr2 = array();
foreach ($desired_arr as $index => $item) {
    $desired_arr2 += $item;
}


echo "<pre>";
print_r($desired_arr2);
echo "</pre>";

产出:

代码语言:javascript
复制
Array
(
    [0] => Array
        (
            [id] => 17
            [content] => string...?
        )

    [4] => Array
        (
            [id] => 17
            [content] => string...
        )

    [5] => Array
        (
            [id] => 17
            [content] => string...
        )

    [1] => Array
        (
            [id] => 20
            [content] => hello
        )

    [2] => Array
        (
            [id] => 20
            [content] => string...?
        )

    [3] => Array
        (
            [id] => 20
            [content] => string...string...??
        )

)

-非常感谢

EN

回答 2

Stack Overflow用户

回答已采纳

发布于 2020-10-02 13:23:20

正如我在评论中所说的,我不再熟悉PHP语法,因此这将是伪代码。

我会分两步做,首先我想要这个结果

代码语言:javascript
复制
$temp_arr = 

Array
(
    [0] => Array
        (
            [id] => 17
            [contents] => Array(
                [0] => string...? 
            )
        )

    [1] => Array
        (
            [id] => 20
            [contents] => Array(
                [0] => hello
                [1] => string...? 
                [2] => string...string...??
            )
        )
...
...
);

看,我保留了带有id和内容的对象结构(带有最终的S)。这样就更容易检查id,因为它是可直接访问的。

代码语言:javascript
复制
$temp_array = Array();

foreach ($original_array as $element) {
    $last = end($temp_array);
    if ($last && $element->id == $last->id) {
        // add to the last $temp_array element
        $temp_array[count($temp_array)-1]->contents[] = $element->content;
    }
    else {
        // create a new $temp_array element
        $temp_array[] = Array(
            "id" => $element->id,
            "contents => Array(
                $element->content
            )
        );
        
    }
}

对于第二步,您只需要迭代$temp_array并根据您的喜好格式化

票数 0
EN

Stack Overflow用户

发布于 2020-10-02 19:05:38

这是解决这个问题的另一个办法。

代码语言:javascript
复制
$desired_arr = array();
$prev_id        = '';
$prev_key       = null;
foreach ($orginal_arr as $key => $value) {
    $this_id = $value['id'];
    if ($this_id == $prev_id) {
        array_push($desired_arr[$prev_key][$value['id']], $value['content']);
    } else {
        $desired_arr[$key][$value['id']] = (array)$value['content'];
        $prev_key                           = $key;
    }
    $prev_id = $this_id;
}
$desired_arr = array_values($desired_arr);
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/64120367

复制
相关文章

相似问题

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