Deleting obsolete files from database

[jonki]

I have a serious problem space on my server and due to my learning php as I go have quite a few obsolete files on my server.
These are files uploaded by clients of mine and all I want to do is to write a small program to delete files not found in the database.

I thought basically something along the lines of:

$filename = ???????

Select * from database where filename=$filename etc

$result = num_rows etc

if(empty($result)) { unlink $filename ; }

The coding I can do - I just need that first bit - how do I run through all the files in a folder and access the filename?

Should be simple......

Thanks

[devinemke]

the basic idea:

<?php
$path = '/path/to/files/';

$handle = opendir($path);
while (($filename = readdir($handle)) !== false)
{
	if ($filename != '.' && $filename != '..')
	{
		$file_array[] = $filename;
	}
}

$result = mysql_query('SELECT filename FROM table');
while ($row = mysql_fetch_assoc($result))
{
	$db_file_array[] = $row['filename'];
}

$old_files = array_diff($file_array, $db_file_array);
foreach ($old_files as $value)
{
	$unlink = unlink($path . $value);
	if ($unlink) {echo 'DELETE OK';} else {echo 'DELETE FAILED';}
	echo ' ' . $value . '<br>';
}
?>

[jonki]

Thanks a lot for your help. Some of it was a bit above my level of php so I used your ideas and came up with this.
It is more simplistic and maybe takes up more processing time but as I only need to do this rarely, I don't mind so much.

This works - except that I get permission denied.

Thanks again for your help.

<?

include("connect.php");

$path = $_SERVER['DOCUMENT_ROOT'] . '/fotos_coches_test/'; 

$handle = opendir($path); 
while (($filename = readdir($handle)) !== false) 
{ 
    if ($filename != '.' && $filename != '..') 
    { 
        $file_array[] = $filename; 
    } 
} 

foreach ($file_array as $value) 
{ 
echo "<br><br><br>"; echo "This is the file we are working on: ";echo $value; echo "<br>";
$query = "SELECT * FROM `test` WHERE foto = '$value' OR foto2 = '$value' OR foto3 = '$value' OR foto4 = '$value'";
$result = mysql_query($query); 
$number = mysql_num_rows($result); 
echo" This is how many entries were found in the database with a name "; echo $value; echo" : "; echo $number; echo "<br>";

if(empty($number) OR $number=='0')
	{
	echo " No entries were found therefore we shall attempt deletion"; echo "<br>";
    $unlink = unlink($path . $value); 
    if ($unlink) {echo 'DELETE OK <br>';} else {echo 'DELETE FAILED <br>';} 
    echo ' ' . $value . '<br>'; 
	}
else { echo " One or more entires found: Deletion of file skipped <br>";}
} 





?>

[devinemke]

Originally posted by jonki
...and maybe takes up more processing time...

it certainly will, if you have 1000 files in your directory your version will have to execute 1000 queries to the database, whereas my version will only need one.