douzhong4222 2019-05-10 06:25
浏览 225
已采纳

php从多维数组中获取最多和最少的值

I want to get most and least occuring values from php sequential/indexes, assoc and multidimensional arrays

Consider the following dataSet

        $dataSet = [
            'users' => 
            [
                'id' => 1,
                'name' => "Alex",
                'username' => 'alex',
            ],
            [
                'id' => 2,
                'name' => "Alex",
                'username' => 'alex'
            ],
            [
                'id' => 2,
                'name' => "Peter Khot",
                'username' => 'peter',
            ]
        ];

Here above are samples dataSet

Here is what that i tried

    function most_occurring(array $array, $key)
    {
        $dataSet = [];
        $i = 0;
        $keys = [];
        foreach ($array as $k) {
            if (in_array($k[$key], $keys)) {
                $keys[$i] = $k[$key];
                $dataSet[$i] = $k;
            } 

            $i++;
        }

        return $dataSet;
    }

I tried above code for most occurring values but not working at all, help me in most and least occuring values from arrays. Thanks

  • 写回答

2条回答 默认 最新

  • drll42469 2019-05-10 07:15
    关注

    Thanks to KIKO Software, you can still use array_count_values() for this cases. You will also need to use array_columns() and array_search() in this situation. You can refer to this link to see how array_search() helps in finding the maximum/minimum value and its corresponding key inside an array. To find the most or least occurrence, simply echo the last 6 variables that I have declared in the last 6 lines.

    EDIT* reference: unset array_push

    *And also, your first data in the assoc array is indexed 'user', but the second data in the assoc array is not indexed and hence it is indexed as 0.

    $dataSet = [
                'users' => 
                [
                    'id' => 1,
                    'name' => "Alex",
                    'username' => 'alex',
                ],
                [
                    'id' => 2,
                    'name' => "Alex",
                    'username' => 'alex'
                ],
                [
                    'id' => 2,
                    'name' => "Peter Khot",
                    'username' => 'peter',
                ]
            ];
    $id = array_column($dataSet,'id');
    $name = array_column($dataSet, 'name');
    $username = array_column($dataSet, 'username');
    $occur_id = array_count_values($id);
    $occur_name = array_count_values($name);
    $occur_username = array_count_values($username);
    $most_occur_id  = array_search(max($occur_id),$occur_id);
    $most_occur_name  = array_search(max($occur_name),$occur_name);
    $most_occur_username  = array_search(max($occur_username),$occur_username);
    $least_occur_id  = array_search(min($occur_id),$occur_id);
    $least_occur_name  = array_search(min($occur_name),$occur_name);
    $least_occur_username  = array_search(min($occur_username),$occur_username);
    

    EDIT*: (In case of multiple highest occurence OR all same occurence, just add below code right below the above code.)

    $flag = true;
    $most_occur_name_list = [];
    $count = 0;
    while($flag)
    {
      $most_occur_name_ct =  max($occur_name);
      if($most_occur_name_ct == $count || $count == 0)
        {
          array_push($most_occur_name_list,array_search($most_occur_name_ct,$occur_name));
          unset($occur_name[array_search($most_occur_name_ct,$occur_name)]);
          $count = $most_occur_name_ct;
          if(count($occur_name) == 0)
          {
              $flag = false;
              break;
          }
        }
      else
        {
          $most_occur_name_ct = $count;
          $flag = false;
          break;
        }
    }
    
    //must reinitialize the array
    $occur_name = array_count_values($name);
    $flag = true;
    $least_occur_name_list = [];
    $count = 0;
    while($flag)
    {
      $least_occur_name_ct =  min($occur_name);
      if($least_occur_name_ct == $count || $count == 0)
        {
          array_push($least_occur_name_list,array_search($least_occur_name_ct,$occur_name));
          unset($occur_name[array_search($least_occur_name_ct,$occur_name)]);
          $count = $least_occur_name_ct;
          if(count($occur_name) == 0)
          {
              $flag = false;
              break;
          }
        }
      else
        {
          $least_occur_name_ct = $count;
          $flag = false;
          break;
        }
    }
    if($most_occur_name_ct == $least_occur_name_ct)
    {
        $most_occur_name_list = [];
        $least_occur_name_list = [];
    }
    echo "<pre>";
    print_r($most_occur_name_list);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
  • dtysql0586 2019-05-10 08:35
    关注

    If you wanted to get a list of the min and max number of occurrences for just 1 element of the multidimensional array, then this code may offer a shorter method - comments in code...

    $dataSet = [
        'users' =>
        [
            'id' => 1,
            'name' => "Alex",
            'username' => 'alex',
        ],
        [
            'id' => 2,
            'name' => "Alex",
            'username' => 'alex'
        ],
        [
            'id' => 2,
            'name' => "Peter Khot",
            'username' => 'peter',
        ],
        [
            'id' => 2,
            'name' => "Peter Khot",
            'username' => 'peter',
        ],
        [
            'id' => 2,
            'name' => "Paul Khot",
            'username' => 'Paul',
        ]
    ];
    
    // Create an array which has the username column, but retaining the keys from
    // the original array
    $set = array_combine(array_keys($dataSet), 
            array_column($dataSet, "username" ));
    // Summarise the values
    $count = array_count_values($set);
    
    // Get a list of the keys which match the max and min values
    $minRecords = array_keys($count,min($count));
    $maxRecords = array_keys($count,max($count));
    // Fetch the details for the maximum value (first one returned)
    $maxElements = [];
    foreach ( $maxRecords as $max ) {
        $maxElements[] = $dataSet[array_search($max, $set )];
    }
    
    // Same for min values
    $minElements = [];
    foreach ( $minRecords as $min ) {
        $minElements[] = $dataSet[array_search($min, $set )];
    }
    
    print_r($maxElements);
    print_r($minElements);
    

    With the test data I've added, you get the output...

    Array
    (
        [0] => Array
            (
                [id] => 1
                [name] => Alex
                [username] => alex
            )
    
        [1] => Array
            (
                [id] => 2
                [name] => Peter Khot
                [username] => peter
            )
    
    )
    Array
    (
        [0] => Array
            (
                [id] => 2
                [name] => Paul Khot
                [username] => Paul
            )
    
    )
    
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 初学者c语言题目解答
  • ¥15 div editable中的光标问题
  • ¥15 mysql报错1415Not allowed to return a result set from a trigger 不知如何修改
  • ¥60 Python输出Excel数据整理,算法较为复杂
  • ¥15 回答几个问题 关于数据库
  • ¥15 51单片机串口通信问题,未完成且要修改
  • ¥15 百鸡问题 c++编程问题(相关搜索:输出数据)
  • ¥30 如何在CMD中设置代理
  • ¥15 我有一块薛定谔的硬盘
  • ¥15 微信小游戏开发2D碰撞检测问题