Accessing Node of an XML object

Question

I am trying to access certain pieces of data from an xml file, here is the problem.

###XML FILE
<products>
    <product>
        ....
        ....
    </product>
    <product>
        ....
        ....
    </product>
    etc...
</products>

I know that the piece of data I need is in ($products->product->myProdNode) I have this mapping (and many others) stored in my database as a string e.g.'product->prodCode' or 'product->dedscriptions->short_desc' How can I access this data by using the strings stored in my database.

Thanks for you help in advance!

Julius A · Accepted Answer · 2010-05-17 11:22:41Z

2

I think if you replace your -> with forward slash (/), they effectively become Xpath and you can query Node contents like that.

E.g

'product->dedscriptions->short_desc' should be mapped to
'product/dedscriptions/short_desc'

Please read more on Xpath here

E.g. In C#

XmlNode.SelectSingleNode("product/dedscriptions/short_desc").InnerText will get the short description text

In php

$result = $record->xpath('descriptions/short_description');

while(list( , $node) = each($result)) { echo 'Results is: ',$node,"\n"; }

edited May 17, 2010 at 11:22

answered May 17, 2010 at 11:11

Julius A

40k27 gold badges79 silver badges98 bronze badges

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

3 Comments

Lizard Over a year ago

How would i get the data with this method?

Lizard Over a year ago

$record->xpath('descriptions/short_description'); - I want just the value not the SimpleXMLElement Object

Julius A Over a year ago

Am not sure about the properties and methods of SimpleXMLElement Object, but you should access the inner text or value

Collectives™ on Stack Overflow

Accessing Node of an XML object

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related