XML parsing

[Sakunne]

I need to parse XML and this article helped me a lot:

http://www.phpfreaks.com/tutorial/handling-xml-data

 

The next thing I need is to parse only elements that meet certain conditions, lets say we have an XML with structure like this:

<Result>

<Line>

<StockCode>0101009</StockCode>

<Description>Description</Description>

<ProductGroup>S01</ProductGroup>

<Availability>0</Availability>

</Line>

...

</Result>

I need to parse only the elements with ProductGroup = S01 and Availability = 1

 

How can I do that :-\

[cpd]

Just parse the whole thing and directly access those tags.

 

$xmlString = <<<XML
<Result>
    <Line>
        <StockCode>0101009</StockCode>
        <Description>Description</Description>
        <ProductGroup>S01</ProductGroup>
        <Availability>0</Availability>
    </Line>
</Result>
XML;

$xmlObj = new SimpleXMLElement($xmlString);

var_dump($xmlObj); // Will show you the structure of the object. Can't remember how it structures it.

[Mahngiel]

to expand on what CPD said,

 

You will need to run a foreach with conditionals to meet your criteria.

$lines =& $xmlObj->line;

foreach( $lines as $line ):
{
if( $line->ProductGroup == 'S01' && $line Availability != '0' )
{
	echo 'meets condition';
}
}

[/code]

[Sakunne]

Thanks!

 

Can I do the same thing with 'SimpleXML' and 'xpath'

[Mahngiel]

Thanks!

 

Can I do the same thing with 'SimpleXML' and 'xpath'

 

Just as CPD showed you

$SOURCE = http://path.to.xml;  // remote file
$SOURCE = "xml string you wish to iterate through";  // local string

$xmlObj = new SimpleXMLElement($SOURCE);

[Sakunne]

Actually, I made it like this:

 

$xml = new SimpleXMLElement('full_availability.xml', null, true);

$Result = $xml->xpath('//Line[ExtProdGroup="0204" and Availability != 0 ]');