Sorting a Listbox from XML

[bishmedia]

I'm trying to sort some data drawn from an XML file but i just cant figure out how to do this??

Can anyone help??

 

 

<?php
function getOptions($file, $element)
{
$xml = simplexml_load_file($file);
$results = $xml->xpath("//result/$element");
$results = array_unique($results);
$options = "<option value=''>- Choose Band Name -</option>\n";
foreach($results as $res) {
$options .= "<option value='{$res}'>{$res}</option>\n";
}
return $options;
}
?>

             <form method="post" name="Band">
                     <select name="bandName">
                     <?php echo getOptions('xmldata.xml', 'bandName')?>
                     </select>
                     <input type="submit" name="btnSubmit" value="Search">
             </form>

[Barand]

We do not know what $results looks like

 

echo '<pre>', print_r($results, 1), '</pre>';

[bishmedia]

ive attached both files so you can see what i mean :-)

xmldata.xml

resulttest.php

[Barand]

 $results = $xml->xpath("//result/bandName");
usort($results, 'cmp');


function cmp($a,$b )
{
 return strcmp($a, $b );
}

Edited February 18, 2013 by Barand

[bishmedia]

How do i fit this in to my current file :-(

[Barand]

I'd put the usort() after you get the results using xpath.

 

Oh look, that's where it is in my post.

[bishmedia]

Im pulling my hair out with this and wished id stayed with VB from the start, ive tried various combinations with no success...

 

 

<?php
function getOptions($file, $element)
{
$xml = simplexml_load_file($file);
$results = $xml->xpath("//result/bandName");
usort($results, 'cmp');

$options = "<option value=''>- Choose Band Name -</option>\n";
function cmp($a,$b )
{
return strcmp($a, $b );
}
foreach($results as $res) {
$options .= "<option value='{$res}'>{$res}</option>\n";
}
return $options;
}
?>

[Barand]

Would you have put the "cmp" function definition there when using VB?

 

function cmp($a,$b )
{
   return strcmp($a, $b );
}

function getOptions($file, $element)
{
   $xml = simplexml_load_file($file);
   $results = $xml->xpath("//result/$element");
   usort($results, 'cmp');

   $options = "\n";
   foreach($results as $res) {
    $options .= "\n";
   }
   return $options;
}

[bishmedia]

Its not loading anything from the xml file???

 

 

<?php
function cmp($a,$b )
{
return strcmp($a, $b );
}

function getOptions($file, $element)
{
       $xml = simplexml_load_file($file);
       $results = $xml->xpath("//result/$element");
       usort($results, 'cmp');

       $options = "\n";
       foreach($results as $res) {
               $options .= "\n";
       }
       return $options;
}
?>

             <form method="post" name="Band">
                     <select name="bandName">
                     <?php echo getOptions('xmldata.xml', 'bandName')?>
                     </select>
                     <input type="submit" name="btnSubmit" value="Search">
             </form>

<?php
       if (isset($_POST['btnSubmit'])) {
       $xml = simplexml_load_file('xmldata.xml');

       $search = $_POST['bandName'];

       $results = $xml->xpath("//result[bandName='$search']");
       echo "$search <br />";
       echo "<table>";
       echo "<tr>";
       echo "<td>"; 
       foreach ($results as $res) {
       echo "$res->year</td> <td style=\"width:175px\">$res->compName</td> <td style=\"width:175px\">$res->section</td><td>$res->position";
       echo "</td>";
       echo "</tr>";
       echo "<tr>";
       echo "<td>"; 

       }
       echo "</table>";
       }
       ?>  

[Barand]

I don't know why, when I did a copy/paste, it lost a chunk from the middle but it should be

 

$options .= "<option value='{$res}'>{$res}</option>\n";

[Barand]

I've just run the code using your xml file and it gives duplicate bands in the option list.

 

After the usort() line add

 

$results = array_unique($results);

[bishmedia]

Ok thanks for your time, i was just about to approach it in 2 different ways..

 

1) The XML is built with Excel so i can sort by that column.

2) Putting the results into an array