checkbox arrays

lobster

Have a form that allows the user to check a box if they want that picture deleted...
it loops through a number of times.

<input type='checkbox' name='pictbox[$p]'>

then would get processed in other page with the following code (if it worked) any ideas on what I am doing wrong? I am just now getting used to arrays a little:

     for($x=1; $x<13; $x++){
		if($_POST['pictbox'][$x] == "on"){
			$pictquery = mysql_query("SELECT * from media WHERE media_pk = $medid AND display_order = $x");
			$pictqrow = mysql_fetch_array($pictquery);
			$thisfile = $pictqrow['filename'];
			$unlink = unlink("../picts/$thisfile");
			$dpict = mysql_query("DELETE * from media WHERE media_pk = '$medid' AND display_order = $x");
		}
   }

Drakla

It looks fine - have you printed any errors?

Notice in the one query you're putting $medid in quotes, in the other not.

Also it's a good idea, especially for expansion to use textbox arrays like this:

Then in your program you can just go through the array as

foreach ($_POST['pictbox'] as $index)
{
    $q = "DELETE FROM something WHERE id = $index";
}

You'll have to check if pictbox is set in post first in case none have been set.

lobster

I think that is where I got confused. Not sure how to tell if $pictbox[] $x is checked.

Will it only catch the ones that are checked in the foreach loop?

Drakla

yes, the value of index in the foreach will be the $x for only the ticked checkboxes. If none are ticked the $_POST['pictbox'] won't even be set.

Do a little test script with echo '<pre>'; print_r($_REQUEST); echo '</pre>; in the top that has a checkbox array and submits back to itself, you'll soon be a master of it.

lobster

still working with this issue...

Have the following code:

	   foreach($pictbox as $key => $value){
			$dpquery = mysql_query("DELETE from media WHERE item_pk = '$itemid' AND display_order = '$value'");
			$filename = $itemid."_".$value.".jpg";
			$unlink = unlink("../picts/$filename");
		}

getting this error:

Call to undefined function: mysql_query()

Any ideas?