dealing with checkboxes

JackOfBlades

can someone tell me how you deal with dynamic checkboxes when they are submitted? the code is something like this:

<?php

while(condition)
echo(<input type = box name = box>$data); //assuming they are inside a form tag... my problem is that i want to delete let's say the data that the user has checked... but how do i do that? since they were populated through php using loops then how do i check which box was checked so the could be deleted...lets say the check 1 and 3 box...when it is submitted how do i know that 1 n 3 are the only ones checked and not 2 since they share the same name....and if i try to give them different names then that wouldnt be advisable ryt? because i would have to check each one of them.. it would not be efficient?

barand

Name them like "box[]" so they are posted as an array

Only those checked are sent.

Make the value of each box the id of the rec you want to delete

Sample

<?php
if (isset ($_GET['submit'])) {

$idList = join (',', $_GET['box']);

$sql = "DELETE FROM mytablename WHERE id in ($idList)";

echo $sql;
}


?>
<FORM>
<INPUT TYPE='CHECKBOX'  name='box[]' value='1'>rec 1
<INPUT TYPE='CHECKBOX'  name='box[]' value='2'>rec 2
<INPUT TYPE='CHECKBOX'  name='box[]' value='3'>rec 3

<INPUT TYPE='SUBMIT'  name='submit' value='Submit'>
</FORM>

syd

very well, barand

me too having the same problem a little more complex i suppose.

my problem is i have the form in a loop and it runs variable number of time in that way i am unable to figure a solution for the naming of the checkboxes.

what should i do?

thanx in advance.

Houdini

Use an associative array instead of an indexed one like

<INPUT TYPE='CHECKBOX'  name='box[rec1]' value='rec1'>rec 1
<INPUT TYPE='CHECKBOX'  name='box[rec2]' value='rec2'>rec 2
<INPUT TYPE='CHECKBOX'  name='box[rec3]' value='rec3'>rec 3

Now it is easier to know exactly all boxes that are checked simple by the $_POST[box][recX] value which if set the key and the value are one and the same (well the value is the same as the key that retrieves it).

Chief_Geek

I do not know exactly what you are doing, so this suggestion may not apply. Soemtimes it is better to handle things on the browser side. You could do what you described by using the DOM and javascript AJAX-style. Let javascript rewrite the form, without the checkbox and label, when the visitor clicks on the checkbox, and before it is submitted to the server. This way, you reduce your server-side load, and don't have to rewrite the entire page, and the form only submits the elements that you want ...

HTH

Roger

syd

thanx all

as i said the the form is in a loop and it runs variable number of times so there is no way i could use a associative array, by the way i figured a way:

i used the name of the array in the name and value with a counter of the element like:

the counter incremeants the number of times the elements have to be dispalyed. as i also have a texbox i am using two different arrays where the data of the textbox is stored in the array. but still i am not able to get the whole data in the array i am getting only the first word of the complete value.

i will post the code if needed, thanx by the way for reading

btw

thanx Roger for the replay my javascript is worst than my php :mad:

any help is highly appreciated

thanx in advance