How to use updateOrCreate?

Question

Laravel

There is an array with screenshots

[ 
     {
        "url": "http://asd.ru/qwe.jpg",
        "uploaded": "true"
     },
 {
        "url": "http://asdas.ru/qwe.jpg",
        "uploaded": "true"
     }
  ]

you need to go through the array and update if there is such a url or create if not. At the same time, not all columns are displayed, but only certain ones ('episode_id', 'content', 'meta').
I do so

$array = [];
foreach ($params['screenshots'] as $screenshot) {
    $array[] = Material::updateOrCreate([
        'content' => $screenshot['url'],
    ], [
        'episode_id' => $params['episode_id'],
        'type_id'    => 2,
        'profile_id' => 2,
        'content'    => $screenshot['url'],
        'meta'       => true,
    ])->select(['episode_id', 'content', 'meta'])->get();
}

return $array;

I get duplicate results

{
  "jsonrpc": "2.0",
  "id": 10,
  "result": [
    [
      {
        "episode_id": 1,
        "content": "http:\/\/asd.ru\/qwe.jpg",
        "meta": true
      },
      {
        "episode_id": 1,
        "content": "123.jpg",
        "meta": true
      }
    ],
    [
      {
        "episode_id": 1,
        "content": "http:\/\/asd.ru\/qwe.jpg",
        "meta": true
      },
      {
        "episode_id": 1,
        "content": "123.jpg",
        "meta": true
      }
    ]
  ]
}

Answer 1

Try like this:

// ...

    $array[] = Material::updateOrCreate([
        'content' => $screenshot['url'],
    ], [
        'episode_id' => $params['episode_id'],
        'type_id'    => 2,
        'profile_id' => 2,
        'content'    => $screenshot['url'],
        'meta'       => true,
    ])->only(['episode_id', 'content', 'meta']); // Используем коллекции

// ...

updateOrCreate returns an object instance, which means that collection methods (Laravel Collections) can be applied to it - in this case, the only method