在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
<?php $dbconn = mysql_connect("localhost","root","root"); $db = mysql_select_db("xbrl",$dbconn); $xml = simplexml_load_file("test.xml"); $name = "" ; $price = 0.00 ; foreach ($xml->children() as $child){ $i = 0 ; foreach ($child->children() as $kid){ if($i==0){ $name = $kid ; $i++ ; }else{ $price = $kid ; $i--; } } $sql = "insert into t_car(name,price) values('$name',$price)" ; mysql_query($sql,$dbconn); } ?> xml文件内容 <?xml version="1.0" encoding="UTF-8"?> <OBJECT> <CAR> <NAME>BMW</NAME> <PRICE>10000</PRICE> </CAR> <CAR> <NAME>BENZ</NAME> <PRICE>10000</PRICE> </CAR> <CAR> <NAME>TOYOTA</NAME> <PRICE>10000</PRICE> </CAR> <CAR> <NAME>HONDA</NAME> <PRICE>10000</PRICE> </CAR> </OBJECT>
|
2022-08-17
2022-11-06
2022-07-18
2022-08-18
2022-07-29
请发表评论