How to Parse xml data using php

Question

I am using travelyari api from which i am getting the deta as below. In this i want to get city names seperated. I have tried many solutions but didnt get success.Please anyone help me.

<APIGetCitiesResponse xmlns="http://tempuri.org/">
<APIGetCitiesResult xmlns:a="http://schemas.datacontract.org/2004/07/CRS2011AgentApi" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
<a:CityPair>
<a:FromCityID>2433</a:FromCityID>
<a:FromCityName>Adivare</a:FromCityName>
<a:ToCityID>311</a:ToCityID>
<a:ToCityName>Chiplun</a:ToCityName>
</a:CityPair>
<a:CityPair>
<a:FromCityID>2433</a:FromCityID>
<a:FromCityName>Adivare</a:FromCityName>
<a:ToCityID>2432</a:ToCityID>
<a:ToCityName>Dhartale</a:ToCityName>
</a:CityPair>
<a:CityPair>
<a:FromCityID>2433</a:FromCityID>
<a:FromCityName>Adivare</a:FromCityName>
<a:ToCityID>2431</a:ToCityID>
<a:ToCityName>Gaonkhadi</a:ToCityName>
</a:CityPair>
<a:CityPair>
<a:FromCityID>2433</a:FromCityID>
<a:FromCityName>Adivare</a:FromCityName>
<a:ToCityID>519</a:ToCityID>
<a:ToCityName>Khed</a:ToCityName>
</a:CityPair>
<a:CityPair>
<a:FromCityID>2433</a:FromCityID>
<a:FromCityName>Adivare</a:FromCityName>
<a:ToCityID>11</a:ToCityID>
<a:ToCityName>Mumbai</a:ToCityName>
</a:CityPair>
<a:CityPair>
<a:FromCityID>2433</a:FromCityID>
<a:FromCityName>Adivare</a:FromCityName>
<a:ToCityID>2429</a:ToCityID>
<a:ToCityName>Pawas</a:ToCityName>
</a:CityPair>

did you tried simplexml_load_file?

Afsar
– Afsar

2015-11-24 05:05:03 +00:00
Commented Nov 24, 2015 at 5:05 — Afsar
– Afsar, Commented Nov 24, 2015 at 5:05
Yes i have tried this too.

Atul Suroshe
– Atul Suroshe

2015-11-24 05:09:14 +00:00
Commented Nov 24, 2015 at 5:09 — Atul Suroshe
– Atul Suroshe, Commented Nov 24, 2015 at 5:09
Possible duplicate of Best XML Parser for PHP

astroanu
– astroanu

2015-11-24 05:12:01 +00:00
Commented Nov 24, 2015 at 5:12 — astroanu
– astroanu, Commented Nov 24, 2015 at 5:12

ThW · Accepted Answer · 2015-11-24 09:44:16Z

You can use SimpleXMLElement with xpath. //a:FromCityName|//a:ToCityName will query FromCityName or ToCityName.

Code

<?php
$xmlString ='<APIGetCitiesResponse xmlns="http://tempuri.org/">
<APIGetCitiesResult xmlns:a="http://schemas.datacontract.org/2004/07/CRS2011AgentApi" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
<a:CityPair>
<a:FromCityID>2433</a:FromCityID>
<a:FromCityName>Adivare</a:FromCityName>
<a:ToCityID>311</a:ToCityID>
<a:ToCityName>Chiplun</a:ToCityName>
</a:CityPair>
<a:CityPair>
<a:FromCityID>2433</a:FromCityID>
<a:FromCityName>Adivare</a:FromCityName>
<a:ToCityID>2432</a:ToCityID>
<a:ToCityName>Dhartale</a:ToCityName>
</a:CityPair>
<a:CityPair>
<a:FromCityID>2433</a:FromCityID>
<a:FromCityName>Adivare</a:FromCityName>
<a:ToCityID>2431</a:ToCityID>
<a:ToCityName>Gaonkhadi</a:ToCityName>
</a:CityPair>
<a:CityPair>
<a:FromCityID>2433</a:FromCityID>
<a:FromCityName>Adivare</a:FromCityName>
<a:ToCityID>519</a:ToCityID>
<a:ToCityName>Khed</a:ToCityName>
</a:CityPair>
<a:CityPair>
<a:FromCityID>2433</a:FromCityID>
<a:FromCityName>Adivare</a:FromCityName>
<a:ToCityID>11</a:ToCityID>
<a:ToCityName>Mumbai</a:ToCityName>
</a:CityPair>
<a:CityPair>
<a:FromCityID>2433</a:FromCityID>
<a:FromCityName>Adivare</a:FromCityName>
<a:ToCityID>2429</a:ToCityID>
<a:ToCityName>Pawas</a:ToCityName>
</a:CityPair>
</APIGetCitiesResult>
</APIGetCitiesResponse>';

$xml = new SimpleXMLElement($xmlString);
$xml->registerXPathNamespace('a', 'http://schemas.datacontract.org/2004/07/CRS2011AgentApi');
$results = $xml->xpath('//a:FromCityName|//a:ToCityName');

foreach ($results as $result) {
    echo $result . "\n";
}
?>

Result

Adivare
Chiplun
Adivare
Dhartale
Adivare
Gaonkhadi
Adivare
Khed
Adivare
Mumbai
Adivare
Pawas

Reference

Afsar · Accepted Answer · 2015-11-24 05:54:23Z

0

You can use Namespace module of php xml to access nodes:

    $xmlString = file_get_contents("yourXMLFileName.xml");
    $xml = new SimpleXMLElement($xmlString);

    foreach ($xml as $out_namespace) 
    { 
        $ns = $out_namespace->getNamespaces(true);
        $child = $out_namespace->children($ns['a']);
        foreach ($child as $out) 
        { 
            echo "From City name: ". $out->FromCityName ." To city name : ".$out->ToCityName."</br>";

        } 
    }

answered Nov 24, 2015 at 5:54

Afsar

3,1242 gold badges27 silver badges35 bronze badges

2 Comments

Afsar Over a year ago

@AtulSuroshe , you are welcome , accept and upvote please

ThW Over a year ago

You should not read the namespace by its prefix from the document. The prefix is optional and can change anywhere in the document.

Collectives™ on Stack Overflow

How to Parse xml data using php

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related