PHP remove all objects but one with same property from Array

Question

Using Eloquent, I want to remove 2 objects from the $outputs array with 'Title' B and keep only one.

$outputs has the following information:

[
    {
        "Title": "A",
        "Publication date": "2013",
    },
    {
        "Title": "B",
        "Publication date": "2010",
    },
    {
        "Title": "B",
        "Publication date": "2999",
    },
    {
        "Title": "B",
        "Publication date": "5555",
    },
];

I know there are plenty of posts about this but I couldn't find a way to do it myself. Any help will be appreciated.

Just made the question a bit clearer to understand. Adding some code would be a good idea @João Domingues — Plamen G
– Plamen G, Commented Jun 26, 2019 at 13:34

newUserName02 · Accepted Answer · 2019-06-26 02:31:54Z

1

If this is for an array/collection, and not an Eloquent query, you can use the collection keyBy method to get unique values.

https://laravel.com/docs/5.8/collections#method-keyby

$data = [
    [
        "Title" => "A",
        "Publication date" => "2013",
    ],
    [
        "Title" => "B",
        "Publication date" => "2010",
    ],
    [
        "Title" => "B",
        "Publication date" => "2999",
    ],
    [
        "Title" => "B",
        "Publication date" => "5555",
    ],
];

$collection = collect($data)->keyBy('Title');

Then your output will look like this:

Collection {#1389 
  #items: array:2 [
    "A" => array:2 [
      "Title" => "A"
      "Publication date" => "2013"
    ]
    "B" => array:2 [
      "Title" => "B"
      "Publication date" => "5555"
    ]
  ]
}

The keyBy method will give you the last item in the collection for each Title, so you can sort the collection before calling keyBy if you want to get specific items:

// get each Title with the highest Publication date
$collection = collect($data)->sortBy('Publication date')->keyBy('Title');

// get each Title with the lowest Publication date
$collection = collect($data)->sortByDesc('Publication date')->keyBy('Title');

If you want to get back an array without the keys "A" and "B" then you can do this:

$collection = collect($data)->keyBy('Title')->values()->toArray();

Output:

array:2 [
  0 => array:2 [
    "Title" => "A"
    "Publication date" => "2013"
  ]
  1 => array:2 [
    "Title" => "B"
    "Publication date" => "5555"
  ]
]

edited Jun 26, 2019 at 2:31

answered Jun 26, 2019 at 2:23

newUserName02

1,70814 silver badges20 bronze badges

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

1 Comment

João Domingues Over a year ago

Thank you! I was doing crazy loops trying to remove / push , tried everything. Only 1 line of code does all the thing lol thank you.

Jesus Erwin Suarez · Accepted Answer · 2019-06-26 00:44:58Z

0

You can do this by using destinct and groupBy in your query.

answered Jun 26, 2019 at 0:44

Jesus Erwin Suarez

1,59517 silver badges17 bronze badges

1 Comment

João Domingues Over a year ago

this is an array i've built couldn't use distinct because data is coming from different sources

Collectives™ on Stack Overflow

PHP remove all objects but one with same property from Array

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related