[Resolved] Delete multiple files when deleting many rows in a table

bengt

When I delete rows in a table, i use this code

if (!$delete_list) {

//Ingen nyheter er valgt for å slettes
echo("<p>&nbsp;</p><p class=error align=center>Du har ikke valgt noen brukere å slette.</p>");
echo("<p align=center><a href=\"$PHP_SELF?func=brukere&action=list&page=$page\">Tilbake til Liste</a></p>");

} else {

//oppretter en komma separert streng med de idene som skal slettes
$delete = "" . implode( ", ", $delete_list ); 
$ant = count($delete_list);

//Kopler til Database
$connection = @mysql_connect($host, $user, $pass) or die("Could not Connect.");
$db = @mysql_select_db($db, $connection) or die("Could not select database."); 

//Genererer spørring og urfører sletting
$sql = "DELETE FROM news WHERE nid IN ($delete)"; 
$result = @mysql_query($sql,$connection) or die("Kunne ikke utføre spørring."); 

}

and this code is in the listing.

<input class=\"blank\" type=\"checkbox\" name=\"delete_list[]\" value=\"$row[nid]\">

And then to my problem.

This table where I delete the rows from, there is a field called image, wich of course contains a filename. How can i go in to each row, get the filename, and delete that file on every row that I have selected to delete.

patbator

Hello,

if think you have first to select all the filenames from the rows you'r going to delete and loop to unlink() each file.

bengt

Could you give me som coding hints of doing this? I don't have much php experience...

patbator

yep :

$sql = "select filenam FROM news WHERE nid IN ($delete)";
$rs = mysql_query($sql) or die ("Erreur : $sql <BR>"); 
while ($row = mysql_fetch_row($rs)){
	if ($row[0] != "" && file_exists($path . $row[0])) {unlink($path . $row[0]);}
}

hope this could help 😉