Simple question on how to display XML attribute on a specific code

Question

I am kinda new in XML but I can handle some things. Below there is a code that gets value from a HTML form and then displays some info from a XML file (see below). The code shows correctly all the info (TITLE, BAND, YEAR), but my question is how can I display also the id attribute of <CD id="XXX">. Thank you!

the code

<?php
$q=$_GET["q"];

$xmlDoc = new DOMDocument();
$xmlDoc->load("database.xml");

$x=$xmlDoc->getElementsByTagName('TITLE');

for ($i=0; $i<=$x->length-1; $i++)
{
//Process only element nodes
if ($x->item($i)->nodeType==1)
  {
  if ($x->item($i)->childNodes->item(0)->nodeValue == $q)
    {
    $y=($x->item($i)->parentNode);
    }
  }
}

$cd=($y->childNodes);

for ($i=0;$i<$cd->length;$i++)
{
//Process only element nodes
if ($cd->item($i)->nodeType==1)
  {
  echo("<b>" . $cd->item($i)->nodeName . ":</b> ");
  echo($cd->item($i)->childNodes->item(0)->nodeValue);
  echo("<br />");
  }
}
?>

XML

<CATEGORIES>

<CD id="1">
<TITLE>NEVER MIND THE BOLLOCKS</TITLE>
<BAND>SEX PISTOLS</BAND>
<YEAR>1977</YEAR>  
</CD>

<CD id="2">    
<TITLE>NEVERMIND</TITLE>
<BAND>NIRVANA</BAND>
<YEAR>1991</YEAR> 
</CD>

</CATEGORIES>

lonesomeday · Accepted Answer · 2011-01-06 18:57:06Z

1

First, it would be nicer to do this searching using XPath. The query to find a TITLE element that have the content foo is //TITLE[.="foo"]. You can then use DOMElement::getAttribute to get the attribute you want. So your code could look something like this:

$dom = new DOMDocument;
$dom->load("database.xml");
$xpath = new DOMXPath($dom);

$el = $xpath->query('//TITLE[.="' . $q . '"]');

if ($el->length) {
    $cd = $el->item(0)->parentNode;

    echo "<b>ID:</b> " . $cd->getAttribute('id');

    foreach ($cd->childNodes as $node) {
        if ($node->nodeType == 1) {
            echo("<b>" . $node->nodeName . ":</b> ");
            echo($node->nodeValue);
            echo("<br />");
        }
    }
}

answered Jan 6, 2011 at 18:57

lonesomeday

239k54 gold badges330 silver badges329 bronze badges

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

1 Comment

lonesomeday Over a year ago

@user560411 If this (or another!) answer has answered your question, you can mark the question as answered by clicking on the empty tick symbol to the left of the answer. Thanks!

David Powers · Accepted Answer · 2011-01-06 18:47:36Z

1

A simpler way of dealing with XML is to use SimpleXML like this:

$xml = simplexml_load_file('database.xml');
foreach ($xml as $cd) {
    echo 'ID: ' . $cd['id'] . '<br>';
    echo 'Title: ' . $cd->TITLE . '<br>';
    echo 'Band: ' . $cd->BAND . '<br>';
    echo 'Year: ' . $cd->YEAR . '<br>';
}

See http://docs.php.net/manual/en/simplexml.examples.php.

answered Jan 6, 2011 at 18:47

David Powers

1,68412 silver badges12 bronze badges

1 Comment

JBEnergy Over a year ago

Thank you for your reply but I would like to stick with the above code and just display the id attribute..

Richard Tuin · Accepted Answer · 2011-01-06 18:45:13Z

0

You can retreive a DomNode's attributes by calling $node->attributes().

For more information see this function's documentation: http://php.net/manual/en/function.domnode-attributes.php

answered Jan 6, 2011 at 18:45

Richard Tuin

4,5722 gold badges23 silver badges18 bronze badges

1 Comment

JBEnergy Over a year ago

Hi there, i tried to implement it but i can't add it right. I can't handle it right because it is a function.

paul.ago · Accepted Answer · 2011-01-06 18:59:02Z

0

You can use the DOMElement::getAttribute() method, so in your example:

echo $cd->item($i)->getAttribute("id");

Refer to the API http://www.php.net/manual/en/domelement.getattribute.php

answered Jan 6, 2011 at 18:59

paul.ago

4,1631 gold badge24 silver badges16 bronze badges

Collectives™ on Stack Overflow

Simple question on how to display XML attribute on a specific code

4 Answers 4

1 Comment

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related