Sort by date rather than name

[chrisdee]

Hello. The script below outputs mp3 files from a directory and sorts the output by name. I would like it to sort the output by date rather then by name. I have a variable $datec in my script that checks when the mp3 files are created. Can this be used ? Help is greatly apreciated ?

<?php 
$myFiles=array(); 
$homedir = "music/cd/normal"; 
$dir = opendir("$homedir"); 
while(FALSE !== ($file = readdir($dir))) { 
 if($file=="." || $file==".."||$file=="index.php"||$file=="music.php"||ereg("index|html|doc|instrumental|normal",$file)) { 
 } else { 
  $myFiles[] = "$file"; 
 } 
} 
closedir($dir); 
sort($myFiles); 

echo "<table>"; 
echo "<tr><td colspan=4><b>Christian</b></td></tr>"; 
$heading = array("Nr","Song","Size","Date (Created)"); 
echo "<tr>"; 
foreach($heading as $head_value) { 
 echo "<td class=nav2>$head_value</td>"; 
} 
echo "</tr>"; 

foreach($myFiles as $value) { 

 $sjekk_size = stat("music/cd/normal/$value"); 
 $size = $sjekk_size['size']; 

 $sjekk_date = stat("music/cd/normal/$value"); 
 $datec = $sjekk_date['mtime']; 

 $counter_cd2++; 

 $del = split("-",$value); 

 echo "<tr> 
    <td class=nav1>$counter_cd2</td> 
    <td class=nav1><a class=cd href=music/cd/normal/$del[0]>" . substr($del[0],0,-4) . "</a></td> 
    <td class=nav1>" . substr("$size",0,-6) . "," .  substr("$size",1,-5) . " MB</td> 
    <td class=nav1>" . date("d.m.Y",$datec) . "</td> 
    </tr>"; 
} 
echo "</table>"; 
?> 

[Weedpacket]

You'll need to record the date of each file along with the filename. Making each entry of $myFiles an array will do that:

$myFiles[] = array('name'=>$file, 'date'=>/*get date of file*/);

(P.S., in that loop, [man]continue[/man] would be a tidier choice over what you're doing).

Then using [man]usort[/man] instead of sort, you can specify any comparison rule you want.

Another possibility (tacky, silly, and probably not recommended) would be to write

$myFiles[$file]=/*insert date here*/;

then [man]asort[/man] to sort (by value, i.e. date) and [man]array_keys[/man] to get the keys (i.e., the filenames).

[chrisdee]

Am afraid i dont understand. How do I implement that in my script ?

[Weedpacket]

I thought I said:

$myFiles[] = array('name'=>$file, 'date'=>/*get date of file*/); 

and

using usort instead of sort,

[chrisdee]

I guess this was harder than expected.
Thank you for all your suggestions, but im afraid im such
a newbie that I need an complete example.

[Weedpacket]

<?php
function sort_by_date($a,$b)
{
	return $a['date']-$b['date'];
}
$myFiles=array();
$homedir = "music/cd/normal";
$dir = opendir("$homedir");
while(FALSE !== ($file = readdir($dir))) {
if($file=="." || $file==".."||$file=="index.php"||$file=="music.php"||ereg("index|html|doc|instrumental|normal",$file))
	continue;
  $myFiles[] = array('name'=>$file, 'size'=>filesize($file), 'date'=>filectime($file));
}
closedir($dir);
usort($myFiles,'sort_by_date');

echo "<table>";
// Read the HTML spec where it describes the "<th>" element.
echo "<tr><td colspan=4><b>Christian</b></td></tr>";
$heading = array("Nr","Song","Size","Date (Created)");
echo "<tr>";
foreach($heading as $head_value) {
echo "<td class=nav2>$head_value</td>";
}
echo "</tr>";

foreach($myFiles as $value) {
echo "<tr><td>",$value['name'],"</td><td>",$value['size'],"</td><td>",$value['date'],"</tr>";
}
echo "</table>";
?> 

Remember, that's your code, so you should be able to figure out what it's doing.

[chrisdee]

Hello again. Thank you for your suggestion. However, I get an error messag
when I try to run it :

Warning: filesize() [function.filesize]: stat failed for CallingOut.mp3 in /var/www/administrator/music/cd/norm.php on line 12

Cant figure out why.

[chrisdee]

Below iv tried to make a function wich sorts the date, but
I cant get that to work either. Iv also changed the date output so it only shows the year, thinking this would make sorting easier. Sorry for nagging, but does anybody have any ideas ?

The idea is to get the script to sort after date, with the newest songs first.

<?php 
function sort_music($a,$b) { 
 return $a['date'] > $b['date']; 
} 

$myFiles=array(); 
$homedir = "music/cd/normal"; 
$dir = opendir("$homedir"); 

while(FALSE !== ($file = readdir($dir))) { 
 if($file=="." || $file==".."||$file=="index.php"||$file=="music.php"||ereg("index|html|doc|instrumental|normal",$file)) { 
 } else { 
  $myFiles[] = "$file"; 
 } 
} 
closedir($dir); 
usort($myFiles,'sort_music'); 

echo "<table>"; 
echo "<tr><td colspan=4><b>Christian</b></td></tr>"; 
$heading = array("Nr","Song","Size","Date (Created)"); 
echo "<tr>"; 
foreach($heading as $head_value) { 
 echo "<td class=nav2>$head_value</td>"; 
} 
echo "</tr>"; 

foreach($myFiles as $value) { 

 $sjekk_size = stat("music/cd/normal/$value"); 
 $size = $sjekk_size['size']; 

 $sjekk_date = stat("music/cd/normal/$value"); 
 $datec = $sjekk_date['mtime']; 

 $counter_cd2++; 

 $del = split("-",$value); 

 echo "<tr> 
    <td class=nav1>$counter_cd2</td> 
    <td class=nav1><a class=cd href=music/cd/normal/$del[0]>" . substr($del[0],0,-4) . "</a></td> 
    <td class=nav1>" . substr("$size",0,-6) . "," .  substr("$size",1,-5) . " MB</td> 
    <td class=nav1>" . date("Y",$datec) . "</td> 
    </tr>"; 
} 
echo "</table>"; 
?>