pr0gr4mm3r wrote: Welcome to

Renegade — Sun, 20 Sep 2009 02:27:34 +0000

pr0gr4mm3r wrote:

Welcome to the forums, jbudd! Try something like this...

<?php
/* fetchs the XML from a local file */
$data = file_get_contents('data.xml');

/* parse the XML into a PHP object */
$xml = new SimpleXMLElement($data);
?>

Just curious, what is the advantage of using the above as opposed to just using:

$xml = simplexml_load_file($xmlfeed);

I'm still trying to get my head around using PHP for XML.

DOH! I should have known

pr0gr4mm3r — Wed, 16 Sep 2009 14:19:13 +0000

DOH! I should have known that there would be multiple events on the same day. Good catch

Ahah! ksort() works. I'll

jbudd — Wed, 16 Sep 2009 13:52:10 +0000

Ahah! ksort() works.

I'll make a php programmer yet!

Thanks for the help.
jb

ps this is the feed used in

jbudd — Wed, 16 Sep 2009 13:47:38 +0000

ps this is the feed used in the above example
http://www.wcwg.info/feeds/localevents.aspx?a=00389&f=20090916&t=20091016&p=ST21 9JU&d=20&c=0011111111111111111&r=0&m=5

Thanks for the reply I

jbudd — Wed, 16 Sep 2009 13:42:52 +0000

Thanks for the reply

I have/had a couple of problems. First was multiple events on the same day so the array ends up with less elements. To fix it I added a record count to the time (which ends 00 for all these dates)

Second, the sort() does something, but it doesnt sort by the time.

Here is my debug code before sort()
Event 299587 Dates 19 Sep 09 Time: 1253314800 Formatted: Sat, 19 Sep 2009 00:00:00 +0100
Event 299590 Dates 10 Oct 09 Time: 1255129201 Formatted: Sat, 10 Oct 2009 00:00:01 +0100
Event 291193 Dates 10 Oct 09 Time: 1255129202 Formatted: Sat, 10 Oct 2009 00:00:02 +0100
Event 291827 Dates 18 Sep 09 to 19 Sep 09 Time: 1253228403 Formatted: Fri, 18 Sep 2009 00:00:03 +0100
Event 295999 Dates 19 Sep 09 to 20 Sep 09 Time: 1253314804 Formatted: Sat, 19 Sep 2009 00:00:04 +0100

and here it is after sort()
Event 295999 Dates 19 Sep 09 to 20 Sep 09 Time 0
Event 291827 Dates 18 Sep 09 to 19 Sep 09 Time 1
Event 291193 Dates 10 Oct 09 Time 2
Event 299590 Dates 10 Oct 09 Time 3
Event 299587 Dates 19 Sep 09 Time 4

They are not coming out in date order!

I tried asort() too. It retains the key, but the sort order is the same
Event 295999 Dates 19 Sep 09 to 20 Sep 09 Time 1253314804
Event 291827 Dates 18 Sep 09 to 19 Sep 09 Time 1253228403
Event 291193 Dates 10 Oct 09 Time 1255129202
Event 299590 Dates 10 Oct 09 Time 1255129201
Event 299587 Dates 19 Sep 09 Time 1253314800

Welcome to the forums,

pr0gr4mm3r — Wed, 16 Sep 2009 11:38:22 +0000

Welcome to the forums, jbudd! Try something like this...

<?php
/* fetchs the XML from a local file */
$data = file_get_contents('data.xml');

/* parse the XML into a PHP object */
$xml = new SimpleXMLElement($data);

/* loop through all the items in the feed */
$items = array();
foreach ($xml->item as $field => $item)
{
    /* grab the first date and process it into a timestamp */
    if (strpos($item->Dates, ' to ') !== false)
    {
        $date = explode(' to ', $item->Dates, 2);
        $time = strtotime($date[0]);
    }
    /* if there is only one date, no need to split it up */
    else
    {
        $time = strtotime($item->Dates);
    }
    
    /* for debugging purposes
    echo 'Original: ' . $item->Dates . "\n";
    echo 'Time: ' . $time . "\n";
    echo 'Formatted: ' . date('r', $time) . "\n";
    */
    
    /* add the item to a new array, with the timestamp as the key, 
       so we can sort it later */
    $items[$time] = $item;
}

sort($items);

/* see what we got */
header('Content-type: text/plain');
var_dump($items);
?>

I'm basically getting the start date, and converting it to a timestamp. Then form a new array of items, with that the timestamps as the keys, and sort.

If you want to run the example, make sure to save your XML data in the above mentioned XML file.

well first I do this $xml =

jbudd — Tue, 15 Sep 2009 23:57:02 +0000

well first I do this $xml = simplexml_load_file($xmlfeed);

and I suspect I need to insert a new attribute unixtime to sort with?

something like
$xml->item[something]->addAttribute("unixtime", strtotime(preg_replace('/to.*/','',$xml->item[something]["Dates"])));

I dont know how to add that to each item though.