mysql 将xml插入数据库,解析xml文件并插入mysql数据库

I'm trying parse an xml file and insert it into an mysql database. The xml file (syntest.xml) looks like this:

LPvinylskiva

OKjavisst

OSoperativsystem

I have parsed the xml file using simplexml_load_file, and when I use an foreach loop to print the records in the browser the loop goes through all records and everyting looks fine. But when I try to insert the data into the database, the loop doesnt iterate and only one record is inserted.

The code looks like this:

$con = mysql_connect("localhost","user","username");

if (!$con)

{

die('Could not connect: ' . mysql_error());

}

mysql_select_db("db_name", $con);

if(!$xml=simplexml_load_file('syntest.xml')){

trigger_error('Error reading XML file',E_USER_ERROR);

}

foreach ($xml as $syn) {

$w1 = $syn->w1;

$w2 = $syn->w2;

}

$sql="INSERT INTO db_name (w2, w1)

VALUES

('$w1','$w2')";

if (!mysql_query($sql,$con))

{

die('Error: ' . mysql_error());

}

echo "Records added";

mysql_close($con)

?>

All help much appreciated!

解决方案

The place of mysql_query isn`t correct. You must insert records in loop:

foreach ($xml as $syn)

{

$w1 = $syn->w1;

$w2 = $syn->w2;

$sql = "INSERT INTO db_name (w1, w2) VALUES ('$w1','$w2')";

$query = mysql_query($sql);

if (!$query)

{

echo ('Error: ' . mysql_error());

}

else

{

echo "Record added";

}

}

mysql_close($con);