[SOLVED] multiple checkbox deleting

[coupe-r]

I am trying to delete multiple items using check boxes.  Everything is OK except when I select more than 1.

 

if(isset($_POST['delete_btn']))

{

    foreach($_POST['checkbox'] as $value)

    {

          $checked = $value

          $query1 = "DELETE FROM tickets WHERE t_id = '".$checked."'";

          $query2 = "DELETE FROM problems WHERE t_id = "'. $checked.'"";

    }

}

 

I am echoing out the SQL statements and no matter what, it only deletes the first box I select.  I can append (  .=  ) any / all of the vars in the loops, but still deletes 1 record?

[Cosizzle]

I don't think you need to append the $checked. Are your check boxes in an array? Also just for testing purposes what happens if you run this?

 

<?php
if(isset($_POST['delete_btn']))
{
     foreach($_POST['checkbox'] as $value)
     {
         echo $value;
     }
}
?>

[coupe-r]

When I echo $value, it only reads the last check box I clicked.  if you have check boxes 1 - 10, it will echo 10

[Cosizzle]

what does your <input> look like?

 

should be something like:

for ($i = 0; $i < 10; $i++) {
     echo "<input type='checkbox' name='myValues[]' value='$i'>";
}

[coupe-r]

while($row=mysql_fetch_array($result))

 

<input type="checkbox" name="checkbox[]" id="checkbox" value="'.$ticket.'"/>

[Cosizzle]

and whats $ticket? or the value of it? whats it look like if you look at the source (webpage online)

 

sorry for the silly questions... this is how i'd debug this. (Had a similar problem recently that i got working... eventually)

[coupe-r]

$ticket is the ticket_ID number.

 

Viewing page source shows  ...... value="25"

 

This is perfect.  Value is 25 for the check box beside ticket 25 on the screen.

 

When I try to delete 2 or more tickets at the same time, it only deletes 1, the first one.

 

Deleting 1 at a time works, but a pain in the ass.

[Cosizzle]

and your executing the queries outside the foreach loop right?

 

Is it possible to execute them within the foreach loop?

 

@mysql_query($query1);

@mysql_query($query2);

 

 

 

[premiso]

if(isset($_POST['delete_btn']))
{
     $checked = array();
     foreach($_POST['checkbox'] as $value) {
          $checked[] = $value
     }

     $query1 = "DELETE FROM tickets WHERE t_id IN (" . implode(", ", $checked) . ")";
     $query2 = "DELETE FROM problems WHERE t_id IN (" . implode(", ", $checked) . ")";

}

 

That should delete all checked records with ease.

[coupe-r]

Still only deletes 1 row within the site, however...

 

Now, I pasted the SQL statement in mySQL, it deletes 1 row, but I get an error as well.

 

"Truncated incorrect DOUBLE value:'32, 33, 34'  "

 

Not sure what this is.

[premiso]

if(isset($_POST['delete_btn']))
{
     $checked = array();
     foreach($_POST['checkbox'] as $value) {
          $checked[] = intval($value);
     }

     $query1 = "DELETE FROM tickets WHERE t_id IN (" . implode(", ", $checked) . ")";
     $query2 = "DELETE FROM problems WHERE t_id IN (" . implode(", ", $checked) . ")";

}

 

Try that and see. Also check what type the t_id field is. If it is a double, it will expect a double not an INT. And should it be a double? If the t_id field is an INT field then the above should work by converting the value coming from the form into an integer.