<?xml version="1.0" encoding="utf-8"?>
<item>
<list name="Intro something.Please custom your title text content" videotitle="Matrix film demo 1" link="video/ani1.flv" >
<thumb>thumb/1.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Final matrix demo 2" link="video/ani2.flv" >
<thumb>thumb/2.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Matrix film demo 1" link="video/ani1.flv" >
<thumb>thumb/1.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Final matrix demo 2" link="video/ani2.flv" >
<thumb>thumb/2.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Matrix film demo 1" link="video/ani1.flv" >
<thumb>thumb/1.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Final matrix demo 2" link="video/ani1.flv" >
<thumb>thumb/2.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Matrix film demo 1" link="video/ani1.flv" >
<thumb>thumb/1.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Final matrix demo 2" link="video/ani1.flv" >
<thumb>thumb/2.jpg</thumb>
</list>
</item>
<item>
<list name="Intro something.Please custom your title text content" videotitle="Matrix film demo 1" link="video/ani1.flv" >
<thumb>thumb/1.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Final matrix demo 2" link="video/ani2.flv" >
<thumb>thumb/2.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Matrix film demo 1" link="video/ani1.flv" >
<thumb>thumb/1.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Final matrix demo 2" link="video/ani2.flv" >
<thumb>thumb/2.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Matrix film demo 1" link="video/ani1.flv" >
<thumb>thumb/1.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Final matrix demo 2" link="video/ani1.flv" >
<thumb>thumb/2.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Matrix film demo 1" link="video/ani1.flv" >
<thumb>thumb/1.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Final matrix demo 2" link="video/ani1.flv" >
<thumb>thumb/2.jpg</thumb>
</list>
</item>
$xml=<<<XML
<?xml version="1.0" encoding="utf-8"?>
<item>
<list name="Intro something.Please custom your title text content" videotitle="Matrix film demo 1" link="video/ani1.flv" >
<thumb>thumb/1.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Final matrix demo 2" link="video/ani2.flv" >
<thumb>thumb/2.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Matrix film demo 1" link="video/ani1.flv" >
<thumb>thumb/1.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Final matrix demo 2" link="video/ani2.flv" >
<thumb>thumb/2.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Matrix film demo 1" link="video/ani1.flv" >
<thumb>thumb/1.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Final matrix demo 2" link="video/ani1.flv" >
<thumb>thumb/2.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Matrix film demo 1" link="video/ani1.flv" >
<thumb>thumb/1.jpg</thumb>
</list>
<list name="Intro something.Please custom your title text content" videotitle="Final matrix demo 2" link="video/ani1.flv" >
<thumb>thumb/2.jpg</thumb>
</list>
</item>
XML;
$obj=simplexml_load_string($xml);
foreach($obj->list as $v){
$arr=(array)$v->attributes();
$arr['@attributes']['thumb']=(string)$v->thumb;
$list[]=$arr['@attributes'];
};
print_r($list);帮你把xml里面的数据取出来了,接下来操作数据入库该知道怎么办了吧
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
// make foo the current db
mysql_select_db('foo', $lnk) or die ('Can\'t use foo : ' . mysql_error());mysql_query('INSERT INTO `'.$table.'` (`'.implode('`,`', $keys).'`) VALUES (\''.implode('\',\'', $values).'\')');
mysql_close($link);
?>