如何一次删除多条记录？

Question

In Php as we all know, there are no inbuilt controls by itself like Asp.Net's GridView etc. I am using Html's <table> to build up the grid and keep the row's id in one hidden field. I've also placed one checkbox at the beginning of each row and a delete button at the bottom of the grid. The problem i face is, how do i get all the id's that are checked so that i can pass those ids in my IN clause of Delete?

Answer 1

First you name all your checkboxes by suffixing [] in their name so that an array gets created, later this is how you can get those that are checked and act accordingly:

for($i = 0; $i < count($_POST['checks']); $i++)
{
  if (isset($_POST['checks'][$i]))
  {
     // this was checked !!
  }
}

Where checks is the name of all those checkboxes eg:

<input type="checkbox" name="checks[]" value="1" />
<input type="checkbox" name="checks[]" value="2" />
<input type="checkbox" name="checks[]" value="3" />

And this is how you can get those for your IN clause in your query:

$checked_array = array();

for($i = 0; $i < count($_POST['checks']); $i++)
{
  if (isset($_POST['checks'][$i]))
  {
     $checked_array[] = mysql_real_escape_string($_POST['checks'][$i]);
  }
}

// build comma separated string out of the array
$values = implode(',', $checked_array);

Now you can use the $values in your IN clause of your query.