xml to mysql simplexml_load_string, no insert

Question

the values are not being inserted and also no error is being displayed. Any idea as to what is happening with my insert?

<?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 />"
}

What shows var_dump($xml)?

u_mulder
– u_mulder

2013-10-04 20:20:05 +00:00
Commented Oct 4, 2013 at 20:20 — u_mulder
– u_mulder, Commented Oct 4, 2013 at 20:20

João Paulo de Lima · Accepted Answer · 2013-10-04 20:28:21Z

1

$xml variable is an object, nor an array. So, you should do your foreach like this:

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 />"
}

answered Oct 4, 2013 at 20:28

João Paulo de Lima

981 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

xml to mysql simplexml_load_string, no insert

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related