How to get parent tag attribute in xml documents using php?

Question

PHP

There is an xml file with the following structure:

<catalog>
-<category id="1">
--<category id="2">
---<product id=1 name="Товар 1" />
---<product id=2 name="Товар 2" />
--</category>
-</category>
-<category id="3">
--<product id=3 name="Товар 3" />
-</category>
-</catalog>

To display a list of products, I use the following code:

$products= $catalog->getElementsByTagName("product");
echo "<table>";
echo "<tr><th>Id</th><th>Наименование</th></tr>";
foreach ($products as $product) {
    echo '<tr><td>'.$product->getAttribute('id') . '</td><td>'.$product->getAttribute('name') . '</td></tr>';
}
echo "</table>";
}

It is required to enter these goods into the database with binding to the category. Can you please tell me how to get (display in the rows of the table) the id of the category to which the product belongs?
For example, Product 1 and Product 2 belong to the category with id = 2, and Product 3 belongs to the category with id = 3.

Answer 1

Probably: $product->parentNode->getAttribute('id') will return you the ID of the category taken from the tag above