How to extract remote xml items and write them to mysql
Hi. I got this remote xml that looks like the following sample. The number of videos are changing depending on xml that i use. I want to know how i can extract individual video information and set them as variable and write them to mysql. i be happy if some one show me how i can do this.Thanks
Code:
<?xml version="1.0" encoding="utf-8" ?>
- <ut_response status="ok">
- <video_list>
<total>33</total>
- <video>
<author>universalmusicgroup</author>
<id>6XENujsU3Wg</id>
<title>Shania Twain - You're Still The One: Blue Tint Version</title>
<length_seconds>208</length_seconds>
<rating_avg>4.88</rating_avg>
<rating_count>1741</rating_count>
<description>Music video by Shania Twain performing You're Still The One: Blue Tint Version with Shania Twain, R.J. Lange, Robert John "Mutt" Lange (C) 1998 Mercury Records, a Division of UMG Recordings, Inc.</description>
<view_count>615375</view_count>
<upload_time>1173705680</upload_time>
<comment_count>539</comment_count>
<tags>Shania Twain You're Still The One Country Mercury Nashville R.J. Lange Robert John "Mutt"</tags>
<url>http://www.youtube.com/?v=6XENujsU3Wg</url>
<thumbnail_url>http://img.youtube.com/vi/6XENujsU3Wg/default.jpg</thumbnail_url>
<embed_id>KD83gDBiCSFlUZz5yRJn5Eb0HRHg8u7iLK_1qXVk-dM=</embed_id>
<embed_status>not_allowed</embed_status>
</video>
.......
</video_list>
</ut_response>