Sorting XML data based on Attribute Value

Question

Need help guys Ive managed to find an easier XML feed to work with now and its perfect

The only problem is it doesnt order the results returned by date

here is the xml file

Here is my PHP code

$xmlData = 'http://xml.betfred.com/Horse-Racing-Daily.xml';
$xml = simplexml_load_file($xmlData);
$curdate = date('d/m/Y');
$i = 0;
    foreach ($xml->event as $event)
        if ($i < 5) {
        {
            //20160112
        $eventd = substr($event->attributes()->{'date'},6,2);
        $eventm = substr($event->attributes()->{'date'},4,2);
        $eventy = substr($event->attributes()->{'date'},0,4);
        $eventdate = $eventd.'/'.$eventm.'/'.$eventy;
        $eventid = $event->attributes()->{'eventid'};
        $eventtime = $event->attributes()->{'time'};
        $eventname = $event->attributes()->{'name'};
        echo "".$event->attributes()->venue.' - '.$eventtime.' - '.$eventname."
".$eventdate."
";
        $i++;} }

at the minute its only displaying the first 5 results which is fine, however i need to arrange and display the data by the $eventtime value which is the $event->attributes()->{'time'}; value

Please help guys I'm so almost there after stressing so much over these xml feeds

Thanks in advance

Paul Carlton · Accepted Answer

What I would do in this case, if I don't have a way to change how the data is being output by the database, I would load it into PHP as an associative array and sort the keys. Something like this:

event as $event) {
    if ($limit == $c) {
        break;
    }
    $c++;
    $eventd = substr($event->attributes()->{'date'},6,2);
    $eventm = substr($event->attributes()->{'date'},4,2);
    $eventy = substr($event->attributes()->{'date'},0,4);
    $eventt = $event->attributes()->{'time'};
    $new_array[$eventy.$eventm.$eventd.$eventt] = array(
        'eventd' => $eventd,
        'eventm' => $eventm,
        'eventy' => $eventy,
        'eventt' => $eventt,
        'eventdate' => $eventd.'/'.$eventm.'/'.$eventy,
        'eventid' => $event->attributes()->{'eventid'},
        'eventtime' => $event->attributes()->{'time'},
        'eventname' => $event->attributes()->{'name'},
        'venue' => $event->attributes()->venue,
    );
}

ksort($new_array);
foreach ($new_array as $event_time => $event_data) {
    echo "".$event_data['venue'].' - '.$event_data['eventtime'].' - '.$event_data['eventname']."
".$event_data['eventdate']."
";
}

Of course this is NOT TESTED.

EDIT - Tested and it works now.

The point is that you load the array first with the information you need, sort by the key of the associative array and then print out what you want. You could change the limit on either the full loaded list, or just the first 5 from the xml file. Good luck!

Sorting XML data based on Attribute Value

Answers (1)

Related Questions