PHP: Parse XML with SimpleXML

Question

I'm having issues attempting to parse an XML file I'm pulling in from another site with SimpleXML. I need to display the rent for certain properties. However, I only want to display the rent for certain properties. I've never seen an XML file structured in this manner: http://dl.dropbox.com/u/1925679/example.xml

First, how would I parse through this file based on

Property->PropertyID->MITS:Identification->MITS:PrimaryID

Then, echo out the Property->Floorplan->MarketRent(Min and Max) based on an ID?

TIA!!!!

are you thrown off by the namespaces ("MITS:")? If so, don't worry about them, just treat the whole thing ("MITS:CompanyInfo") as a node name. — citizen conn
– citizen conn, Commented Jun 29, 2011 at 0:35

prodigitalson · Accepted Answer · 2011-06-29 17:29:29Z

2

// get all properties
$properties = $xml->xpath('//Property');

// get document namesapces in prefix => uri format
$namespaces = $xml->getNamespaces(true);


foreach($properies as $property)
{
   // get namespaced nodes
   $identification = $property->PropertyID->children($namespaces['MITS']);
   $id = $identification->children($namespaces['MITS'])->PrimaryID;

   // do your check id is an expected value or whatever and if so then...

   foreach($property->Floorplan as $floorplan){
   {
      echo $floorplan->MarketRent['min'];
      echo $floorplan->MarketRent['max'];
   }
}

You could probably com up with an xpath query to ONLY select properties with a given id or set of ids straight away so then you would only have to loop over them and invoke the floorplan loop but ill leave that to your investigation :-) I will say though if you go that route, you will need to register the namespaces with xpath i think. Pretty sure thats not automatic.

edited Jun 29, 2011 at 17:29

answered Jun 29, 2011 at 0:59

prodigitalson

60.6k10 gold badges106 silver badges118 bronze badges

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

2 Comments

csm232s Over a year ago

This worked perfectly! The only change I had to make was $xml->getNamespaces(true); Thanks!!!

prodigitalson Over a year ago

No problem! Glad you worked it out. Will update answer with your adjustment for others' benefit :-)

Collectives™ on Stack Overflow

PHP: Parse XML with SimpleXML

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related