How to convert array to xml

Question

I'm trying to get an xml file from a foreach loop from an array but im getting only 1 row in the xml file.

Is there another way to convert the array data to xml file in this format?

PHP:

$item = array();
        $item[] = array('CityId'    => $row['city_id'],
                        'StateId'   => $row['state_id'],
                        'CityName'  => $row['city_name']
                        );

        $break = "<br />";
        $quote = '"';
        $xml = "<data>"."\n";
        foreach($item as $_item) {

            echo $xml .= "<city CityId=$quote" . $_item['CityId'] . "$quote StateId=$quote" . $_item['StateId'] . "$quote CityName=$quote" . $_item['CityName'] . "$quote />\n";

        }
        $xml .= "</data>";
        $sxml = new SimpleXMLElement($xml);
        echo $output = $sxml->asXML("data.xml");

Output data.xml:

<data>
<city CityId="1" StateId="217" CityName="New York" />
<city CityId="2" StateId="218" CityName="New Jersey" />
</data>

Any help is appreciated.

Have you read stackoverflow.com/questions/1397036/… ? It should give you something to start with. — Brice
– Brice, Commented Feb 25, 2014 at 9:52
My issue is that im getting only 1 row instead 10, 100, or how many are in the array. — Dario
– Dario, Commented Feb 25, 2014 at 9:56
A side note, since you're already using SimpleXML, you can use it all the way trough ($city=$xml->addChild("city");$city->addAttribute("CityId","1");...), instead of caching a whole string and then convert it to SimpleXML. — Passerby
– Passerby, Commented Feb 25, 2014 at 10:03
I suppose $row is coming fram a database? Looks like your not looping trough the results from your query. Add print_r($item,true) before your foreach and see how many items the array has. — Michel
– Michel, Commented Feb 25, 2014 at 10:06

Brice · Accepted Answer · 2014-02-25 10:16:47Z

1

Data :

 $cities = array(
        array(
            'cityId' => 1,
            'stateId' => 217,
            'cityName' => 'New York'
        ),
        array(
            'cityId' => 2,
            'stateId' => 0,
            'cityName' => 'Paris'
        ),
    );

This :

$xml = new SimpleXMLElement('<data/>');
foreach ($cities as $key => $city)
{
    $xml->city[$key]['cityId'] = $city['cityId'];
    $xml->city[$key]['stateId'] = $city['stateId'];
    $xml->city[$key]['cityName'] = $city['cityName'];
}

OR (better) :

xml = new SimpleXMLElement('<data/>');
foreach ($cities as $cityData)
{
    $city = $xml->addChild('city');
    $city->addAttribute('cityId', $cityData['cityId']);
    $city->addAttribute('stateId', $cityData['stateId']);
    $city->addAttribute('cityName', $cityData['cityName']);
}

Will output :

<data>
    <city cityId="1" stateId="217" cityName="New York" />
    <city cityId="2" stateId="0" cityName="Paris" />
</data>

edited Feb 25, 2014 at 10:16

answered Feb 25, 2014 at 10:03

Brice

1,0269 silver badges20 bronze badges

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

2 Comments

Dario Over a year ago

Hello Brice, this is what i need, can you please tell me how can i format the outpup xml? i mean the output is all inline. Thx a lot

Brice Over a year ago

Quoted from stackoverflow.com/questions/1191167/… : You can use dom_import_simplexml($xml)->ownerDocument. Then set $dom->formatOutput = true and you can get the result via $dom->saveXML()

Joe · Accepted Answer · 2014-02-25 10:07:25Z

-1

have a look here. i have been using this function to convert array to xml. hope it will help you.

http://vantulder.net/old-articles/array-to-xml

answered Feb 25, 2014 at 10:07

Joe

6081 gold badge9 silver badges18 bronze badges

1 Comment

Dario Over a year ago

Hi @Joseph, is not the right format there. Thanks a lot.

Collectives™ on Stack Overflow

How to convert array to xml

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related