Home > Article > Backend Development > Implementation method of php operating xml and inserting it into database
As shown below:
<?php header('content-type:text/html;charset=utf-8'); mysql_connect('localhost', 'root', ''); mysql_select_db('test'); mysql_query('SET names utf8'); $xml_array=simplexml_load_file('suggest.xml'); //将XML中的数据,读取到数组对象中 foreach($xml_array as $tmp){ $sql = "insert into `countries` (`id` ,`value`) VALUES (NULL , '".$tmp->field."')"; mysql_query($sql); echo $tmp->field."<br>"; } ?>
The above implementation method of php operating xml and inserting it into the database is all the content shared by the editor. I hope it can give you a reference, and I hope you will support PHP more. Chinese website.