php api remove duplicate values from different keys json

Question

I have a php script that is outputting a json response that looks something like this ( if it matters, the response below was outputted by a test ajax call ) ---

{
  "type": "the type",
  "typesm": "type of",
  "entries": [
    {
      "title": "title one",
      "body": "Original text",
      "image": "image 1 url",
      "time": "1558532690",
      "meta": {
        "mainColor": "#100a0e",
        "adSpace": null
      }
    },
    {
      "title": "title two",
      "body": "Original text",
      "image": "image 1 url",
      "time": "1558515409",
      "meta": {
        "mainColor": "#100a0e",
        "adSpace": null
      }
    },

So in my entries I have duplicate values for body and image, but everything else seems fine.

In my script I am outputting my values like this for example -

$entries = $result->entries;

foreach ($entries as $ent){
echo $ent->image;
echo $ent->title;
echo $ent->body;
}

My problem is I dont want to output any entries with duplicate data, regardless if the title is different. If the image and body is a duplicate as another entry then I want to skip over it.

How can I achieve this?

EDIT

Exact JSON response structure from php print_r -

stdClass Object
(
    [type] => game
    [typesm] => br
    [entries] => Array
        (
            [0] => stdClass Object
                (
                    [title] => Hang Time Bundle
                    [body] => Score big when you cop the Hang Time Bundle, available now in the Item Shop. Unlock new Styles with Creative Mode Challenges.
                    [image] => https://imageurl.jpeg
                    [time] => 1558532690
                    [meta] => stdClass Object
                        (
                            [mainColor] => #100a0e
                            [adSpace] => 
                        )

                )

            [1] => stdClass Object
                (
                    [title] => Hang Time Set
                    [body] => Score big when you cop the Hang Time Bundle, available now in the Item Shop. Unlock new Styles with Creative Mode Challenges.
                    [image] => https://imageurl.jpeg
                    [time] => 1558515409
                    [meta] => stdClass Object
                        (
                            [mainColor] => #100a0e
                            [adSpace] => 
                        )

                )

Your image values are not the same in the array you post. Should it be? — Andreas
– Andreas, Commented May 22, 2019 at 15:00

Andreas · Accepted Answer · 2019-05-22 15:37:24Z

1

You can use array_column to make the entries array associative and remove the duplicates.

$json = 'json string';
$arr = json_decode($json, true);
$arr['entries'] = array_column($arr['entries'], null, 'body');


foreach ($arr['entries'] as $ent){
    echo $ent['image'];
    echo $ent['title'];
    echo $ent['body'];
}

This way, when you loop to output you only have unique values.

You can also use array_unique but making the array associative can be beneficial in other ways.

If you want to delete duplicates according to both image and body then loop the array and make a compound associative keys.

$json = 'json string';
$arr = json_decode($json, true);
foreach($arr['entries'] as $e){
    $ent[$e['body'] . " " . $e['image']] = $e;
}

$ent is now the new array with unique values of 'entries'

foreach ($ent as $e){
    echo $e['image'];
    echo $e['title'];
    echo $e['body'];
}

edited May 22, 2019 at 15:37

answered May 22, 2019 at 14:58

Andreas

24k7 gold badges34 silver badges75 bronze badges

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

9 Comments

730wavy Over a year ago

I tried both your examples and wasnt able to output anything anymore

Andreas Over a year ago

There is no output included in my answers. I figured you knew how to do that.

Andreas Over a year ago

Included output as in your question.

Andreas Over a year ago

Both codes work fine with a correct json. I hope you didn't expect that you posted was going to work? 3v4l.org/hdP0h

Andreas Over a year ago

Based on only body is above the line, the array_column part

|

Collectives™ on Stack Overflow

php api remove duplicate values from different keys json

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related