XML Multidimensional Array, Sort and reference

Question

I am REALLY not getting arrays at all, I have read many examples, most plagiarized and amended, am an yet to find help that I understand I do hope someone can walk me through this, so I understand fully.

I have an XML file, which I need to read and display with options to sort using PHP, then output the required fields into my page(s). I have managed to retreive the XML file and rehouse locally and check the age of the file (milestone) and using the code (below) have managed to read the XML file and output as an array, but I can get no further and after two days I turn to you the community for assistance:

<?php

 function std_class_object_to_array($stdclassobject) {
  $_array = is_object($stdclassobject) ? get_object_vars($stdclassobject) : $stdclassobject;

    foreach ($_array as $key => $value) {
    $value = (is_array($value) || is_object($value)) ? std_class_object_to_array($value) : $value;
     $array[$key] = $value;
    }
   return $array; 
  }

  $request = $domain.$filename;
  $API_results = file_get_contents($request);
  $xml = new SimpleXMLElement($API_results);
  $Details = std_class_object_to_array($xml);

echo "<pre>";
print_r($Details[hotel]);
echo "</pre>"; ?>

The Output looks like this (shortened)

Array
(
    [0] => Array
        (
            [hotel_ref] => 157258
            [hotel_name] => Hotel Kong Arthur

continued

[1] => Array
    (
        [hotel_ref] => 98813
        [hotel_name] => Hotel Lautruppark

Firstly is the code I have used for reading the XML good? Is there a better way that could be used? How do I sort the results? How do I output the individual fields?

Your help, examples and direction would be greatly appreciated,

Stu

//----------------------- UPDATE ----------------------- \

OK, so this is where I am at now with the suggestion to use SimpleXML, but its still not right and I am not really a great deal further on:

$request = $domain.$filename;
$xmlobj = simplexml_load_file($request);
$xml = simplexml_load_file($request) or die("NO XML");
foreach($xml as $hotels)
 echo $hotels->hotel_name." (".$hotels->hotel_ref.")<br/>";

why dont you just use the SimpleXmlElement? Why does it have to be an array, at all? — Gordon
– Gordon, Commented Jun 16, 2011 at 14:37
Could you post some of the xml data, and simply how you want it sorted? — Yoshi
– Yoshi, Commented Jun 16, 2011 at 14:59
hotel_name sort would be a good start, I am on the the previous suggestion. — Stuart
– Stuart, Commented Jun 16, 2011 at 15:01
Can you take a look at my update, I need to add the sort to it.. Better? — Stuart
– Stuart, Commented Jun 16, 2011 at 18:14

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

The code you have written for reading the XML is absolutely fine.

However, you are unnecessarily converting from a SimpleXMLElement object to an array, as SimpleXMLElement is already iterable. You can access the <hotel> element of the XML as simply as:

$Details->hotel[0]

You can iterate through the child elements of <hotel> by the following:

<?php
// Loop through the elements, and with each...
foreach($Details->hotel[0] as $index => $hotel) {
    // ...output the name of the hotel:
    echo $hotel->hotel_name;
}
?>

Here, $index will be the numeric index, and $hotel will be another SimpleXMLElement.

N.B. In terms of sorting the results, it might actually be worth doing the object-to-array conversion. All of the sorting functions in PHP work on arrays, not objects.

Hope this helps!

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jun 16, 2011 at 16:30

Jim O'Brien

2,53718 silver badges29 bronze badges

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

2 Comments

Stuart Over a year ago

Still a but confused here, you say that I am "unnecessarily converting from a SimpleXMLElement object to an array" but then say "In terms of sorting the results, it might actually be worth doing the object-to-array conversion" So would I not convert the XML to an Array the Sort and output? All very confusing.

Jim O'Brien Over a year ago

@Stuart: Sorry for any confusion - I should probably rephrase my answer! You should only be doing the XML object to array conversion iff you need to sort the results.

Collectives™ on Stack Overflow

XML Multidimensional Array, Sort and reference

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