How to get data from xml (no array)

Question

I have a XML file and a for-each items, but I don't know how to get category name and subcategory name and also I can not edit the xml.

This is my XML file:

<?xml version='1.0' encoding='UTF-8'?>
<data>
  <category name="test-cat1">
    <subcat name="test-subcat1">
      <item name="test-name1">data1</item>
      <item name="test-name2">data2</item>
      <item name="test-name3">data3</item>
    </subcat>
    <subcat name="test-subcat2">
      <item name="test-name4">data4</item>
      <item name="test-name5">data5</item>
      <item name="test-name6">data6</item>
    </subcat>
  </category>
  <category name="test-cat2">
    <subcat name="test-subcat3">
      <item name="test-name7">data7</item>
      <item name="test-name8">data8</item>
      <item name="test-name9">data9</item>
    </subcat>
    <subcat name="test-subcat4">
      <item name="test-name10">data10</item>
      <item name="test-name11">data11</item>
      <item name="test-name12">data12</item>
    </subcat>
  </category>
</data>

This is my PHP script:

<?php

 $xml = simplexml_load_file('test.xml');

  foreach($xml->xpath('//item') as $item){

    echo $item . '<br>';
    echo $item['name'] . '<br>';
    echo /*item category*/;
    echo /*item sub-category*/;
    echo "<br>";

  }

?>

And i want to have this result:

data1
test-name1
test-cat1
test-subcat1

data2
test-name2
test-cat1
test-subcat1

...

Possible duplicate of How to parse XML file using php

tambre
– tambre

2017-02-26 11:17:22 +00:00
Commented Feb 26, 2017 at 11:17 — tambre
– tambre, Commented Feb 26, 2017 at 11:17

Martin Honnen · Accepted Answer · 2017-02-26 09:37:21Z

1

If you use XPath with $item->xpath('ancestor::category')[0]['name'] and $item->xpath('parent::subcat')[0]['name'] then you should get the values:

  foreach($data->xpath('//item') as $item){

    echo $item . '<br>';
    echo $item['name'] . '<br>';
    echo $item->xpath('ancestor::category')[0]['name'] . '<br>';
    echo $item->xpath('parent::subcat')[0]['name'] . '<br>';
    echo "<br>";

  }

edited Feb 26, 2017 at 9:37

answered Feb 26, 2017 at 9:29

Martin Honnen

169k6 gold badges100 silver badges122 bronze badges

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

Comments

SOFe · Accepted Answer · 2017-02-26 09:36:33Z

Iterate through SimpleXMLElement::children() instead:

<?php

$xml = simplexml_load_file('test.xml');

foreach($xml->children() as $cat){
    $catName = $cat["name"];
    foreach($cat->children() as $subcat){
        $subcatName = $subcat["name"];
        foreach($subcat->children() as $child){
            echo "$child", "\n", $child["name"], "\n", $subcatName, "\n", $catName, "\n\n";
        }
    }
}

Gives this output:

data1
test-name1
test-subcat1
test-cat1

data2
test-name2
test-subcat1
test-cat1

data3
test-name3
test-subcat1
test-cat1

data4
test-name4
test-subcat2
test-cat1

data5
test-name5
test-subcat2
test-cat1

data6
test-name6
test-subcat2
test-cat1

data7
test-name7
test-subcat3
test-cat2

data8
test-name8
test-subcat3
test-cat2

data9
test-name9
test-subcat3
test-cat2

data10
test-name10
test-subcat4
test-cat2

data11
test-name11
test-subcat4
test-cat2

data12
test-name12
test-subcat4
test-cat2

Note that "$child" is used to convert $child into its string content. This is same as (string $child) or $child->__toString().

Collectives™ on Stack Overflow

How to get data from xml (no array)

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related