PHP Array removing the duplicate key value and displaying only one [duplicate]

Question

Array
(
    [0] => Array
        (
            [user_id] => 78
            [post_id] => 3
            [post_user_added_id] => 2
        )

    [1] => Array
        (
            [user_id] => 76
            [post_id] => 8
            [post_user_added_id] => 16
        )

    [2] => Array
        (
            [user_id] => 78
            [post_id] => 9
            [post_user_added_id] => 12
        )

    [3] => Array
        (
            [user_id] => 76
            [post_id] => 9
            [post_user_added_id] => 15
        )

     [4] => Array
         (
             [user_id] => 77
             [post_id] => 9
             [post_user_added_id] => 15
         )

)

The idea here is that when there is a duplicate user_id, it will just display only one? This is the expected result:

 Array
 (
      [2] => Array
          (
             [user_id] => 78
             [post_id] => 9
             [post_user_added_id] => 12
           )

        [3] => Array
            (
                [user_id] => 76
                [post_id] => 9
                [post_user_added_id] => 15
            )

         [4] => Array
             (
                 [user_id] => 77
                 [post_id] => 9
                 [post_user_added_id] => 15
             )

    )

The reason why [2] key instead of [0] key or [1] key instead of [3] is displayed because I want to get the bottom key of the duplicate key. It's kinda hard to explain but I hope you understood the scenario or the output that I expected.

Your help would be greatly appreciated! Thanks! :)

What have you tried so far? - Please post your code and make clear with which point exactly you've hit the road-block. — hakre
– hakre, Commented Apr 24, 2012 at 15:35
I didn't try anything since I really don't know the logic on performing my expected output. — PinoyStackOverflower
– PinoyStackOverflower, Commented Apr 24, 2012 at 15:35
This website is for programmers, so please see the FAQ which questions to ask here. — hakre
– hakre, Commented Apr 24, 2012 at 15:36
I'm a programmer, that's why I came up with that PHP array values. I'm just asking how to remove duplicate values on an array. — PinoyStackOverflower
– PinoyStackOverflower, Commented Apr 24, 2012 at 15:38

reflexiv · Accepted Answer · 2013-07-08 01:17:11Z

8

Try this :

foreach($arr as $k => $v) 
{
    foreach($arr as $key => $value) 
    {
        if($k != $key && $v['user_id'] == $value['user_id'])
        {
             unset($arr[$k]);
        }
    }
}
print_r($arr);

edited Jul 8, 2013 at 1:17

reflexiv

1,7211 gold badge21 silver badges24 bronze badges

answered Apr 24, 2012 at 15:38

d4rkpr1nc3

1,82713 silver badges16 bronze badges

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

1 Comment

PinoyStackOverflower Over a year ago

The previous one that you left was working perfectly! no need to array_reverse() it since I want to get the bottom key of the duplicate key value. :)

Baba · Accepted Answer · 2012-04-24 16:04:38Z

1

Try

$array = Array (
        "0" => Array (
                "user_id" => 78,
                "post_id" => 3,
                "post_user_added_id" => 2 
        ),

        "1" => Array (
                "user_id" => 76,
                "post_id" => 8,
                "post_user_added_id" => 16 
        ),

        "2" => Array (
                "user_id" => 78,
                "post_id" => 9,
                "post_user_added_id" => 12 
        ),

        "3" => Array (
                "user_id" => 76,
                "post_id" => 9,
                "post_user_added_id" => 15 
        ),

        "4" => Array (
                "user_id" => 77,
                "post_id" => 9,
                "post_user_added_id" => 15 
        ) 
);
$keys = array ();

// Get Position
foreach ( $array as $key => $value ) {
    $keys [$value ['user_id']] = $key;
}

// Remove Duplicate
foreach ( $array as $key => $value ) {
    if (! in_array ( $key, $keys )) {
        unset ( $array [$key] );
    }
}
var_dump ( $array );

Output

array
  2 => 
    array
      'user_id' => int 78
      'post_id' => int 9
      'post_user_added_id' => int 12
  3 => 
    array
      'user_id' => int 76
      'post_id' => int 9
      'post_user_added_id' => int 15
  4 => 
    array
      'user_id' => int 77
      'post_id' => int 9
      'post_user_added_id' => int 15

edited Apr 24, 2012 at 16:04

answered Apr 24, 2012 at 15:38

Baba

95.3k29 gold badges172 silver badges222 bronze badges

1 Comment

mpratt Over a year ago

You might need to array_reverse the initial array, since that is not the desired output.

mpratt · Accepted Answer · 2012-04-24 15:41:24Z

0

You can use a foreach loop to overwrite the user_id. I think something like this should work

$new = array();
foreach ($array as $value)
{
    $new[$value['user_id']] = $value;
}
print_r($new);

answered Apr 24, 2012 at 15:41

mpratt

1,60813 silver badges21 bronze badges

Comments

Robert Sinclair · Accepted Answer · 2019-01-07 04:47:52Z

Following worked for me, for cleaning the following:

$arr = array(

    array("ID"=>"234"),
    array("ID"=>"235"),
    array("ID"=>"236"),
    array("ID"=>"236"),
    array("ID"=>"234"),
    );

Code:

for ($i=0; $i <count($arr) ; $i++) {

    $distinct_id = $arr[$i]["ID"]; // this is the ID for which we want to eliminate the duplicates
    $position = $i; // position of that array (so we ignore it)
    $unset_arr = array(); // these duplicate entries will be removed

    // Collect list of duplicates to remove
    for ($y=0; $y <count($arr) ; $y++) {

        // Skip the position of the array that we're checking (we want to remove duplicate not the original)
        if($y == $position)
            continue;

        // If found remove and reset keys
        if($arr[$y]["ID"] == $distinct_id) {
            $unset_arr[] = $y;
        }

    }

    // Remove IDs collected in the loop above
    foreach ($unset_arr as $k) {
        unset($arr[$k]);
    }

    // Reset keys
    $arr = array_values($arr);

}

(reverse the array if you want to remove newer duplicates instead of older ones)

Collectives™ on Stack Overflow

PHP Array removing the duplicate key value and displaying only one [duplicate]

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Linked

Related