simplexml学习笔记---用simplexml读入一个xml文档并插入到数据库中
最近在网上找到了一份xspf文件(下载),用simple xml 将其location和title存入到数据库中。源码下载),因为文件中的空格太多,先用正则表达式将空格去掉,然后用simplexml解析,存到数据库之中。
正则表达式真是太神奇了。。。。
HTML+PHP语言: 高亮代码由发芽网提供
<?php
header("content-type: text/html; charset=utf-8;");
//header("Content-type: text/html; charset:utf-8");
// $filename = '1.xml';
// ini_set(‘display_errors’, true);
// error_reporting(E_ALL);
$c = file_get_contents('1.xml');
// /\S+/ w
//
//$pattern = "/<.*>/";
//$pattern = "/[u4e00-u9fa5]+/";
//$pattern = '/[一-龠]+/';
//$pattern = '/<.*>*[一-龠]*/';
$pattern = '/<.*>[一-龠]*/';
$matches = '';
if(preg_match_all($pattern,$c,$matches))
{
//print_r($matches[0]) ;
$str="";
foreach ($matches[0] as $key => $value) {
# code...
$str .= $value;
}
//echo $str;
//print_r($str);
//$simxml = simplexml_load_file($str);
$simxml = simplexml_load_string($str);
//print_r($simxml);
echo $simxml->trackList->track[0]->title;
echo $simxml->trackList->track[0]->location;
//insert into mysql database
$handle = mysql_connect("127.0.0.1","root","123a123a");
mysql_select_db("yz");
foreach ($simxml->trackList->track as $value) {
$query = 'insert into track(location,tvTitle) values("'.$value->location.'","'.$value->title.'");';
mysql_query($query) or die(mysql_error());
}
echo "v";
mysql_close($handle);
}
?>
<html>
<body>
<form action="" method="post">
<input type="hidden" name="hid" value='<?php
if( isset($_POST["sub"]) ){
echo "done";
}else{
echo "no";
}
?>'/>
<input type="submit" name="sub" value="insert" />
</form>
</body>
</html>
header("content-type: text/html; charset=utf-8;");
//header("Content-type: text/html; charset:utf-8");
// $filename = '1.xml';
// ini_set(‘display_errors’, true);
// error_reporting(E_ALL);
$c = file_get_contents('1.xml');
// /\S+/ w
//
//$pattern = "/<.*>/";
//$pattern = "/[u4e00-u9fa5]+/";
//$pattern = '/[一-龠]+/';
//$pattern = '/<.*>*[一-龠]*/';
$pattern = '/<.*>[一-龠]*/';
$matches = '';
if(preg_match_all($pattern,$c,$matches))
{
//print_r($matches[0]) ;
$str="";
foreach ($matches[0] as $key => $value) {
# code...
$str .= $value;
}
//echo $str;
//print_r($str);
//$simxml = simplexml_load_file($str);
$simxml = simplexml_load_string($str);
//print_r($simxml);
echo $simxml->trackList->track[0]->title;
echo $simxml->trackList->track[0]->location;
//insert into mysql database
$handle = mysql_connect("127.0.0.1","root","123a123a");
mysql_select_db("yz");
foreach ($simxml->trackList->track as $value) {
$query = 'insert into track(location,tvTitle) values("'.$value->location.'","'.$value->title.'");';
mysql_query($query) or die(mysql_error());
}
echo "v";
mysql_close($handle);
}
?>
<html>
<body>
<form action="" method="post">
<input type="hidden" name="hid" value='<?php
if( isset($_POST["sub"]) ){
echo "done";
}else{
echo "no";
}
?>'/>
<input type="submit" name="sub" value="insert" />
</form>
</body>
</html>
XML语言: Codee#28050
<?xml version="1.0" encoding="UTF-8"?>
<playlist xmlns="http://xspf.org/ns/0/" xmlns:vlc="http://www.videolan.org/vlc/playlist/ns/0/" version="1"><title>播放列表</title><trackList><track><location>http://zb.v.qq.com:1863/?progid=1975434150</location>
<title>浙江卫视高清
</title><extension application="http://www.videolan.org/vlc/playlist/0"><vlc:id>0</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=3900155972</location>
<title>东方卫视高清
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>1</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2220552576</location>
<title>深圳卫视高清
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>2</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=857894899</location>
<title>广东卫视高清
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>3</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2453801339</location>
<title>四川卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>4</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2907109968</location>
<title>浙江卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>5</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=1128831868</location>
<title>湖北卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>6</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=3661744838</location>
<title>东方卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>7</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=623043810</location>
<title>安徽卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>8</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2309309351</location>
<title>深圳卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>9</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=1926463423</location>
<title>珠江频道
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>10</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2084914015</location>
<title>广东卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>11</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=3006271240</location>
<title>辽宁卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>12</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=877636586</location>
<title>青海卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>13</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2905421066</location>
<title>重庆卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>14</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=3660187036</location>
<title>山东卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>15</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2739752321</location>
<title>陕西卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>16</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=708402866</location>
<title>云南卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>17</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=3051487004</location>
<title>贵州卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>18</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=4172356212</location>
<title>河南卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>19</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=830075195</location>
<title>天津卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>20</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=974433428</location>
<title>广西卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>21</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=1000637964</location>
<title>东南卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>22</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=3444760127</location>
<title>甘肃卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>23</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=3778086045</location>
<title>宁夏卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>24</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2342060367</location>
<title>内蒙古卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>25</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2280918693</location>
<title>广西综艺
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>26</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2136314174</location>
<title>英语辅导
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>27</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=1249794075</location>
<title>嘉佳卡通
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>28</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2552061131</location>
<title>CCTV中学生
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>29</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=4035478592</location>
<title>广东公共
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>30</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2631736979</location>
<title>广东新闻
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>31</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=3727832148</location>
<title>长沙政法
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>32</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=4122776769</location>
<title>长沙新闻
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>33</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2092781730</location>
<title>深圳财经
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>34</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=1926463423</location>
<title>珠江频道
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>35</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2084914015</location>
<title>广东卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>36</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=1249794075</location>
<title>嘉佳卡通
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>37</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=4035478592</location>
<title>广东公共
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>38</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2631736979</location>
<title>广东新闻
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>39</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=3956944389</location>
<title>英雄联盟职业联赛
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>40</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=931734290</location>
<title>DNF官方电视台
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>41</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=1980972519</location>
<title>GTV游戏竞技
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>42</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2584831218</location>
<title>NEOTV星际2
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>43</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=4050426117</location>
<title>NEOTV-英雄联盟
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>44</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2674956498</location>
<title>ScnTV频道一
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>45</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=1424066668</location>
<title>ScnTV频道二
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>46</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=1258215255</location>
<title>1006TV
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>47</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
</trackList>
</playlist>
<playlist xmlns="http://xspf.org/ns/0/" xmlns:vlc="http://www.videolan.org/vlc/playlist/ns/0/" version="1"><title>播放列表</title><trackList><track><location>http://zb.v.qq.com:1863/?progid=1975434150</location>
<title>浙江卫视高清
</title><extension application="http://www.videolan.org/vlc/playlist/0"><vlc:id>0</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=3900155972</location>
<title>东方卫视高清
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>1</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2220552576</location>
<title>深圳卫视高清
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>2</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=857894899</location>
<title>广东卫视高清
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>3</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2453801339</location>
<title>四川卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>4</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2907109968</location>
<title>浙江卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>5</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=1128831868</location>
<title>湖北卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>6</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=3661744838</location>
<title>东方卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>7</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=623043810</location>
<title>安徽卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>8</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2309309351</location>
<title>深圳卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>9</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=1926463423</location>
<title>珠江频道
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>10</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2084914015</location>
<title>广东卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>11</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=3006271240</location>
<title>辽宁卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>12</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=877636586</location>
<title>青海卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>13</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2905421066</location>
<title>重庆卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>14</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=3660187036</location>
<title>山东卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>15</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2739752321</location>
<title>陕西卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>16</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=708402866</location>
<title>云南卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>17</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=3051487004</location>
<title>贵州卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>18</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=4172356212</location>
<title>河南卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>19</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=830075195</location>
<title>天津卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>20</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=974433428</location>
<title>广西卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>21</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=1000637964</location>
<title>东南卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>22</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=3444760127</location>
<title>甘肃卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>23</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=3778086045</location>
<title>宁夏卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>24</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2342060367</location>
<title>内蒙古卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>25</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2280918693</location>
<title>广西综艺
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>26</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2136314174</location>
<title>英语辅导
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>27</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=1249794075</location>
<title>嘉佳卡通
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>28</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2552061131</location>
<title>CCTV中学生
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>29</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=4035478592</location>
<title>广东公共
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>30</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2631736979</location>
<title>广东新闻
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>31</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=3727832148</location>
<title>长沙政法
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>32</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=4122776769</location>
<title>长沙新闻
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>33</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2092781730</location>
<title>深圳财经
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>34</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=1926463423</location>
<title>珠江频道
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>35</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2084914015</location>
<title>广东卫视
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>36</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=1249794075</location>
<title>嘉佳卡通
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>37</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=4035478592</location>
<title>广东公共
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>38</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2631736979</location>
<title>广东新闻
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>39</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=3956944389</location>
<title>英雄联盟职业联赛
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>40</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=931734290</location>
<title>DNF官方电视台
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>41</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=1980972519</location>
<title>GTV游戏竞技
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>42</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2584831218</location>
<title>NEOTV星际2
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>43</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=4050426117</location>
<title>NEOTV-英雄联盟
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>44</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=2674956498</location>
<title>ScnTV频道一
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>45</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=1424066668</location>
<title>ScnTV频道二
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>46</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
<track>
<location>http://zb.v.qq.com:1863/?progid=1258215255</location>
<title>1006TV
</title>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>47</vlc:id>
<vlc:option>network-caching=1000</vlc:option>
</extension>
</track>
</trackList>
</playlist>
simplexml学习笔记---用simplexml读入一个xml文档并插入到数据库中
http://blog.soul11201.com/2014/02/12/simplexml-simplexmlxml/