displaying data of xml file

Question

i want to display the cheapest 3 pairs from pairs.xml file , now i am confused how to use a condition for it .can anybody help me out

pairs.xml------------

<pairs>
    <pair>
        <name>cups</name>
        <price>50</price>
    </pair>
    <pair>
        <name>mugs</name>
        <price>60</price>
    </pair>
    <pair>
        <name>plates</name>
        <price>40</price>
    </pair>
    <pair>
        <name>spoons</name>
        <price>10</price>
    </pair>
</pairs>

pairs.php----------

$xmlFile = "pairs.xml";
$doc = DOMDocument::load($xmlFile);
$pair = $doc->getElementsByTagName("pair");
echo "<table border=1><tr><th>Name</th><th>Price</th></tr>";
foreach ($pair as $node) {
    $name = $node->getElementsByTagName("name");
    $name = $name->item(0)->nodeValue;
    $price = $node->getElementsByTagName("price");
    $price = $price->item(0)->nodeValue;

    if ()
        echo "<tr><td>{$name}</td><td>{$price}</td><tr>";
}

You'd loop over the XML first and find/save the 3 cheapest pairs, THEN do the output. You can't do it in a single loop. — Marc B, May 11 '11 at 20:28
@MarcB you should really post that as an answer (since it is the answer). — Scott C Wilson, May 11 '11 at 20:31

score 0 · Accepted Answer · answered May 11 '11 at 20:32

$pairs = array();
foreach($pair as $node)
{
    $name = $node->getElementsByTagName("name")->item(0)->nodeValue;
    $price = $node->getElementsByTagName("price")->item(0)->nodeValue;
    $pairs[$price] = $name;
}
ksort($pairs, SORT_NUMERIC);
$i = 0;
foreach($pairs AS $p => $n)
{
     echo("<tr><td>{$n}</td><td>{$p}</td></tr>");
     $i++;
     if( $i == 3 )
          break;
}

displaying data of xml file

1 Answers1