我想加数据库 要怎么加呀 我不知道呀 那个给我解释
[code=XML][/code]<?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>
[解决办法]
- PHP code
<?php$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);
[解决办法]
先学学数据库的操作的知识吧。不会可不行啊
- PHP code
<?php $link = mysql_connect('127.0.0.1', 'mysql_user', 'mysql_password');if (!$link) { die('Could not connect: ' . mysql_error());}echo 'Connected successfully';// make foo the current dbmysql_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);?>