[Resolved] checkboxes

[lives4him06]

When a checkbox is checked and the 'submit' button is clicked on one page, how do you know on the second page whether or not that check box is selected?

[jannoy]

if isset($_POST['checkbox']) echo 'check';

[lives4him06]

$_POST['checkbox']

the 'checkbox' being the name of the check box?

[jannoy]

YES checkbox is the name of your checkbox

eg. <input type='checkbox' name='checkbox' value='1'>

[lives4him06]

Well in this case i dont know the name of the check box or checkboxes on the second page, how do you do that?

[devinemke]

are you writing a form processor for a form that you do not control?

[lives4him06]

The first page is as follows. Text is read in from multiple rows of a database. When each field is read in, a checkbox is created. When the check box is checked and the 'Delete Checked Entries' is clicked the information from the form is sent to the next page.

 
<?php
$user="";
$host="";
$password="";
$database="";
$connection=mysql_connect($host,$user,$password) or die ("could not connect to mysql.");
$db = mysql_select_db($database,$connection) or die ("could not connect to the database.");

$query = "select * from helloWorld";
$result = mysql_query($query) or die (mysql_error());

echo "<form action='deleteTest.php' method='post'>";

while ( $row = mysql_fetch_array($result,MYSQL_ASSOC))
{
        extract($row);
        echo "<input type='checkbox' name='$num'><b>$entry</b> <br>"; 
}
echo "<input type='submit' value='Delete Checked Entries'>";
echo "</form>";

?>

I would like the second page to be as follows. Which ever check box is checked, the corresponding entry in the database is deleted.

 
$query = "delete from helloWorld where num=$num";
$result = mysql_query($query) or die (mysql_error());

the entry field in the table is, of course, a text field. the num field in the table is an auto-incrimented field.

[devinemke]

use the $num not as the name of the checkbox but as the value:

while ($row = mysql_fetch_assoc($result))
{
	extract($row);
	echo '<input type="checkbox" name="delete[]" value="' . $num . '"><b>' . $entry . '</b><br>';
}

then in deleteTest.php:

$sql = 'DELETE FROM helloWorld WHERE num IN(' . implode(',', $_POST['delete']) . ')';

[lives4him06]

<input type="checkbox" name="delete[]"

why set the name to delete[]??

and what exactly does this do?

  $sql = 'DELETE FROM helloWorld WHERE num IN(' . implode(',', $_POST['delete']) . ')');

[devinemke]

did you run the code? it does precisely what you said you wanted it to do. delete[] returns all of the checkbox data as an array ($_POST['delete']) and then this array is [man]implode[/man]d into a comman separated string which is used to construct a DELETE query.

[lives4him06]

i implemented the code and got the following error:

Warning: implode(): Bad arguments. in /usr/home/classic/public_html/jeff/deleteTest.php on line 11

well i guess first it complained about the ')' as highlighted within the dashes below

   

$sql = 'DELETE FROM helloWorld WHERE num IN(' . implode(',', $_POST['delete']-----)---- . ')');

then i wasent sure what to do with it so i both removed it and added another '(' before $_POST['delete'] like so
code=php[/code] and both times got the error listed above

[devinemke]

did you make the changes to your form that i suggested?

[lives4him06]

i directly lifted all blocks of code. The problem lies in an additional ')' in the second block of code.

[Roger_Ramjet]

devonmke has a typo. that does not give you the right to get so nasty about it. try some basic debugging, the color coding is a give away.

$sql = 'DELETE FROM helloWorld WHERE num IN(' . implode(',', $_POST['delete']) . ')');

// OR

$sql = 'DELETE FROM helloWorld WHERE num IN(' . implode(',', $_POST['delete']) . ')';

NOW TRY GUESSING WHICH ONE HAS THE TYPO

[lives4him06]

neither work. however the second came back with no error. Is this supposed to be placed in a loop?? ahhh im so confused.. thanks for helpin

[lives4him06]

i tried implementing the code on both the first and second pages.

Perhaps this will make my objectives more clear:

http://classicbleed.net/jeff/test.php

the entries above the first submit button are read in from a database holding the fields entry (for the text) and num (an auto_incriment field). when a box is checked and the delete button clicked, i wish for the second page to delete the checked entry from the database.

[lives4him06]

ahh ha! i got it

page one:

 
$query = "select * from helloWorld order by num";
$result = mysql_query($query) or die (mysql_error());

echo "<form action='deleteTest.php' method='post'>";

while ($row = mysql_fetch_assoc($result)) 
{ 
    extract($row); 
    echo "<input type=\"checkbox\" name=\"$entry\" value=\"$num\"><b>$entry</b><br>\n"; 
}

echo "<input type='submit' value='Delete Checked Entries'>";
echo "</form>";

page two:

 
foreach ($HTTP_POST_VARS as $name => $num) 
{
    $query = "delete from helloWorld where num=$num";
    $result = mysql_query($query) or die (mysql_error());
}