Simple XML Sort based on Name

Question

I am trying to sort a list of databases and documents in each database by the databasename. Then print them out in a tabled format

here is the xml

<responsedata>
<databases>
<database>
<name>Test</name>
<documents>0</documents>
</database>
−
<database>
<name>Test2</name>
<documents>0</documents>
</database>
</databases>
</responsedata>

here is my current code that lists the databases and documents without the sort and print them out in a list.

$request_url = "http://255.255.255.255/xmlfile";

$xml = simplexml_load_file($request_url)

foreach ($xml->responsedata->databases->database as $db) {

          echo"<tr><td>",$db->name,"</td><td>",$db->documents,"</td></tr>\n";
  }

//

<xsl:sort select="name" data-type="text" />

Ignacio Vazquez-Abrams
– Ignacio Vazquez-Abrams

2010-12-02 19:01:29 +00:00
Commented Dec 2, 2010 at 19:01 — Ignacio Vazquez-Abrams
– Ignacio Vazquez-Abrams, Commented Dec 2, 2010 at 19:01

Tomalak · Accepted Answer · 2010-12-02 19:30:11Z

2

$dbs = array();

foreach ($xml->responsedata->databases->database as $db) {
  $dbs[(string)$db->name] = $db;
}

ksort($dbs);

foreach ($dbs as $db) {
  echo"<tr><td>",htmlentities($db->name),"</td>",
      "<td>",htmlentities($db->documents),"</td></tr>\n";
}

edited Dec 2, 2010 at 19:30

answered Dec 2, 2010 at 19:05

Tomalak

339k68 gold badges547 silver badges635 bronze badges

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

2 Comments

Bucabear Over a year ago

There is no output possibly something wrong with $dbs and $db?

Tomalak Over a year ago

@Bucabear: See changed code. You must explicitly cast the $db (which is of type SimpleXMLElement) to string or PHP won't accept the array index.

Collectives™ on Stack Overflow

Simple XML Sort based on Name

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related