How to sort an XML file by "title" using PHP

<?php

$xmlString = '<?xml version="1.0" encoding="UTF-8"?>
<urlset xmls="http://www.sitemaps.org/schemas/sitemap/0.9">

<url>
<title>Programs</title>
<loc>programs.php</loc>
<changefreq>always</changefreq>
<priority>0.9</priority>
</url>

<url>
<title>Training</title>
<loc>training.php</loc>
<changefreq>daily</changefreq>
<priority>0.8</priority>
</url>

<url>
<title>College</title>
<loc>college.php</loc>
<changefreq>daily</changefreq>
<priority>0.8</priority>
</url>

<url>
<title>Academic</title>
<loc>academic.php</loc>
<changefreq>daily</changefreq>
<priority>0.7</priority>
</url>

<url>
<title>University</title>
<loc>University.php</loc>
<changefreq>daily</changefreq>
<priority>0.7</priority>
</url>

<url>
<title>Education</title>
<loc>education.php</loc>
<changefreq>daily</changefreq>
<priority>0.8</priority>
</url>

<url>
<title>Apply now</title>
<loc>apply.php</loc>
<changefreq>daily</changefreq>
<priority>0.7</priority>
</url>

<url>
<title>Policies</title>
<loc>policies.php</loc>
<changefreq>daily</changefreq>
<priority>0.7</priority>
</url>

</urlset>
';

function xml2array($xml, $options = null, $isURL = false){
  $sxi = new SimpleXmlIterator($xml, $options, $isURL);
  return sxiToArray($sxi);
}

function sxiToArray($sxi){
  $a = array();
  for( $sxi->rewind(); $sxi->valid(); $sxi->next() ) {
    if(!array_key_exists($sxi->key(), $a)){
      $a[$sxi->key()] = array();
    }
    if($sxi->hasChildren()){
      $a[$sxi->key()][] = sxiToArray($sxi->current());
    }
    else{
      $a[$sxi->key()] = strval($sxi->current());
    }
  }
  return $a;
}

function array_csort() {        //coded by Ichier2003 
    $args = func_get_args(); 
    $marray = array_shift($args);  
    $msortline = 'return(array_multisort('; 
    $i = 0;
    foreach ($args as $arg) { 
        $i++; 
        if (is_string($arg)) { 
            foreach ($marray as $row) { 
                $sortarr[$i][] = $row[$arg]; 
            } 
        } else { 
            $sortarr[$i] = $arg; 
        } 
        $msortline .= '$sortarr['.$i.'],'; 
    } 
    $msortline .= '$marray));'; 
    eval($msortline); 
    return $marray; 
} 

// Read cats.xml and print the results:
$catArray = xml2array($xmlString,null,false);

$catArray["url"] = array_csort($catArray["url"],"title",SORT_DESC);

print_r($catArray);
?>

Select allOpen in new window

<?php // RAY_sort_XML_2.php
error_reporting(E_ALL);
echo "<pre>\n"; // READABILITY

// CONSUME XML AND REPORT IT OUT IN A SORTED ORDER

// TEST DATA WRAPPED IN A REASONABLE XML PACKAGE
$xml = '<?xml version="1.0" encoding="UTF-8"?>
<Package>
<ALPHA ID="1">
  <NAME>Boston</NAME>
  <DATE>10/30/2009 3:45:00 PM</DATE>
</ALPHA>

<ALPHA ID="1">
  <NAME>LA</NAME>
  <DATE>10/29/2009 3:45:00 PM</DATE>
</ALPHA>

<ALPHA ID="1">
  <NAME>Miami</NAME>
  <DATE>10/31/2009 3:45:00 PM</DATE>
</ALPHA>

<ALPHA ID="2">
  <NAME>Paris</NAME>
  <DATE>10/27/2009 3:45:00 PM</DATE>
</ALPHA>

<ALPHA ID="2">
  <NAME>London</NAME>
  <DATE>10/24/2009 3:45:00 PM</DATE>
</ALPHA>

<ALPHA ID="2">
  <NAME>Madrid</NAME>
  <DATE>10/30/2009 3:45:00 PM</DATE>
</ALPHA>
</Package>';


// MAKE AN OBJECT
$obj = SimpleXML_Load_String($xml);
// VISUALIZE THE OBJECT
// var_dump($obj);

// ITERATE OVER THE OBJECT TO INJECT A SORT CODE
foreach ($obj->ALPHA as $thing)
{
// CREATE AN IDENTITY FOR THE OBJECT
   $object_id = md5(serialize($thing));

// INJECT THE ID INTO THE OBJECT
   $thing->ObjectID = $object_id;

// GET THE ATTRIBUTE ID
   $sort_attr = (string)$thing["ID"];

// PRODUCE A SORTABLE ISO8601 DATE
   $sort_date = date('c', strtotime($thing->DATE));

// CREATE ARRAYS THAT WE CAN SORT
   $attr_array[$object_id] = $sort_attr;
   $date_array[$object_id] = $sort_date;

// SORT ASCENDING BY ATTR ID AND DESCENDING BY DATE
// MAN PAGE: http://us2.php.net/manual/en/function.arsort.php
   asort($attr_array);
   arsort($date_array);
}

var_dump($obj);
var_dump($attr_array);
var_dump($date_array);

Select allOpen in new window