Multiple Checkbox problems

riscphree · 01-15-2008, 02:27 AM

What I'm trying to do is delete items in a mysql database that are displayed with a simple checkbox. Here is the form that is generated.

Code:

<form action="" method="post">

sql query here

print"<input type="checkbox" class="delete-checkbox" value="{$row['id']}" name="deletebox[]" />";

<input type="submit" name="submit" value="delete messages" />
</form>

Here is the php that I'm using when its POSTED

Code:

if(isset($_POST['submit'])) {
foreach($_POST['deletebox'] as $deletebox1){
mysql_query("DELETE FROM private_messages WHERE id='$deletebox1'") or die(mysql_error());
}
}

However, nothing happens, which seems to be something with the array, but I can't figure it out. I've tried putting something to print out what is in the array that is passed, but it never prints anything out, like its blank. And I'm positive there are values in the deletebox[] value when you check it.

Wildhoney · 01-15-2008, 02:36 AM

That code actually works perfectly for me. This is what I have:

php Code:

<?php

if(isset($_POST['submit']))
{
    foreach($_POST['deletebox'] as $deletebox1)
    {
        $deletebox1 = (int) $deletebox1;
        echo "DELETE FROM private_messages WHERE id=$deletebox1" . '<br />';
    }
}

?>

And the HTML...

html4strict Code:

<form action="" method="post">

    <input type="checkbox" class="delete-checkbox" value="1" name="deletebox[]" />
    <input type="submit" name="submit" value="delete messages" />

</form>

I can really only surmise that either the $_POST array is being overwritten, or that for whatever reason there are no items being posted, but I'm not sure why that would be. Is your code getting to that segment where you execute the SQL statements?

riscphree · 01-15-2008, 02:56 AM

Man, I've been going over this for hours .. still not working and I see absolutely nothing wrong. I'm pretty much to the point where I'll pay someone to fix this, it's getting out of hand.

Wildhoney · 01-15-2008, 03:01 AM

I feel for you! I've been in similar situations where things defy all reason. Sadly though I'm off to bed any time soon

Maybe you can post us a bit more of the code - considering it isn't too long. Or maybe a pastebin otherwise.

Alan @ CIT · 01-15-2008, 07:36 AM

When the html is loaded, can you view source and see if $row['id'] is filling in the blank correctly in your checkbox form field?

Alan

riscphree · 01-15-2008, 01:16 PM

Quote:

When the html is loaded, can you view source and see if $row['id'] is filling in the blank correctly in your checkbox form field?

Yeah, it is being loaded.

xenon · 01-15-2008, 05:11 PM

Please, oh please, turn error reporting on (error_reporting(E_ALL)) when in debug mode. The problem is in the printing business:

PHP Code:


			
print"<input type="checkbox" class="delete-checkbox" value="{$row['id']}" name="deletebox[]" />";

Why aren't the double quotes inside the print statement escaped or smth? Like so...

PHP Code:


			
print '<input type="checkbox" class="delete-checkbox" value="' . $row['id'] . '" name="deletebox[]" />';

riscphree · 01-15-2008, 05:30 PM

Quote:

The problem is in the printing business:

Because my real code is:

Code:

print "<div class=\"delete\"><input type=\"checkbox\" class=\"delete-checkbox\" value=\"{$row['id']}\" name=\"deletebox\" /></div>";

I just took out the escapes so it was easier to read.

Nor · 01-15-2008, 06:54 PM

They keep telling you:

Code:

print "<div class=\"delete\"><input type=\"checkbox\" class=\"delete-checkbox\" value=\"{$row['id']}\" name=\"deletebox\" /></div>";

should be:

Code:

print "<div class=\"delete\"><input type=\"checkbox\" class=\"delete-checkbox\" value=\"{$row['id']}\" name=\"deletebox[]\" /></div>";

You might not notice but the name of the delete box has the [] after the work deletebox now ;)...

riscphree · 01-16-2008, 06:40 PM

I've got it at least to recognize the number of items being submitted, but it doesn't pass the values still. when I checked three boxes it ouput:

Code:

Array
(
    [deletebox] => Array
        (
            [0] => 
            [1] => 
            [2] => 
        )

    [submit] => delete messages
)

EyeDentify · 01-17-2008, 07:33 AM

Are you submiting via a Ajax JavaScript POST call or GET .

Cause i have had trouble with values don´t being transfered in some cases because of the form element being laid out with the help of Table elements.

Can´t remebmer right now wich Framework i used but it was:
jQuery, Prototype, MooTools, or someone like that.

Just a thought.

/EyeDentify

riscphree · 01-17-2008, 12:42 PM

Nope, just doing a regular form submission.

Salathe · 01-17-2008, 01:27 PM

Try using var_dump rather than print_r because the former will be able to show us the types of the values (integer, string, etc) as well as their actual value (e.g, FALSE does not display anything with print_r).

Nor · 01-17-2008, 01:54 PM

Try echoing the value out to the page and see if there is an id being shown to the browser.

riscphree · 01-17-2008, 05:17 PM

using var_dump

Code:

var_dump($_POST)

and checked three boxes (IDs of 37, 27, and 21)

Gives me:

Code:

array(2) { ["deletebox"]=>  string(0) "" ["submit"]=>  string(15) "delete messages" }

riscphree · 01-17-2008, 05:18 PM

Quote:

Try echoing the value out to the page and see if there is an id being shown to the browser.

In the links, the IDs are properly shown.