[RESOLVED] trouble with deleting multiple checkbox

nuttynibbles

hi, i've tried everything i search online on deleting multiple chckbox but could not succeed. these are my code:

//make checkbox
while($row = mysql_fetch_array($recordsCount, MYSQL_ASSOC)) {
$strUserID = $row['userID'];
<td><input type='checkbox' id==\'chkDelete\' name=\'chkDelete[]\' value=\'".$strUserID."\'></td>";

..
}

what can i do to delete my checkbox?

pls help. tks

bradgrafelman

I don't see any echo or print command.. you just start with raw HTML. Obviously you'll want to fix that.
You end that line with a double quote, so I'm guessing that you're going to use double quotes as your string delimiter? If that's the case, why did you escape single quotes?
ID's for HTML elements should be unique... either get rid of the id, or make it unique for each checkbox. While you're fixing that id, make sure you get rid of one of the equal signs there.
I don't get your question... you're trying to delete teh checkbox? Do you mean delete the user ID's that are checked and submitted via a form? If that's the case, you could use the [man]implode/man command like so:
```
$id_list = mysql_real_escape_string(implode(',', $_POST['userID']));
$query = "DELETE FROM users WHERE userID IN ($id_list)";
```

nuttynibbles

pardon me for not explaining things in details.

1)i created the checkbox using a while loop whereby i extract all the userID, and input into the checkbox. im using smarty that is why i return the html code as string.
so the code should look like this:
//make checkbox
function makeContent()
{
$str="<table bordre=0...>";
$str.="<tr>";
$str.="<td></td>";
$str.="</tr>";
...
while($row = mysql_fetch_array($recordsCount, MYSQL_ASSOC)) {

$strUserID = $row['userID'];//extract all customer details
$age= $row['age'];
$str.="<td><input type='checkbox' id='chkDelete[]' name='chkDelete[]' value='$strUserID'></td>";
$str.="<td>."$strUserID."</td>
$str.="<td>."$age."</td>
...
}//end of while loop
$str.="</table>";
return $str;
}

i can display the checkbox. however i could not delete the selected multiple 'checked' check box.

2)so the code u provide, is it sufficient? 😉

nuttynibbles

this is wat i did to delete :

if(isset($btnDelAll)) {

$did_array = $_POST['chkDelete'];
foreach($did_array as $did) {

$getID = implode(",", $did);

}

$query = mysql_query("DELETE FROM userinfo_tbl WHERE userID IN ($getID)");

}
it's giving me this error Warning: Invalid argument supplied for foreach()

nuttynibbles

oh well because im using smarty, i somehow just leave <form> without attribute like action, method and name. i did not use for loop. i just did

$did_array = $_POST['chkDelete'];
$getID = implode(",", $did_array);

$query = mysql_query("DELETE FROM userinfo_tbl WHERE userID IN ($getID)");

and the reason i got the warning error is because I did not validate if the checkbox is checked. cannot implode an empty array

bradgrafelman

Don't forget to use [man]mysql_real_escape_string/man on all user-supplied data before using it in a MySQL query, else you're leaving yourself vulnerable to SQL injection attacks.