php操作xml并插入到数据库中

<?

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>";

}

?>