Unset array by key and value using PHP

Question

My array are $arrIncome and $arrExpense. They have some the same date and some not the same date.

$arrIncome = [
   [
     'date' => '01-01-2019',
     'total' => '500',
   ],
   [
     'date' => '02-01-2019',
     'total' => '200',
   ],
   [
     'date' => '03-01-2019',
     'total' => '300',
   ],
   [
     'date' => '04-01-2019',
     'total' => '900',
   ],
];

$arrExpense= [
   [
     'date' => '01-01-2019',
     'total' => '50',
   ],
   [
     'date' => '02-01-2019',
     'total' => '60',
   ],
   [
     'date' => '07-01-2019',
     'total' => '25',
   ],
   [
     'date' => '08-01-2019',
     'total' => '50',
   ],
];

I loop in $arrIncome array, if I found income date have in $arrExpense array, I will remove an array in $arrExpense by income date of $arrIncome, because I want to make unique date.

foreach ($arrIncome as $income){
        $isExistExpense = array_filter($arrExpense, function($expense) use($income){
            return $expense->date == date('Y-m-d', strtotime($income->date));
        });


        if(count($isExistExpense) > 0 ){
            foreach ($isExistExpense as $expense){
                // THIS PLACE TO UNSET $arrExpense by date value
                unset($arrExpense['date'] = $income->date); // this is a wrong way
            }
        }else{
            // my code more here.....
        }
    }

Possible duplicate of How to delete an array element based on key? — Russ J
– Russ J, Commented Feb 24, 2019 at 4:46
I think it doesn't the same what i want. Array doesn't the same — Mengseng Oeng
– Mengseng Oeng, Commented Feb 24, 2019 at 4:48

Miroslav Glamuzina · Accepted Answer · 2019-02-24 05:00:12Z

3

You must unset it by the index.

You can do it like:

// Get the intersection of the dates 
$isExistExpense = array_intersect(
    array_column($arrIncome,'date'), 
    array_column($arrExpense,'date'));
// Loop through the `$arrExpense` and unset the that exist in the array. 
foreach($arrExpense as $index=>$vals){
    if(in_array($vals['date'], $isExistExpense)){
        unset($arrExpense[$index]);
    }
}

Hope this helps,

edited Feb 24, 2019 at 5:00

answered Feb 24, 2019 at 4:46

Miroslav Glamuzina

4,5872 gold badges23 silver badges33 bronze badges

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

3 Comments

Nick Over a year ago

It's weird. You have a typo ($v should be $vals) but the code works anyway...

Miroslav Glamuzina Over a year ago

Updated. That is weird.

Nick Over a year ago

Actually I was wrong, the code wasn't working with $v it was just that I was testing it on my pre-filtered version of $arrExpense so it wasn't actually doing anything ($isExistExpense was empty).

Nick · Accepted Answer · 2019-02-24 04:47:53Z

2

You can use array_filter to directly remove the elements of $arrExpense that have dates which exist in $arrIncome (using array_column to get the list of dates in that array):

$arrExpense = array_filter($arrExpense, function ($v) use ($arrIncome) { 
    return !in_array($v['date'], array_column($arrIncome, 'date'));
});
print_r($arrExpense);

Output:

Array (
   [2] => Array ( [date] => 07-01-2019 [total] => 25 )
   [3] => Array ( [date] => 08-01-2019 [total] => 50 )
)

Demo on 3v4l.org

answered Feb 24, 2019 at 4:47

Nick

147k23 gold badges67 silver badges106 bronze badges

5 Comments

Miroslav Glamuzina Over a year ago

Yeah, that's better

Mengseng Oeng Over a year ago

Your answer is not remove array, but you just show different array on $arrExpense.

Mengseng Oeng Over a year ago

Your answer is not remove array, but you just show different array on $arrExpense.

Nick Over a year ago

@MengsengOeng the end result is the same, so does it matter?

Mengseng Oeng Over a year ago

Because I will to do more in $arrExpense. I must remove element of $arrExpense. Thank for answer.

Collectives™ on Stack Overflow

Unset array by key and value using PHP

2 Answers 2

3 Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related