0

I am trying to extract data from this Youtube XML file - http://www.youtube.com/feeds/videos.xml?user=latenight

I can get the easy bits by using this code

<id>yt:video:dLUfTS4TxrQ</id>
<title>Sia: Cheap Thrills</title>
<published>2016-01-28T20:04:03+00:00</published>


$feed  = simplexml_load_file("http://www.youtube.com/feeds/videos.xml?user=latenight");

echo $feed->entry[0]->title;
echo $feed->entry[0]->id;
echo $feed->entry[0]->published;

How do you extract the data within media:thumbnail, media:description, media:starRating, media:statistics using PHP SimpleXML?

<media:group>

<media:title>Sia: Cheap Thrills</media:title>
<media:content url="https://www.youtube.com/v/dLUfTS4TxrQ?version=3" type="application/x-shockwave-flash" width="640" height="390"/>
<media:thumbnail url="https://i1.ytimg.com/vi/dLUfTS4TxrQ/hqdefault.jpg" width="480" height="360"/>
<media:description>
Music guest Sia performs "Cheap Thrills" for the Tonight Show audience. Subscribe NOW to The Tonight Show Starring Jimmy Fallon: http://bit.ly/1nwT1aN Watch The Tonight Show Starring Jimmy Fallon Weeknights 11:35/10:35c Get more Jimmy Fallon: Follow Jimmy: http://Twitter.com/JimmyFallon Like Jimmy: https://Facebook.com/JimmyFallon Get more The Tonight Show Starring Jimmy Fallon: Follow The Tonight Show: http://Twitter.com/FallonTonight Like The Tonight Show: https://Facebook.com/FallonTonight The Tonight Show Tumblr: http://fallontonight.tumblr.com/ Get more NBC: NBC YouTube: http://bit.ly/1dM1qBH Like NBC: http://Facebook.com/NBC Follow NBC: http://Twitter.com/NBC NBC Tumblr: http://nbctv.tumblr.com/ NBC Google+: https://plus.google.com/+NBC/posts The Tonight Show Starring Jimmy Fallon features hilarious highlights from the show including: comedy sketches, music parodies, celebrity interviews, ridiculous games, and, of course, Jimmy's Thank You Notes and hashtags! You'll also find behind the scenes videos and other great web exclusives. Sia: Cheap Thrills http://www.youtube.com/fallontonight
</media:description>

<media:community>
    <media:starRating count="16185" average="4.86" min="1" max="5"/>
    <media:statistics views="648221"/>
</media:community>

</media:group>
Frocca
  • 9
  • 2
  • Possible duplicate of [SimpleXML: Working with XML containing namespaces](http://stackoverflow.com/questions/2014835/simplexml-working-with-xml-containing-namespaces) – michi Feb 02 '16 at 21:59

1 Answers1

1

I'm not sure how you would do it using SimpleXML - it is quite straightforward using standard DOMDocument ~ you could get fancy and use an XPath query if you wanted to target specific nodes directly.

The following uses the namespace media to target all nodes prefixed by media - then iterates through the collection. This could be done in other ways but hopefully it will help get started?!

$url='https://www.youtube.com/feeds/videos.xml?user=latenight';
/* create DOMDocument object*/
$dom=new DOMDocument;

/* load external file directly */
$dom->load( $url );

/* to get all elements based upon namespace and iterate through */
$col=$dom->getElementsByTagNameNS('http://search.yahoo.com/mrss/','*');
/* if the above failed, do nothing or display a message perhaps */
if( $col ){
    /* loop through entire collection */
    foreach( $col as $node ){

        /* this shows pretty much everything apart from node attributes which you probably want to collect / process */
        #echo 'Prefix:'.$node->prefix .' Tag:'.$node->tagName.' Value:'.$node->nodeValue.BR;

        if( $node->tagName==$node->prefix.':description' ) echo 'DESCRIPTION:'.$node->nodeValue;

        if( $node->attributes->length > 0 ) {
            if( $node->tagName==$node->prefix.':starRating' && $node->hasAttribute('count') ) echo 'COUNT:'.$node->getAttribute('count');
            if( $node->tagName==$node->prefix.':starRating' && $node->hasAttribute('average') ) echo 'AVERAGE:'.$node->getAttribute('average');
            if( $node->tagName==$node->prefix.':statistics' && $node->hasAttribute('views') ) echo 'STATISTICS:'.$node->getAttribute('views');  
            /* etc */
        }
    }
}
Professor Abronsius
  • 33,063
  • 5
  • 32
  • 46