[RESOLVED] foreach query error

notaloser

here is what i want. a page that displays a bunch of images, each with a checkbox. which ever ones are selected when the submit button is pressed get deleted. i have the query to delete the entry in the database, and i can easily add the code to delete the actual image file.

it gives me this error:

Warning: Invalid argument supplied for foreach() in /home/n3graphics/domains/n3graphics.com/public_html/notaloser/caha/admin/rempics.php on line 95

line 95 is the foreach statement.. does anyone know whats wrong?

while ($kidsfetch = mysql_fetch_array($kidsquery)) { 



	    echo "<td width='".$divide."'><div align='center'><input type='checkbox' name='delbox' value='".$kidsfetch[id]."'><img src='http://n3graphics.com/notaloser/caha/uploads/".$kidsfetch[filename]."' width='100' height='100' alt='".$kidsfetch[caption]."' border='0'></td>\n"; 
		$count++; 

    			} 



echo "<input type='submit' name='delete' value='Delete Selected'>";

if(($_POST['delete']) && isset($_POST['delbox'])) { 

foreach($_POST['delbox'] as $dkey) {  
$deletequery = mysql_query("DELETE FROM gallery WHERE id='".$dkey."'"); 
}  

}

devinemke

change this:

name='delbox'

to this:

name='delbox[]'

notaloser

haha wow, ok well i just found out i don't know how to delete files off of ftp. here is what i have that does not work, right now im just trying to get it to delete a test file, text.txt.

if(($_POST['delete']) && isset($_POST['delbox'])) { 

$ftpconn = ftp_connect("**.**.**.**") or die("Could not connect");
ftp_login($ftpconn,"********","*******");
ftp_chdir($ftpconn,"/home/n3graphics/domains/n3graphics.com/public_html/notaloser/caha/uploads/");


foreach($_POST['delbox'] as $dkey) {  
$deletequery = mysql_query("DELETE FROM gallery WHERE id='".$dkey."'"); 
echo ftp_delete($ftpconn,"text.txt");
ftp_close($ftpconn);
header("Location: rempics.php");
}  

}

right now, it deletes the entry in the database only. i want it to delete test.txt for this particular test, and i will change it so it deletes all selected files once i get this working.

anyone?

devinemke

do the files you wish to delete reside on the same physical machine/filesystem that the script is on? if so then there is no need to connect via FTP.

notaloser

oh ok, well yes they are on the same machine. they are in a folder that is inside the parent folder of this file i posted.

how do i go about deleting them then?

devinemke

loop thru the $_POST['delbox'] array and feed the full path of each file to [man]unlink[/man]

notaloser

thanks a lot man.

last problem. im trying to link the full path to it, but i cant figure out the correct snytax for the directory.

on the server directly its

http://n3graphics.com/home/n3graphics/domains/n3graphics.com/public_html/notaloser/caha/uploads

and in the browser it is

http://n3graphics.com/notaloser/caha/uploads

how do i arrange this?

	unlink("http://n3graphics.com//home/n3graphics/domains/n3graphics.com/public_html/notaloser/caha/text.txt")
	or die(mysql_error());

devinemke

don't feed the URL to unlink, feed the absolute filesystem path. your earlier code example suggests that it is:

unlink('/home/n3graphics/domains/n3graphics.com/public_html/notaloser/caha/uploads/text.txt');

notaloser

thanks a lot man, ive got everything working now