php操作xml并将其插入数据库的实现方法

<?php
header(&#39;content-type:text/html;charset=utf-8&#39;);
mysql_connect(&#39;localhost&#39;, &#39;root&#39;, &#39;&#39;);
mysql_select_db(&#39;test&#39;);
mysql_query(&#39;SET names utf8&#39;);
$xml_array=simplexml_load_file(&#39;suggest.xml&#39;); //将XML中的数据,读取到数组对象中
 
foreach($xml_array as $tmp){
    $sql = "insert into `countries` (`id` ,`value`) VALUES (NULL , &#39;".$tmp->field."&#39;)";
    mysql_query($sql);
echo $tmp->field."<br>";
}
?>