URGET!!! multiple deletes with checkboxes!

scbmx

ok lets say i have a file manager with a checkbox next to each file...how can i make it so when the user checks multiple checkboxes, this:

unlink($file);
is done for each selected file?

Sphynx

If you name your checkboxes like below (with the square braces []), it will give you an array of those values on the other side. Kinda like in the following VERY simple example...

<?php
if ($op == ""){
?>
<form action="form.php" method="post">
  <input type="checkbox" value="1" name="var[]"/> One<br>
  <input type="checkbox" value="2" name="var[]"/> Two<br>
  <input type="checkbox" value="3" name="var[]"/> Three<br>
  <input type="hidden" value="go" name="op"><br>
  <input type="submit">
</form>
<?php
}else{

  for ($i = 0; $i <= count($var);$i++){
    mysql_query("DELETE FROM Your_Table WHERE Field = '".$var[$i]."'")
  }
}
?>

You can then move through your array and do a bunch of nifty stuff with each value 😃

cgraz

You could also do it with only one query. This is how I generally do it

$query = mysql_query("DELETE FROM your_table WHERE field IN ('" . implode("','", $_POST['var']) . "')") or die(mysql_error());

Cgraz

cgraz

Sorry, didn't read that you wanted to use unlink() on each file that was selected by a checkbox. I'm guessing your checkboxes are created dynamically. Assign them a name with brackets at the end so it becomes an array, and make sure the value of each checkbox is the image name

<input type="checkbox" name="to_delete[]" value="image1.jpg">
<input type="checkbox" name="to_delete[]" value="image2.jpg"><input type="checkbox" name="to_delete[]" value="image3.jpg">

That's what your html would look like after PHP made your checkboxes. If it was dynamic, you wouldn't input the image name manually for each checkbox, PHP would do it.

Then use a foreach loop to delete each image. You can even check if the file exists first.


foreach($_POST['to_delete'] AS $value) {
  if (file_exists("path/to/file/" . $value) {
     unlink("path/to/file" . $value);
  }
}

Cgraz

scbmx

what if i want to send 2 vars as a pair... like

id_to_delete[]
name_to_delete[]

how could i do that with just one checkbox and one foreach statement?

cgraz

do you want the id from a database for that particular image? what is it you're trying to do. There are ways to do what you want, but if i had a better idea what you were doing there might be a better way of doing it.

Cgraz

scbmx

nevermind, i got it. im trying to update a column in a table, and make a dir through the checkbox. the check box passes the column id, then i select from the database to the the value of "username" in that column then i can do what i want. thanks for all the help!