Trying to parse this xml feed using php

Question

I am wondering how I can parse this xml feed with php?

http://www.shinyloot.com/feeds/games_on_sale

I know I can use this to start with:

$shinyloot = simplexml_load_file('http://www.shinyloot.com/feeds/games_on_sale');

From there I am unsure as the best way to parse it is it's a more complicated one with multiple arrays inside.

Also this is not a duplicate it's a specific case and the answers you lot linked are not correct for this feed please unmark it as a dup.

Prix · Accepted Answer · 2013-08-24T20:17:17.397

1

You can use $variable['attribute_name'] to read the attribute data and for elements with dash and other characters in between the letters you can enclose it with braces and single quotes like I have done for the operating-systems element.

<?php
$url = 'http://www.shinyloot.com/feeds/games_on_sale';
$xml = simplexml_load_string(file_get_contents($url));
foreach ($xml->games->game as $game)
{
    $operating_system = array();
    foreach ($game->{'operating-systems'}->os as $os)
        $operating_system[] = $os;

    if (!in_array("Linux", $operating_system))
        continue;
    echo "Title: ", $game['title'], "\n";
    echo "URL: ", $game['url'], "\n";
    echo "MRSP: ", $game->mrsp, "\n";
    echo "Price: ", $game->price, "\n";
    echo "Discount: ", $game->{'discount-pct'}, "%\n";
    echo "Cover Image: ", $game->{'cover-image'}, "\n";
    echo "Header Image: ", $game->{'header-image'}, "\n";
    echo "Available for:\n";
    foreach ($operating_system as $os)
    {
        echo $os, "\n";
    }
    echo "==================================================\n\n";
}

An alternative way would be like this:

$operating_system = json_decode(json_encode($game->{'operating-systems'}), true);
if (!in_array("Linux", $operating_system['os']))
   continue;

Basically it transforms the result in JSON then convert it back into a simple associative array.

edited Aug 24 '13 at 20:17

answered Aug 24 '13 at 19:26

Prix

19,417
15
73
132

@LiamDawe have also added a sample on how to read the elements with dash and stuff like `operating-systems` – Prix Aug 24 '13 at 19:33
That's really great, is there a way to only list ones where Linux is an OS option? – NaughtySquid Aug 24 '13 at 19:35
@LiamDawe yes you could use [**`in_array("Linux", $game->{'operating-systems'}->os)`**](http://php.net/manual/en/function.in-array.php) to check if the game have Linux as OS option. – Prix Aug 24 '13 at 19:42
That doesn't work as it's not a valid array, had to make a manual array. – NaughtySquid Aug 24 '13 at 19:46
@LiamDawe you can cast it to array like this `(array)$game->{'operating-systems'}->os` will update my example. – Prix Aug 24 '13 at 19:49
That now turns up blank. – NaughtySquid Aug 24 '13 at 19:59
@LiamDawe because no games on sales have Linux. It only list 3 games for me and they only have mac and windows. – Prix Aug 24 '13 at 20:00
Bernie Needs Love (beta) has Linux in the OS option. – NaughtySquid Aug 24 '13 at 20:01
@LiamDawe yes indeed, casting the object only takes the first element, my bad, fixed. – Prix Aug 24 '13 at 20:11

score 0 · Answer 2 · answered Aug 24 '13 at 19:43

Okay so here is what I have for anyone wondering:

<?php
$url = 'http://www.shinyloot.com/feeds/games_on_sale';
$xml = simplexml_load_string(file_get_contents($url));
foreach ($xml->games->game as $game)
{
    $os_options = array();
    foreach ($game->{'operating-systems'}->os as $os)
    {
        $os_options[] = $os;
    }

    if (in_array("Linux", $os_options))
    {
        echo "Title: ", $game['title'], "\n";
        echo "URL: ", $game['url'], "\n";
        echo "Price: ", $game->price, "\n";
        echo "<br />==================================================<br />";
    }
}

Not sure if this is the best way to do it or not, but this allows me to filter by os.

Thanks to Prix.

Trying to parse this xml feed using php

2 Answers2