php - xml到mysql simplexml_load_string，无插入

Question

未插入值，也未显示错误。知道我的插入发生了什么吗？

<?php
$string = <<<XML
<?xml version='1.0'?> 
<setnames>
<country>
<countryCode>AD</countryCode>
<countryName>Andorra</countryName>
</country>
<country>
<countryCode>AE</countryCode>
<countryName>United Arab Emirates</countryName>
<isoNumeric>784</isoNumeric>
</country>
<country>
<countryCode>AF</countryCode>
<countryName>Afghanistan</countryName>
<isoNumeric>784</isoNumeric>
</country>
</setnames>
XML;

$xml = simplexml_load_string($string);

foreach ($xml as $country) 
{

mysqli INSERT INTO setnames 
VALUES ($country->countryCode, $country->countryName, $country->isoNumeric);

    echo $country->countryCode . "<br />";
    echo $country->countryName . "<br />";
    echo $country->isoNumeric . "<br />"
}

Answer 1

$xml 变量是一个对象，也不是一个数组。所以，你应该像这样做你的 foreach:

foreach ($xml->country as $country) 
{

mysqli INSERT INTO setnames 
VALUES ($country->countryCode, $country->countryName, $country->isoNumeric);

    echo $country->countryCode . "<br />";
    echo $country->countryName . "<br />";
    echo $country->isoNumeric . "<br />"
}