Issue using array_diff_assoc in php [duplicate]

Question

I'm having trouble with array_diff_assoc because the result is not right. Im'm getting key [3] as a result in $diff but it exists in both $c1 and $c2 so the result in $diff doesn't makes sense since I'm using array_diff_assoc(). I should be getting key[0] from $c2 along with the other two keys [1] and [2] from $diff which are correct.

Query1 results in this array $c2

Array([0] => Array
        ([PROCESSO] => 1614436
         [DATAMSG] => 2015-04-27 22
         [CATEGORIA_DESC] => ECG_HR                        
         [VALOR] => 135
         [CRITICO] => 1)
    [1] => Array
        ([PROCESSO] => 1614436
         [DATAMSG] => 2015-04-27 23
         [CATEGORIA_DESC] => ECG_HR                        
         [VALOR] => 121
         [CRITICO] => 1)
    [2] => Array
        ([PROCESSO] => 1614436
         [DATAMSG] => 2015-04-27 23
         [CATEGORIA_DESC] => ECG_HR                        
         [VALOR] => 123
         [CRITICO] => 1)
    [3] => Array
        ([PROCESSO] => 1614436
         [DATAMSG] => 2015-04-27 23
         [CATEGORIA_DESC] => ECG_HR                        
         [VALOR] => 125
         [CRITICO] => 1))

Query 2 results in this array $c1

Array([0] => Array
        ([PROCESSO] => 1614436
         [DATAMSG] => 2015-04-27 23
         [CATEGORIA_DESC] => ECG_HR                        
         [VALOR] => 125
         [CRITICO] => 1))

Then I use $diff=array_diff_assoc($c2,$c1); and I get the results below in array $diff.

Array([1] => Array
        ([PROCESSO] => 1614436
         [DATAMSG] => 2015-04-27 23
         [CATEGORIA_DESC] => ECG_HR                        
         [VALOR] => 121
         [CRITICO] => 1)
    [2] => Array
        ([PROCESSO] => 1614436
         [DATAMSG] => 2015-04-27 23
         [CATEGORIA_DESC] => ECG_HR                        
         [VALOR] => 123
         [CRITICO] => 1)
    [3] => Array
        ([PROCESSO] => 1614436
         [DATAMSG] => 2015-04-27 23
         [CATEGORIA_DESC] => ECG_HR                        
         [VALOR] => 125
         [CRITICO] => 1))

EDIT: I tried using $diff=array_udiff_assoc($c2,$c1, array("cr", "comp_func_cr"));with the below function as in php.net example but it's returning the same thing as with array_diff_assoc.

class cr {
    private $priv_member;
    function cr($val)
    {$this->priv_member = $val;}
    static function comp_func_cr($c2, $c1)
    {if ($c2->priv_member === $c1->priv_member) return 0;
        return ($c2->priv_member > $c1->priv_member)? 1:-1;}}

Not saying this is the answer, but here's something for reference, in case this helps: stackoverflow.com/questions/19964353/… — Samuel Reid
– Samuel Reid, Commented Oct 7, 2015 at 16:48

Payer Ahammed · Accepted Answer · 2015-10-07 18:21:11Z

1

Try the following

<?php
foreach($c2 as $key=>$v1){
    if(in_array($v1, $c1)){
      unset($c2[$key]);
    }
}
print_r($c2);
?>

or you can make a function and use it example:

<?php
function array_defference($a1,$a2){
            if(sizeof($a1) >= sizeof($a2)){
                $large = $a1;
                $small = $a2;
            }else{
                $large = $a2;
                $small = $a1;
            }

            foreach($large as $key=>$v1){
                if(in_array($v1, $small)){
                    unset($large[$key]);
                }
            }
            return $large;

        }
        $reuslt = array_defference($c2,$c1); 
        print_r($reuslt);
?>

edited Oct 7, 2015 at 18:21

answered Oct 7, 2015 at 17:58

Payer Ahammed

9171 gold badge5 silver badges17 bronze badges

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

3 Comments

William_Wilson Over a year ago

This will only work if all of $c1's items are in $c2 and $c2 is the larger array... It answers this exact question, but is not very reusable.

Payer Ahammed Over a year ago

Probably it reusable now. Thanks @William_Wilson for your feedback

Zalif Over a year ago

Yes it works fine thanks. Since $c2 is always bigger or equal it is fine I believe.

William_Wilson · Accepted Answer · 2015-10-07 18:15:38Z

1

To expand the previous answer:

function array2D_diff( $c1, $c2 )
{
    $c3 = Array();
    foreach($c2 as $key=>$v)
    {
        if(!in_array($v, $c1))
        {
            $c3[] = $v;
        }
    }

    foreach($c1 as $key=>$v)
    {
        if(!in_array($v, $c2))
        {
            $c3[] = $v;
        }
    }

    return $c3;
}

print_r(array2D_diff( $c2, $c1 ));

This will work regardless of the order of passing $c2 and $c1.

edited Oct 7, 2015 at 18:15

answered Oct 7, 2015 at 16:52

William_Wilson

1,2747 silver badges16 bronze badges

3 Comments

Zalif Over a year ago

I tried that as you said but didn't work, I edited my post with my attempt.

William_Wilson Over a year ago

How are you calling array_udiff_assoc?

William_Wilson Over a year ago

Sorry, the array_udiff_assoc is for objects, not 2D arrays.

Payer Ahammed · Accepted Answer · 2015-10-07 16:52:02Z

0

array_diff_assoc(array1,array2) Compares array1 against array2 and returns the difference. Unlike array_diff() the array keys are also used in the comparison. It's actually compare with your array key so result is like your mansion.In your case you need to use this array_udiff_assoc($c2,$c1). Computes the difference of arrays with additional index check, compares data by a callback function.

answered Oct 7, 2015 at 16:52

Payer Ahammed

9171 gold badge5 silver badges17 bronze badges

1 Comment

Zalif Over a year ago

Tried but no luck, check my edit to see if I did it the right way.

Collectives™ on Stack Overflow

Issue using array_diff_assoc in php [duplicate]

3 Answers 3

3 Comments

3 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

3 Comments

1 Comment

Linked

Related