show all files in a directory on a page

Question

Possible Duplicate:
PHP list all files in directory

ive got a cron job running creating .xls files every 24hrs, they are creating them in a directory on my site called www.mysite.com/sheets

what i want to do is make a webpage where i can go to and see all the .xls files in that directory and download the ones i was instead of having to download them using an ftp client.

Is there a name for this sort of thing ? what would i write it in ? i was thinking i could do it in php by echoing the folders contents, would that work ?

cheers

possible duplicate of [PHP list all files in directory](http://stackoverflow.com/questions/3826963/php-list-all-files-in-directory), [PHP - Code to traverse a directory and get all the files(images)](http://stackoverflow.com/questions/3608202/php-code-to-traverse-a-directory-and-get-all-the-filesimages), and many many other identical questions. — salathe, Jan 28 '12 at 19:12
perhaps you are looking for scandir function of php.. [Read Description From php.net](http://php.net/manual/en/function.scandir.php) — Rajat Singhal, Jan 28 '12 at 19:11

score 0 · Answer 1 · answered Jan 28 '12 at 19:14

0

Use glob() plus some filtering for xls files.

glob("*.xls")

answered Jan 28 '12 at 19:14

Elzo Valugi

27,240
15
95
114

thanks, do you know where in this script i would put that ? '); $d = opendir($c); while($f = readdir($d)) { if(strpos($f, '.') === 0) continue; $ff = $c . '/' . $f; echo('
' . $ff . '

user1037444

Jan 28 '12 at 19:30

salathe · Answer 2 · 2012-01-28T19:25:19.977

0

Potentially useful resources (in order of preference):

Manual

edited Jan 28 '12 at 19:25

answered Jan 28 '12 at 19:19

salathe

51,324
12
104
132

thanks, I've found this script any idea how id change it to only show the .xls files ? '); $d = opendir($c); while($f = readdir($d)) { if(strpos($f, '.') === 0) continue; $ff = $c . '/' . $f; echo('
' . $ff . '

user1037444

Jan 28 '12 at 19:27

I'm not a fix-your-script kind of guy. Please take the time to read the resources available, and the many, many identical questions here on SO. – salathe Jan 28 '12 at 19:28

Sbhklr · Accepted Answer · 2012-01-28T19:33:07.583

You could activate directory listing within your webserver, or you can use a function like glob("*.xls") to list the files and echo their path on the webserver or you can send a file to the browser like this:

<?php
$filename = "path/to/your/file.xls";
$real_filename = "file.xls";
header('Content-Transfer-Encoding: none');
header('Content-Type: application/octet-stream; name="' . $real_filename . '"');    
header('Content-Disposition: attachment; filename=' . $real_filename);                
$size = @filesize($filename);
if ($size > 0) {
    header('Content-length: '.$size);
} else {
    header('Content-length: '.@strlen(@file_get_contents($filename)));
}
readfile($filename);
exit;
?>

If you want to list a directory use this:

$handle = opendir("./");
while (false !== ($file = readdir($handle))) {
    $fileinfo = pathinfo($file);
    if (strtolower($fileinfo[extension]) == "xls") {
        echo $file;    
    }
}
closedir($handle);

Or this:

foreach (glob("*.[xX][lL][sS]") as $filename) {
    echo $filename;
}

show all files in a directory on a page

3 Answers3