How to detect duplicate values in multidimensional associative array?

Question

I have an associative multidimensional array:

Array
(
    [0] => Array
        (
            [customer_name] => John Dow
            [customer_email] => [email protected]
            [customer_mobile] => 1236547895
            [birth_date] => 12/1/1996
            [status] => Enable
        )

    [1] => Array
        (
            [customer_name] => Alex
            [customer_email] => [email protected]
            [customer_mobile] => 4563214785
            [birth_date] => 19/1/1996
            [status] => Enable
        )

    [2] => Array
        (
            [customer_name] => Arina
            [customer_email] => [email protected]
            [customer_mobile] => 963214785
            [birth_date] => 25/1/1996
            [status] => Enable
        )

    [3] => Array
        (
            [customer_name] => Atom
            [customer_email] => [email protected]
            [customer_mobile] => 5214789632
            [birth_date] => 12/1/1998
            [status] => Enable
        )

    [4] => Array
        (
            [customer_name] => Jennifer
            [customer_email] => [email protected]
            [customer_mobile] => 4563214785
            [birth_date] => 12/2/1996
            [status] => Enable
        )
)

Now I want to inspect similar values in customer_mobile and customer_email from each other to reduce redundancies. Contact number and email addresses must be non-redundant.

So please guide me, how can I achieve this? Thanks :)

i don't want any result . i just want to check if any customer have duplicate contact number as well as email address. it return as flag - true means this array have contains redundancy — Devendra Singh
– Devendra Singh, Commented Jun 17, 2017 at 12:59
you wrote it return as flag - one flag for all items OR for each item separately? — RomanPerekhrest
– RomanPerekhrest, Commented Jun 17, 2017 at 13:03
on flag for all item - if 1 contact number repeated 2 or more times as well as email. entire array will be discarded — Devendra Singh
– Devendra Singh, Commented Jun 17, 2017 at 13:13

FirstOne · Accepted Answer · 2017-06-17 13:44:58Z

4

Since you don't need to know which, but only if, you could use array_column + array_unique: (run)

$cm = array_column($arr, 'customer_mobile');
if($cm != array_unique($cm)){
    echo 'There are duplicates in customer_mobile';
}

$ce = array_column($arr, 'customer_email');
if($cm != array_unique($ce)){
    echo 'There are duplicates in customer_email';
}

If you need to match both email and mobile, do it in the same if:

if($cm != array_unique($cm) && $ce != array_unique($ce)){
    echo 'There are duplicates in both customer_mobile and customer_email';
}

edited Jun 17, 2017 at 13:44

answered Jun 17, 2017 at 13:09

FirstOne

6,2857 gold badges28 silver badges48 bronze badges

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

Comments

kRicha · Accepted Answer · 2017-06-17 13:10:40Z

Simple solution is:

<?php

$data = [
  [
    'name' => 'name 1',
    'phone' => '12341234',
    'email' => '[email protected]'
  ],
  [
    'name' => 'name 2',
    'phone' => '12341234',
    'email' => '[email protected]'
  ],
  [
    'name' => 'name 3',
    'phone' => '4322342',
    'email' => '[email protected]'
  ],
  [
    'name' => 'name 4',
    'phone' => '1234123423',
    'email' => '[email protected]'
  ],
  [
    'name' => 'name 5',
    'phone' => '12341266634',
    'email' => '[email protected]'
  ],
];

$phones = [];
$emails = [];
foreach ($data as $key => $contact) {
  if (array_search($contact['phone'], $phones) !== false || array_search($contact['email'], $emails) !== false) {
    unset($data[$key]);
  } else {
    $phones[] = $contact['phone'];
    $emails[] = $contact['email'];
  }
}

var_dump($data);

and in result you'll get:

array(3) {
  [0] =>
  array(3) {
    'name' =>
    string(6) "name 1"
    'phone' =>
    string(8) "12341234"
    'email' =>
    string(12) "[email protected]"
  }
  [2] =>
  array(3) {
    'name' =>
    string(6) "name 3"
    'phone' =>
    string(7) "4322342"
    'email' =>
    string(13) "[email protected]"
  }
  [4] =>
  array(3) {
    'name' =>
    string(6) "name 5"
    'phone' =>
    string(11) "12341266634"
    'email' =>
    string(18) "[email protected]"
  }
}

this is just example.

LF-DevJourney · Accepted Answer · 2017-06-17 13:14:28Z

0

Try this with foreach. You need only traverse the array one time, use the email and mobile as unique key, the elements with the same unique key will only keep the last one. If you want the results use number index, use array_values() on the $result.

$result = [];
foreach($array as $v)
{
  $result[$v['customer_email'] . $v['customer_mobile']] = $v;
}

answered Jun 17, 2017 at 13:14

LF-DevJourney

28.7k30 gold badges170 silver badges321 bronze badges

Comments

Kamil Kiełczewski · Accepted Answer · 2017-06-17 13:23:24Z

0

You can do it in this way (i generate code from head so it can have bug - but idea should be clear) (i assume you array name is $persons):

$emails = [];
$mobiles = [];

$discard = false;
foreach($persons as $person) 
{
   $email = $person['customer_email'];

   if(!isset($emails[$email])) {
       $emails[$email] = $person;
   } else {
      $emails[$email]['redundant_email']=true;
      $person['redundant_email']=true;
      $discard = true;
   }

   $mobile = $person['customer_mobile'];

   if(!isset($mobiles[$mobile])) {
       $mobiles[$mobile] = $person;
   } else {
       $mobiles[$mobile]['redundant_mobile']=true;
       $person['redundant_mobile']=true;
       $discard = true;
   }
}

As result each person with redundat mobile or email have set field redundant_email or redundant_mobile to true. The variable $discard=true says that array is redundant.

edited Jun 17, 2017 at 13:23

answered Jun 17, 2017 at 12:58

Kamil Kiełczewski

93.7k34 gold badges401 silver badges375 bronze badges

3 Comments

Devendra Singh Over a year ago

there is no any value in array..!

Devendra Singh Over a year ago

if 1 contact number repeated 2 or more times as well as email. entire array will be discarded.. how can i achienve this?

Kamil Kiełczewski Over a year ago

@DevendraSingh - again I make correction due to your new requirements - now you have boolean answer in $discard variable as well as 'flags' in redundant persons

DukesNuz · Accepted Answer · 2020-04-07 12:49:05Z

0

Here is my solution and is working fine.

    $name = array_column($array, 'name');
    $filteredKeys = array_unique($name);

    foreach (array_keys($filteredKeys) as $key => $value) {
    $filtered [] = $array[$value];
    }
      return  $filtered;
    }

answered Apr 7, 2020 at 12:49

DukesNuz

971 silver badge9 bronze badges

1 Comment

anpami Over a year ago

There are two closing curly brackets, but only one opening; something seems to be missing here!

user7941334 · Accepted Answer · 2017-06-17 13:32:53Z

-1

My answer would be, that you should not do this in PHP at all. In your presented case the data should be checked/validated/filtered only on the database side. If there are duplicates, then you don't have to fetch data at all!

Run a query to just check for redundancies in db. Only if no redundancy fetch the data.

If there is a lot of data, then you'll spare a big data fetch and loop through data from the beginning.

Good luck.

answered Jun 17, 2017 at 13:32

user7941334

Collectives™ on Stack Overflow

How to detect duplicate values in multidimensional associative array?

6 Answers 6

Comments

Comments

Comments

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related