Multiple Checkboxes

Anon

Hello-
I'm working on script that will, from a database, grab a list of name and display 5 check marks, one for each 'class' Class as in, attendance, whether they were there or not. I'm having troubles trying to pass the variables to be updated in the database. How can I send multiple checkmark changes for multiple people all at once? Sort of the setup:

Name Session1 Session2 ... Session5
Joe J [X] [X] [ ]
Bill B [ ] [X] [X]

[SUBMIT]

Etc.

Any ideas on how to go about doing this?

Anon

give different name to all the check box giving them on and off state . that will pass all the values of checkboxes , which you can sort and accordingly update your database.

Anon

I thought of doing this, but how do I name them so that it understands which box goes with whom?
I thought of calling the boxes $idbox1 - so it would for example: 0302box1 - But I don't know how I can split them back apart. I was hoping I could do some type of array to hold everyone's info. Anybody have an idea about that?

Basically, the biggest problem with giving each box a seperate name is that I have a dynamic list of up to 25 or so people, and each needs 5 boxes. 125 different variables is a lot to work with.

Thanks again.

-Matt

Anon

This is usefull for displaying x records from a database at a time with a checkbox option next to each record used to mark the records for deletion, updates, etc...

On the page with the checkboxes assign each checkbox name with an incremented value(RECORD1, RECORD2,...) and assign the values from an array:

for($i=0;$i<=$rec_count-1;$i++)
{
$recordname="RECORD"."$i";
print("<br><input type=\"checkbox\" name=\"$recordname\" value=\"$id[$i]\">\n");
}

You must also pass a variable containing the number of checkbox fields you displayed.

Post the form data to a receiving script that extracts the values of the variables you created for each checkbox and puts them into an array as follows...

for($j=1;$j<=$numrecs;$j++)
{
$checkbox_id=${"RECORD".$j};
if($checkbox_id)
{
$new_array[]=$checkbox_id;
}
}

Now you have an array of the values of the checkboxes that were selected.

hayguy

I use the code below to extract the data from the array, equipment[].

while(list($key, $value) = each($equipment))

{
echo "$key = $value <BR>\n";
// put your INSERT code here

}

I can drop $key and just collect $value like so... ( , $value)

"Storing checkbox data in your database" is an article found on this site. It shows an effective method of pulling data from a database to create checkboxes.

Anon

you could
name every checkbox as
'boxes[]' or 'whatever[]'

then fill the values for the checkboxes
with '$id|$sessionno'

see that i'm separating the two values with
a pipe '|' (use any character or characters that is not going to be part of the actual data)

then when submitted, you will get one array
"$boxes"

now you can loop thru this array
grap the value of each element
split the value on pipe '|'

there you have the id and the session no

hope this helps,
stef

Anon

Great! I hope that works.
Just a note, here's the form I'm working with: http://www.mnsta.org/BaP/facil/do_attendance.php?attendancesite=Albany&submit=Take+attendance

Where those dates, they are the dates of the 'session'

Thanks.

-Matt