如果是，检查数组中是否存在键，计算它并创建一个新的数组php

Question

From my SQL query, I will get the following array as a result. This is the last result I can get from SQL.I cant change any SQL because of some constraint. I need to check if the same id exists or not and if it does need to count them and remove one of the duplicate array having the same id. Sample array is

$array = array(
          0 => array(
            'id' => '17',
            'status' => 1,


          ),
          1 => array(
            'id' => '18',
            'status' => 1,


          ),
          2 => array(
            'id' => '21',
            'status' => 1,


          ),
          3 => array(
            'id' => '5',
            'status' => 2,


          ),
          4 => array(
            'id' => '18',
            'status' => 1,


          ),
          5 => array(
            'id' => '22',
            'status' => 5,


          ),
          6 => array(
            'id' => '6',
            'status' => 1,


          ),
        );

I need to check if they have a duplicate id or not, if yes need to count them and remove one of the duplicates.We need to preserve the array structure.

End Results should be

array(
  0 => array(
    'id' => '17',
    'status' => 1,
'count'=1,

  ),
  1 => array(
    'id' => '18',
    'status' => 1,
'count'=2,



  ),
  2 => array(
    'id' => '21',
    'status' => 1,
'count'=1,


  ),
  3 => array(
    'id' => '5',
    'status' => 2,
'count'=1,


  ),
  4 => array(
    'id' => '22',
    'status' => 5,
'count'=1,


  ),

  5 => array(
    'id' => '6',
    'status' => 1,
'count'==>1,
  ),
)

Answer 1

You can Check it by this way but duplicate entry still in the array.

$ids = array();

foreach ($array as $key => $value) 
{
   $ids[] = $value['id'];
   $count = array_count_values($ids);
}

for($i = 0; $i < count($array);$i++)
{

  $array[$i]['count'] = $count[$array[$i]['id']];
}