Incrementing value of an array from another array

Question

I have 2 arrays

$array1 = array(22,193,124);
$array2 = array(array('id'=>22, 'count'=> 1), array('id'=>124, 'count'=>2));

Now I need to search in $array2 for id from $array1 and if found to increment the count value and also add to the array the one's which are not found with a count as 1 so my resulting array would be

$arr = array(array('id'=>22, 'count'=> 2), array('id'=>124, 'count'=>3), array('id'=>193, 'count'=>1));

any help would be appreciated

The current code which I tried is

if($array2){
            foreach($array1 as $array){

                if(in_array($array, array_column($array2, 'id'))){                  
                    $wa_array['count'] += 1;
                } else {
                    $wa_array['id'] = $array;
                    $wa_array['count'] = 1;
                }
            }

        } else {
            foreach($array1 as $array){
                $wa_array['id'] = $array;
                $wa_array['count'] = 1;
            }
        }

You either need to remove the array keywords or replace [ and ] with ( and ). — AbraCadaver
– AbraCadaver, Commented Aug 24, 2018 at 18:50
Hint: Use a for loop to iterate over $array1, Use in_array() to test if the id is in $array1, and if it is, increment the count. — Barmar
– Barmar, Commented Aug 24, 2018 at 18:53

DIGVJSS · Accepted Answer · 2018-08-24 19:24:48Z

1

This may be something you are looking for -

$array1 = array(22,193,124);
$array2 = array(array('id'=>22, 'count'=> 1), array('id'=>124, 'count'=>2));

foreach($array1 as $key=>$digit)
{
  $keyFound = array_search($digit, array_column($array2, 'id'));

  if($keyFound === false)
    {
      array_push($array2, ['id'=>$digit, 'count'=>1]);
    }
  else
    {
      $array2[$keyFound]['count']++;
    }
}

print_r($array2);

answered Aug 24, 2018 at 19:24

DIGVJSS

4991 gold badge11 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jimmy Surprenant · Accepted Answer · 2018-08-24 19:11:27Z

0

The question is not so clear, so I will go with my understanding : You need to check if values inside the first array are in the second array. If yes, increment the count value of that second array, if not, create that element with the value of 1.

This code is not tested, hope this can help find the good solution.

  foreach($array1 as $value){
     searchForId($value,$array2);
  }

  function searchForId($id, $array) {
    foreach ($array as $key => $val) {
      if ($val['id'] === $id) {
       $val['count'] += 1;
      }else{
        array_push(array('id'=>$id,'count'=>1))
      }
    }
  return null;
 }

answered Aug 24, 2018 at 19:11

Jimmy Surprenant

1637 bronze badges

Comments

Barmar · Accepted Answer · 2018-08-24 19:12:57Z

0

you should loop through $array2, not $array1. Finding the value in array_column($array2, 'id') doesn't tell you the index of the array element to increment.

foreach ($array2 as &$item) {
    if (in_array($item['id'], $array1)) {
        $item['count']++;
    }
}

Note that you have to use &$item to make this a reference to the original array element, so that modifying it will update $array2. Otherwise, $item would be a copy of the array element.

If $array1 is large, it would be better to convert it to an associative array so you can test membership more efficiently.

$array1_assoc = array_flip($array1);

Then the test in the loop becomes:

if (isset($array1_assoc[$item['id']]) {

answered Aug 24, 2018 at 19:12

Barmar

789k57 gold badges554 silver badges669 bronze badges

Comments

Ntwobike · Accepted Answer · 2018-08-24 19:31:37Z

0

Check this one. NOTE: But this has O(n^2) complexity.

$array1 = [22,193,124];

$array2 = [['id'=>22, 'count'=> 1], ['id'=>124, 'count'=>2]];

foreach ($array1 as $value) {
    $isFound = false;
    foreach ($array2 as &$item) {
        if ($value == $item['id']) {
           $item['count']++;
           $isFound = true;
           continue;
        }
    }
    if ($isFound == false) {
       $array2 [] = ['id'=>$value, 'count'=> 1];
    }
}

var_dump($array2);

answered Aug 24, 2018 at 19:31

Ntwobike

2,7691 gold badge24 silver badges29 bronze badges

Collectives™ on Stack Overflow

Incrementing value of an array from another array

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related