Delete duplicate values array

Question

I'm trying to delete duplicate arrays.. but it seems not to work...

this is my array:

array
(
[1] => Array
    (
        [id] => 141
        [yt] => 5
        [PHD] => Jan
        [type] => Mercedes
        [aid] => 5
    )

[2] => Array
    (
        [id] => 2
        [yt] => 5
        [PHD] => Jan
        [type] => Mercedes
        [aid] => 5
    )

[3] => Array
    (
        [id] => 3
        [yt] => 5
        [PHD] => Jan
        [type] => Mercedes
        [aid] => 5
    )

[4] => Array
    (
        [id] => 10
        [yt] => 5
        [PHD] => Jan
        [type] => Mercedes
        [aid] => 5
    )

[5] => Array
    (
        [id] => 4
        [yt] => 5
        [PHD] => Peter
        [type] => Audi
        [aid] => 5
    )
)

OUTPUT

[5] => Array
    (
        [id] => 4
        [yt] => 5
        [PHD] => Peter
        [type] => Audi
        [aid] => 5
    )

The array creates with a SQL query so I foreach the array:

  foreach($All_cars as $key=>$row) {
  .....
  print_r($All_cars);
  }

So that outputs the whole array.

I tried this but no effect.

 $result = array_unique($All_cars );

I hope you guys can help me... cause I tried this 1 whole day already.

Thanks for your help.

From the DOCS: Note: Note that array_unique() is not intended to work on multi dimensional arrays. — Jeff
– Jeff, Commented Dec 15, 2016 at 10:32
@Jeff Are there another solutions or manipulates to use unique? — David Brett
– David Brett, Commented Dec 15, 2016 at 10:50
check @stackoverflow.com/questions/307674/… this link may help you — ayush
– ayush, Commented Dec 15, 2016 at 10:56

Wolverine · Accepted Answer · 2016-12-16 12:00:56Z

2

Try This

$input = array_map("unserialize", array_unique(array_map("serialize", $input)));

Or

$array = [
    [
        'id' => '123',
        'foo' => 'aaa',
        'bar' => 'bbb'
    ],
    [
        'id' => '123',
        'foo' => 'ccc',
        'bar' => 'ddd'
    ],
    [
        'id' => '567',
        'foo' => 'eee',
        'bar' => 'fff'
    ]
];

$ids = array_column($array, 'id');
$ids = array_unique($ids);
$array = array_filter($array, function ($key) use ($ids) {
    return in_array($key, array_keys($ids));
}, ARRAY_FILTER_USE_KEY);

The result is:

Array
(
    [0] => Array
        (
            [id] => 123
            [foo] => aaa
            [bar] => bbb
        )

    [2] => Array
        (
            [id] => 567
            [foo] => eee
            [bar] => fff
        )

)

Or

if you need to eliminate duplicates on specific keys, such as a mysqli id, here's a simple funciton

function search_array_compact($data,$key){
    $compact = [];
    foreach($data as $row){
        if(!in_array($row[$key],$compact)){
            $compact[] = $row;
        }
    }
    return $compact;
}

Note You can pass an array of keys and add an outer foreach, but it will be 2x slower per additional key.

Or
You can use an associative array.

$temp_array = array();
foreach ($array as &$v) {
    if (!isset($temp_array[$v['name']]))
        $temp_array[$v['name']] =& $v;
}

This creates a temporary array, using $v['name'] as the key. If there is already an element with the same key, it is not added to the temporary array.

You can convert the associative array back to a sequential array, using

$array = array_values($temp_array);

Example code and output: http://codepad.org/zHfbtUrl

edited Dec 16, 2016 at 12:00

Wolverine

1,7001 gold badge15 silver badges18 bronze badges

answered Dec 15, 2016 at 12:18

Ketan Borada

86410 silver badges24 bronze badges

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

6 Comments

David Brett Over a year ago

The second one :p with the array_filter

Wolverine Over a year ago

You need to correct the second method. Swap the variables in the parameter of callback function passed in array_filter to avoid misconception. The order of parameter names should be like function ($value, $key) use ($ids) { and also return in_array($key, array_keys($ids));. Also, you don't need to use ARRAY_FILTER_USE_BOTH if you're only going to use key of the array and ARRAY_FILTER_USE_KEY is enough and remove the $value parameter leaving only $key parameter.

David Brett Over a year ago

@Perumal93 Thanks, I changed it. :)

Ketan Borada Over a year ago

@Perumal93 you can edit answer if sure,i've not tested.

Wolverine Over a year ago

Using ARRAY_FILTER_USE_BOTH when only key of the elements are used rather than values is a kind of quite more memory consumption and using ARRAY_FILTER_USE_KEY is alone enough only if you're going to work with keys because this avoids redundant code and also prevents from memory consumption keeping performance as much simpler as it could.

|

hrishi · Accepted Answer · 2016-12-15 11:15:28Z

0

try this

for($i=0;  $i < count($array); $i++)
{
    for($j=0;  $j < count($array); $j++)
    {
        if($array[$i] == $array[$j])
        {
            unset $array[$i];
        }
    }
}

answered Dec 15, 2016 at 11:15

hrishi

1,6647 gold badges27 silver badges47 bronze badges

Collectives™ on Stack Overflow

Delete duplicate values array

2 Answers 2

6 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related