Problems pulling a field from XML?

[kitenski]

Good morning,

I am trying to extract some data from a XML file. I have the basics working, but I am having problems getting it to pull out the software ID.

Using a simple XML file as an example, I cannot get my php to pull out the unique software id

<?xml version="1.0" encoding="UTF-8"?>
products count="5" rendertime="1.620">
<software id="5667391" added="2010-05-27" updated="2010-05-27">
  <title><![CDATA[World Cup South Africa 2010 Scoreboard 1.0.1]]></title>
  <name><![CDATA[World Cup South Africa 2010 Scoreboard]]></name>
  <short_description><![CDATA[This program automates all the scores, schedules and rankings of all matches at the FIFA 2010 Soccer World Cup in South Africa.]]></short_description>
 </software>
</products>

My relevant PHP section is as follows:

$xmlReader = new XMLReader ();
$filename="/files/testfile.xml";
$xmlReader ->open($filename);
while ($xmlReader->read())
{
switch ($xmlReader->name)
{
case 'software':
$dom = new DOMDocument();
$domNode = $xmlReader->expand();
$element = $dom->appendChild($domNode);
$domString = utf8_encode($dom->saveXML($element));
$product = new SimpleXMLElement($domString);

//read in data
$name = $product->name;
$description = $product->short_description;
$software_id = $product->id;
echo $software_id . "software ID <br />";
echo $name . "name <br />";
echo $description . "description <br />";

It pulls out the name and description succesfully, but not the software id.

Can anyone suggest what I am doing wrong please? I have also tried changing the software_id line to the following, but that also returns a blank

$software_id = $product->'software id';

I've about reached my technical limits, googling on SimpleXMLElement($domString); hasn't helped at all 🙁

Thanks in advance,

Greg

[Weedpacket]

The element's name is "software", and it has an attribute "id".
See the manual's section on [man]SimpleXML[/man]. Particularly example 5 of "Basic usage", which shows the attribute value being retrieved.

[kitenski]

Thanks, that worked for the software id using these 2 lines of code:

[/code]$arrlinks = $product->attributes(links);
$id = $arr["id"];[/code]

However further within the XML there is another section with subsections, and the similiar code doesn't work

The XML has

  <links>
   <details>http://www.link1.com/</details>
   <add_to_cart>http://www.link2</add_to_cart>
  </links>

So I'm not sure how I can pull the details link out?

I tried

Thanks, that worked for the software id using these 2 lines of code:

/code;
$link = $arr["details"];[/code]

but it gets returned as blank

[Weedpacket]

Those aren't attributes, they're elements, so you'd use the same sort of code you used for getting the short_description and name elements (e.g., $product->links->details, or whatever the exact sequence of nested elements is).