How to transform json data to a comma separated php string?

Question

Let's say i have this json data. How to transform the "tags" to a string like

$tags = "Rihanna, We, Found, Love, (Explicit), Def, Jam, Records, Pop"; ?

{ "apiVersion" : "2.1",
      "data" : { "items" : [ { "accessControl" : { "autoPlay" : "allowed",
                    "comment" : "allowed",
                    "commentVote" : "allowed",
                    "embed" : "allowed",
                    "list" : "allowed",
                    "rate" : "allowed",
                    "syndicate" : "allowed",
                    "videoRespond" : "allowed"
                  },
                "aspectRatio" : "widescreen",
                "category" : "Music",
                "tags" : [ "Rihanna",
                    "We",
                    "Found",
                    "Love",
                    "(Explicit)",
                    "Def",
                    "Jam",
                    "Records",
                    "Pop"
                  ],
                "title" : "Rihanna - We Found Love ft. Calvin Harris"
              } ],
          "itemsPerPage" : 1,
          "startIndex" : 1,
          "totalItems" : 859012,
          "updated" : "2012-04-04T20:32:26.170Z"
        }
    }

For the title as example, the script looks like this:

$content = $this->getDataFromUrl($feedURL);
$content = json_decode($content,true);

$videosList = $content['data']['items'];

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

$videosDatas['videos'][$i]['title'] = $videosList[$i]['title'];

}

Do you want tags written to $videosDatas['videos'][$i]['tags']? — iambriansreed
– iambriansreed, Commented Apr 4, 2012 at 21:01

Chris Esplin · Accepted Answer · 2012-04-04 22:43:24Z

10

It looks like you need implode(). The function would be something like...

$tags = implode(', ', $videosDatas['videos'][$i]['tags']);

edited Apr 4, 2012 at 22:43

answered Apr 4, 2012 at 20:47

Chris Esplin

8929 silver badges16 bronze badges

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

1 Comment

binarious Over a year ago

you need to change $tags to 'tags'

binarious · Accepted Answer · 2012-04-04 20:46:18Z

2

$comma_sep_string = implode(', ' , $videosDatas['videos'][$i]['tags']);

answered Apr 4, 2012 at 20:46

binarious

4,58828 silver badges35 bronze badges

Comments

iambriansreed · Accepted Answer · 2012-04-04 20:59:46Z

0

Try:

foreach($videosList as $i=>$video){
    $videosDatas['videos'][$i]['title'] = $video->title;
    $tags = implode(', ',$video->tags);
    $videosDatas['videos'][$i]['tags'] = $tags;
}

In place of your code:

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

$videosDatas['videos'][$i]['title'] = $videosList[$i]['title'];

}

edited Apr 4, 2012 at 20:59

answered Apr 4, 2012 at 20:52

iambriansreed

22.3k6 gold badges66 silver badges81 bronze badges

Collectives™ on Stack Overflow

How to transform json data to a comma separated php string?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related