Displaying XML using PHP

Question

I'm trying to access the xml data from http://ratings.food.gov.uk/OpenDataFiles/FHRS523en-GB.xml but can't seem to retrieve it correctly. I don't think it has anything to do with the structure of the data however. How can I retrieve and display the data?

<?php
$fhrsid = 'FHRSID';

$LocalAuthorityBusinessID = 'LocalAuthorityBusinessID';

$xml = simplexml_load_file("http://ratings.food.gov.uk/OpenDataFiles/FHRS523en-GB.xml");
echo "<h2>".$xml->getName()."</h2><br />";

foreach($xml->children() as $data)

{
    echo "FHRSID: ".$data->$fhrsid."<br />";
    echo "LocalAuthorityBusinessID : ".$data->$LocalAuthorityBusinessID." <br />";
    echo "BusinessName : ".$data->BusinessName." <br />";
    echo "BusinessType : ".$data->BusinessType." <br />";
    echo "BusinessTypeID : ".$data->BusinessTypeID." <br />";
    echo "AddressLine1 : ".$data->AddressLine1." <br />";
    echo "AddressLine2 : ".$data->AddressLine2." <br />";
    echo "<hr/>";
}
?>

Community · Accepted Answer · 2017-05-23 12:06:35Z

1

Do:

print_r($xml);

output:

SimpleXMLElement Object
(
    [Header] => SimpleXMLElement Object
        (
            [ExtractDate] => 2015-04-25
            [ItemCount] => 1881
            [ReturnCode] => Success
        )

    [EstablishmentCollection] => SimpleXMLElement Object
        (
            [EstablishmentDetail] => Array
                (
                    //...

And you will see the structure of your xml and you will see that you have to change your foreach header to this:

foreach($xml->EstablishmentCollection->EstablishmentDetail as $data)

EDIT:

Also as mentioned in the comments from @hakre, you should use asXML():

echo $xml->asXML();

To see the full and entire xml.

edited May 23, 2017 at 12:06

CommunityBot

11 silver badge

answered Apr 30, 2015 at 11:22

Rizier123

59.8k17 gold badges106 silver badges167 bronze badges

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

3 Comments

hakre Over a year ago

Please also share the information that it won't show the whole picture and to see all XML, $xml->asXML() should be used.

Rizier123 Over a year ago

@hakre You're right :) (I think there is even an answer about this with: You should never trust the output of print_r() or var_dump())

hakre Over a year ago

Especially not with SImpleXMLElement (or say a PDO connection when you expect that print_r then shows you the database data, or ... .). :)

Collectives™ on Stack Overflow

Displaying XML using PHP

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related