[RESOLVED] How can I sort this xml list?

[sgtpepper]

I have to create an rss feed based on mp3 files placed on a 3rd party server. So, here is the code I am using to generate the xml file.

<?php
$ftp_host = "mysite.net";
$ftp_user = "myuser";
$ftp_password = "mypass";
//Connect
$conn = ftp_connect($ftp_host);
$login = ftp_login($conn, $ftp_user, $ftp_password);
//////start the rss feed
$rssfile = fopen("alkulusrss.xml", "w");
fwrite($rssfile, "<?xml version='1.0' encoding='iso-8859-1'?>
<rss version='2.0'>
<channel>
<title>Best of </title>
<description>podcasts</description>
<language>en-us</language>");

//////// end first part od rss fil
//
//Enable PASV ( Note: must be done after ftp_login() )
//
$mode = ftp_pasv($conn, TRUE);

ftp_chdir($conn,"/thisdir/thatdir/fileshere/");

//Login OK ?
if ((!$conn) || (!$login) || (!$mode)) {
  die("FTP connection has failed !");
}
//
//Now run ftp_nlist()
//
$file_list = ftp_nlist($conn, "");
foreach ($file_list as $file)
{
//print "
//<a href='http://www.mysite.com/$file'>$file</a><br>";
//}
fwrite($rssfile, "<item>
<title>$file</title>
<link>http://www.mysite.com/$file</link>
</item>");
}
//end of while loop
fwrite($rssfile, "</channel></rss>");
fclose($rssfile);
//close
ftp_close($conn);
?>

The problem is that I want to be able to sort the files based on uploaded date. How can I sort the files and have the xml file show the newest files first in the list??

Thanks for the help....

[NogDog]

You might be able to do it by using [man]ftp_rawlist/man. You would then need to analyze the format which the target server uses to output each line, then come up with a callback function for [man]usort/man to sort the array by the date value in each array element, and then also how to grab just the filename from each element for your output routine.

[sgtpepper]

Thanks! That was very helpful.

By changing my code to

$file_list = ftp_rawlist($conn, "");

usort($file_list);

I am getting more data to work with....for example now I see....

-rw-r--r-- 1 username-wm cust 7999808 Jun 3 12:30 file1.mp3
-rw-r--r-- 1 username-wm cust 6671728 Jun 3 13:09 file2.mp3
-rw-r--r-- 1 username-wm cust 57347392 May 25 19:28 file3.mp3

I guess I am confused on how to create the usort to sort this list based on newested file first.....and also change the output to include the date/time and filename.

How do I structure the usort for this?

Thanks for the help

[NogDog]

<?php
// sample data
$text = array(
   '-rw-r--r-- 1 username-wm cust 7999808 Jun 3 12:30 file1.mp3',
   '-rw-r--r-- 1 username-wm cust 57347392 May 25 19:28 file3.mp3',
   '-rw-r--r-- 1 username-wm cust 6671728 Jun 3 13:09 file2.mp3'
);
// callback sort function:
function mySort($a, $b)
{
   $filetime = array();
   $values = array($a, $b);
   foreach($values as $ix => $val)
   {
      $parts = preg_split('/\s+/', $val);
      $mon = $parts[5];
      $day = $parts[6];
      $time = $parts[7];
      if(strpos($time, ':') === FALSE)
      {
         $year = $time;
         $time = '00:00';
      }
      else
      {
         $year = date('Y');
      }
      $filetime[$ix] = strtotime("$mon $day, $year $time");
   }
   return($filetime[1] - $filetime[0]);
}
// do the sort:
usort($text, 'mySort');
// show the results:
printf("<pre>%s</pre>", print_r($text, 1));

[sgtpepper]

Wow....thanks.

This is doing exactly what I was hoping for. I'll study the code so I can learn from this. I do have one question though...

I am still seeing...

-rw-r--r-- 1 usernam cust 10304240

How can I alter the code so I only see the filename?

Thank you so much!

[NogDog]

Since it's the last field in each line, we can use preg_split() again, and pop off the last element of the resulting array:

<?php
// test data:
$text = array(
   '-rw-r--r-- 1 username-wm cust 7999808 Jun 3 12:30 file1.mp3',
   '-rw-r--r-- 1 username-wm cust 57347392 May 25 19:28 file3.mp3',
   '-rw-r--r-- 1 username-wm cust 6671728 Jun 3 13:09 file2.mp3'
);
// callback sort function:
function mySort($a, $b)
{
   $filetime = array();
   $values = array($a, $b);
   foreach($values as $ix => $val)
   {
      $parts = preg_split('/\s+/', $val);
      $mon = $parts[5];
      $day = $parts[6];
      $time = $parts[7];
      if(strpos($time, ':') === FALSE)
      {
         $year = $time;
         $time = '00:00';
      }
      else
      {
         $year = date('Y');
      }
      $filetime[$ix] = strtotime("$mon $day, $year $time");
   }
   return($filetime[1] - $filetime[0]);
}
// sort by file date-time, descending:
usort($text, 'mySort');
// output sorted files:
echo "<ul>\n";
foreach($text as $file)
{
   printf("<li>%s</li>\n", array_pop(preg_split('/\s+/', $file)));
}
echo "</ul>\n";
// debug data to validate we got the right sort order:
printf("<pre>%s</pre>", print_r($text, 1));

[sgtpepper]

This is great....thank you. preg_split still is a little confusing to me. I guess I dont understand how it performs the split. I have been going through the manual and still am confused.

For example.....what if the filename has spaces. I know....typically I never use spaces in unix.....but these are uploaded files and others are not UNIX people.

So, if the file name is

24JUL07 Sen John McCain.mp3

I get the output of McCain.mp3 after going through preg_split.

How can I get the complete file name even with spaces....or do I have to convert the files to no spaces?

[NogDog]

foreach($text as $file)
{
   $parts = preg_split('/\s+/', $file);
   $filePart = array_slice($parts, 8);
   $fileName = implode(' ', $filePart);
   echo "<li>$fileName</li>\n";
}

Or, if you like dense, harder-to-read code:

foreach($text as $file)
{
   printf("<li>%s</li>\n", implode(' ', array_slice(preg_split('/\s+/', $file), 8)));
}

[sgtpepper]

Thanks....this is working great. I'll learn from the code....thanks!