[Resolved] Unsure using sql with dynamic check boxes

james_cwy

I am using a for loop to have generated a number of input boxes.
Lets say for example:
del1,del2,del3
Now I need to check whether they are checked or not.
This is what I used:
$delnum=3 got from previous form.

for ($i=1;$i<=$delnum;$i++) {
if (isset($_POST['del'.$i]));
{
$sql = "DELETE FROM Part WHERE P=$??";
$deleteresult = mysql_query($sql);
}

My question here is:
How do I code the $sql line?

cahva

Maybe the simpler way is to loop through $POST(ofcourse dont take the result from submit button and others that you dont want):

foreach ( $_POST as $key=>$val ) {
if (strstr($key,'del')) {
$sql = "DELETE FROM Part WHERE P='".$value."'";
mysql_query($sql);
}
}

tdomega

or try to name your ceckboxes del[0],del[1],del[2] and you will have a del-array which you can use

$del= $_POST["del"];
if($del[0]){ $sql = "DELETE FROM Part WHERE P=".$del[0]; }

james_cwy

Thanks for the guide.
I have been trying all the ways I can and also your ways but it will still not delete.
I have tried renaming to arrays and all still nope.
My code:
deletea.php:
<form method="post" action="delete.php" >
...........................
while loop...to create dynamic check boxes
<input type="checkbox" name="del<?php echo $i;?>"><?php echo $P;?><p>
..........................

delete.php
<?php
//connect to db, etcc
foreach ($_POST as $key=>$val)
{
if (strstr($key,'del')) {
$sql = "DELETE FROM Part WHERE P ='".$value."'";
mysql_query($sql);
}
}

Am I doing something wrong? PLs advise

LordShryku

Here's another idea. Create a posted array to delete. I assume $P in your below post is unique? If so, this should work for you...

<form method="post" action="delete.php" >
...........................
while loop...to create dynamic check boxes
<input type="checkbox" name="del[]" value="<?php echo $P;?>"><?php echo $P;?><br />

This create an array called del to delete. You set the values to delete by using the value attribute in the checkbox. Then on the next page, just do this:

foreach($_POST['del'] as $del ) {
   $sql = "DELETE FROM Part WHERE P='".$del."'";
   mysql_query($sql);
}

james_cwy

Thank you all for your help and also
LordShryku.

Really appreciate all you effort in helping out.

Thanks a million
James