PHP multiple duplicate values in multidimensional array

Question

I am trying to update the below array to set "duplicate" => true when both "name" and "date" are the same. In the below example 'array[1][duplicate]=>true' as both array[0] & array[1] have the same "name"=john & "date"=2015-7-24

Array
(
    [0] => Array
    (
        [id] => 1
        [name] => john
        [date] => 2015-07-24
        [duplicate] => false
    )

    [1] => Array
    (
        [id] => 1
        [name] => john
        [date] => 2015-07-24
        [duplicate] => false
    )

    [2] => Array
    (
        [id] => 1
        [name] => jane
        [date] => 2015-07-24
        [duplicate] => false
    )

    [3] => Array
    (
        [id] => 1
        [name] => notJaneORJohn
        [date] => 2015-07-24
        [duplicate] => false
    )

    [4] => Array
    (
        [id] => 1
        [name] => jane
        [date] => 2099-07-24
        [duplicate] => false
    )

)

Malith Wijethunga · Accepted Answer · 2015-07-24 04:26:15Z

2

Try this,

$array = Array
(
    0 => Array
    (
        'id' => '1',
        'name' => 'john',
        'date' => '2015-07-24',
        'duplicate' => 'false',
    ),

    1 => Array
    (
        'id' => 1,
        'name' => 'john',
        'date' => '2015-07-24',
        'duplicate' => 'false'
    ),

    2 => Array
    (
        'id' => 1,
        'name' => 'jane',
        'date' => '2015-07-24',
        'duplicate' => 'false'
    ),

    3 => Array
    (
        'id' => 1,
        'name' => 'notJaneORJohn',
        'date' => '2015-07-24',
        'duplicate' => 'false'
    ),

    4 => Array
    (
        'id' => 1,
        'name' => 'jane',
        'date' => '2099-07-24',
        'duplicate' => 'false'
    )

);
foreach ($array as $key => $value) {
    for ($i = $key + 1 ; $i < sizeof($array); $i++) {
        if ($value['name'] === $array[$i]['name'] && $value['date'] === $array[$i]['date']) {
            $array[$key]['duplicate'] = 'TRUE';
            $array[$i]['duplicate'] = 'TRUE';
        }
    }
}

edited Jul 24, 2015 at 4:26

answered Jul 24, 2015 at 4:05

Malith Wijethunga

1381 silver badge9 bronze badges

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

1 Comment

matt Over a year ago

if I comment out this line //$array[$key]['duplicate'] = 'TRUE'; it works perfect

Ole Sauffaus · Accepted Answer · 2015-07-24 04:16:59Z

This would work:

$Arr = Array(
        ['id'=>1, 'name'=>'john', 'date'=>'2015-07-24', 'duplicate'=>0],
        ['id'=>1, 'name'=>'john', 'date'=>'2015-07-24', 'duplicate'=>0],
        ['id'=>1, 'name'=>'Jane', 'date'=>'2015-07-24', 'duplicate'=>0]
    );

foreach($Arr as $i1 => $v1){
    $Str1 = $v1['name'].$v1['date'];
    foreach($Arr as $i2 => $v2){
        if( $i1 !== $i2 && $Str1 === $v2['name'].$v2['date'] ){
            $Arr[$i1]['duplicate'] = 1;
        }
    }
}

echo '<pre>',print_r($Arr),'</pre>'; die();

... outputs:

Array(
[0] => Array
    (
        [id] => 1
        [name] => john
        [date] => 2015-07-24
        [duplicate] => 1
    )

[1] => Array
    (
        [id] => 1
        [name] => john
        [date] => 2015-07-24
        [duplicate] => 1
    )

[2] => Array
    (
        [id] => 1
        [name] => Jane
        [date] => 2015-07-24
        [duplicate] => 0
    )

)

Disha V. · Accepted Answer · 2015-07-24 05:26:02Z

Have a look at this shortcut method ;)

<?php $testarr = array(
    array("id" => 1,"name" => "john","date" => "2015-07-24","duplicate" => "false"),
    array("id" => 1,"name" => "john","date" => "2015-07-24","duplicate" => "false"),
    array("id" => 1,"name" => "jane","date" => "2015-07-24","duplicate" => "false"),
    array("id" => 1,"name" => "notJaneORJohn","date" => "2015-07-24","duplicate" => "false"),
    array("id" => 1,"name" => "jane","date" => "2099-07-24","duplicate" => "false")
);
$tempArray = array();
function checkDuplicate(&$arr) {
    global $tempArray;
    if (count($tempArray) > 0 && in_array($arr['name'], $tempArray) && in_array($arr['date'], $tempArray)) {
        $arr['duplicate'] = "true";
    } else {
        $tempArray[] = $arr['name'];
        $tempArray[] = $arr['date'];
    }
}
array_walk($testarr, 'checkDuplicate');
print_r($testarr);

Collectives™ on Stack Overflow

PHP multiple duplicate values in multidimensional array

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related