[ronlar]

I have a PHP page which creates a temporary directory, copies 1 file to that directory and inserts an entry in MySQL.

I want another PHP page to select all the entries in MySQL which are inserted more than 10 minutes ago, delete the files/directories and then delete the entries in MySQL.

The following code works, but it deletes only one file/directory at a time and also deletes the entry in MySQL. How can I make it delete all the selected files/directories at the same time and delete all the entries in MySQL?

Code:

<?php

include("settings.php");

$link = @mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
$database = mysql_select_db(DB_NAME);
$sql = "SELECT * FROM temp WHERE DATE_ADD(time, INTERVAL 10 MINUTE) < NOW()";
$result = mysql_query("$sql");
while ($out = mysql_fetch_array($result)) {
   $dirname = $out['directory'];
   $filename = $out['filename'];
}
mysql_close($link);

$file = "$dirname/$filename";

if(file_exists($file))
unlink($file);

rmdir($dirname);

$link = @mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
$database = mysql_select_db(DB_NAME);
$sql = "DELETE FROM temp WHERE directory = '$dirname'";
mysql_query("$sql");
mysql_close($link); 

?>

[FiRe]

put the code in the loop

[ronlar]

What kind of loop should I use and how do I insert the loop?

I have tried different ways, but none of them works, I only receive error messages.

[ronlar]

The matter is solved. By placing the code inside the while loop it works perfect.

Code:

<?php

include("settings.php");

$link = @mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
$database = mysql_select_db(DB_NAME);
$sql = "SELECT * FROM temp WHERE DATE_ADD(time, INTERVAL 10 MINUTE) < NOW()";
$result = mysql_query("$sql");
while ($out = mysql_fetch_array($result)) { 
   $dirname = $out['directory'];
   $filename = $out['filename'];

   $file = "$dirname/$filename";

   if(file_exists($file))
   unlink($file);

   rmdir($dirname);
   
   $link = @mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
   $database = mysql_select_db(DB_NAME);
   $sql = "DELETE FROM temp WHERE directory = '$dirname'";
   mysql_query("$sql");
}

mysql_close($link);

?>