How to filter XML-elements with attributes in php?

[jgu68]

Hello,
im trying to import xml-data to MySQL.
I only want to import rows without attributes,
like 'aaa,bbb' in the example below.
(I have no problems to import all rows.)

Im using php + DOM XML

<mydoc>
<test>
<text1>aaa</text1>
<text2>bbb</text2>
</test>
<test id="something">
<text1>ccc</text1>
<text2>ddd</text2>
</test>
</mydoc>

All help appreciated!

Regards Jorgen

 

[kyru]

Well I don't know about MySQL, but if I've understood right you're asking for XPath expressions. Check this:

http://www.w3.org/TR/xpath.

For example, for getting all contents into all the text1 labels of the document the XPath expresion would be /mydoc/test/text1/text(). Hope this helps.

 

[jgu68]

Thanks!

Was able to solve it after checking out Xpath
using this syntax:

$aaa = $xpath->query("/mydoc/test[not(@id)]");