PHP and XML: How to retrieve attributes in XML

Question

Here is my XML:

<?xml version="1.0" encoding="utf-8" ?>
<items>
  <itemgroup name="ATM" column="1" sort="0">
    <item formid="ATM 01" description="Option Teller Balance Sheet - ATM Dept. Ordering ONLY" unit="cello 500"/>
  </itemgroup>
  <itemgroup name="Data Processing" column="1">
    <item formid="AACU 01" description="Receipt Voucher - 2 Part" unit="3600/box"/>
    <item formid="AACU 04" description="Contract Collection Statement" unit="as Req."/>
    <item formid="AACU 07" description="1-part Receipt Voucher - Cont. feed form" unit="5000/box"/>
    <item formid="AACU 08" description="Share IRA Certificate" unit="2200/box"/>
    <item formid="AACU 15" description="PTA PIN MAILER" unit="1800/box"/>
    <item formid="AACU 15B" description="ONLINE ACCESS PIN MAILER" unit="2500/box"/>
  </itemgroup>
</items>

I know I need to use code such as this:

$xml_file = "aacu-data.xml";
$xml = simplexml_load_file($xml_file);

but what I need to know is how I can retrieve attributes such as description and unit for say where formid="AACU 07" and be able to assign it to two variables such as $description and $unit.

WITH SOME MODIFICATIONS I got it to work:

$xml_file = "aacu-data.xml";
$xml = simplexml_load_file($xml_file);

foreach($xml->itemgroup as $itemgroup) {
    foreach($itemgroup->children() as $items) {

        echo $items->attributes()->formid . "<br>";
        echo $items->attributes()->description . "<br>";
        echo $items->attributes()->unit . "<br>";

    }
}:

score 1 · Answer 1 · answered Feb 08 '16 at 06:44

You can use XPath expression and SimpleXML's xpath() function, to select part of an XML document filtering with certain criteria. For example, the following is a line to get item element, anywhere in $xml, where attribute formid value equals "AACU 07" :

$item = $xml->xpath("//item[@formid='AACU 07']")[0];

Having the target item element in variable, you can then easily get the corresponding attributes via attributes() :

$description = $item->attributes()->description;
$unit = $item->attributes()->unit;

See working demo here : https://eval.in/514618

Haridarshan · Accepted Answer · 2016-02-08T05:25:39.160

0

You can access value using attributes() method

foreach($xml->itemgroup[1]->attributes() as $a => $b) {
    ....
}

To Convert xml to array

function xml2array($xmlObject){

    $out = array();

    foreach ( (array) $xmlObject as $index => $node ){  
        if( is_object($node) and empty($node)){
            $out[$index] = '';
        }else{
            $out[$index] = ( is_object ( $node ) ) ? xml2array ( $node ) : $node;
        }
    }
    return $out;
}

edited Feb 08 '16 at 05:25

answered Feb 08 '16 at 04:29

Haridarshan

1,898
1
23
38

Two things: (a) what if I am not sure which itemgroup the formid belongs to and (b) how would I do a foreach to find that unique group? – John Edward Law Feb 08 '16 at 05:21
in that case you can convert xml object to array and can use foreach with key value pair – Haridarshan Feb 08 '16 at 05:24
Interesting. I was able to get the foreach loop to work but it was only pulling the first line from each item group. I ended having to change it to what I added to my original question above. – John Edward Law Feb 08 '16 at 16:49

PHP and XML: How to retrieve attributes in XML

2 Answers2