how to delete selected record

[manojhooda]

How to delete selected record with checkbox in php.

please help me with example code.

[Yesideez]

Let's say you have a checkbox and it's value represents the ID number of a table in your database:

<input type="checkbox" name="mycheck" value="24">

 

We can check if it has been ticked and if yes, use the value from it to delete a record:

if ($_POST['mycheck']) {
  $checkval=$_POST['mycheck'];
  if (mysql_query("DELETE FROM table WHERE id=".$checkval." LIMIT 1")) {
    echo 'Deleted';
  } else {
    echo 'Not deleted';
  }
}

[Stephen68]

Not sure if would use checkbox for this kind of thing for the user could pick a few checkboxes if you where

giving them multi choices. Maybe I would suggest a radio button maybe? just my 2 cents

 

 

[jackpf]

I personally only use checkboxes for deleting multiple stuff, like emails/private messages.

 

I'd use a hyperlink and $_GET to delete single records. As in <a href="?delete=24">delete</a> and then $id = $_GET['delete']; and proceed with deletion...

[Stephen68]

ya that is the way I do it as well, I just thought he wanted to use some kind of checkbox for it

[jackpf]

Lol yeah, it doesn't really make sense to use a checkbox for one record though.