Handling Checkboxes & Dropdowns in the same row

tdors

Hi - hopefully someone out there can help.

I'm creating a log page where the page will list a list of everyone that is in a group or "club". What the list will draw on the site is a table with a checkbox, "handle", last name, first name, dropdown of choices, and textbox for notes. That part I have down (kind of). The thing that boggles my mind is that after I submit the page, I want the page to take each line with a check box and submit the following to a mySQL database: "handle", result of the dropdown and anything in the textbox. But only those that are checked. (It's a site to track people that show up to a club event. We have people that are members, the site would list the members and I would click the checkbox if they showed up so I can track it later. The dropdown containes the options if the user has "traffic" which would be the following listings: "None" "Written" "Formal" and "Informal" ) Any help would be greatly appreciated. I'm also not sure how I should use naming conventions of the checkboxes, dropdowns, or text fields. Please see http://24.123.93.234/hamradio/enter_net_info_form.php?enicounty=WIWINNEB for the page example. Thanks in advance!

mtombs

The thing about check and option boxes is that their value is 'ON' or 'OFF' or something useful like that. The way to tell them apart from each other is to give them distinct names, rather than values.
What I normally do in this situation is append a unique code to the end of the name of every form item in the row, e.g. chk-1, name-1, notes-1. Then go through all the form items in $HTTP_POST_VARS or $_POST or whichever you use. If the form item name starts with 'chk', check its value. If it is ON or Y (can't remember right now what the value of a selected check box is), get all the other values with the same ID and do your SQL stuff. For example:

foreach($HTTP_POST_VARS as $name=>$value){
    if (substr($name,1,3)=="chk"){
      if ($value=="Y"){
        $id=substr($name,5);
        $firstname=$HTTP_POST_VARS["firstname-" . $id];
        $lastname = $HTTP_POST_VARS["lastname-" . $id];
      // do the sql stuff with $firstname and $lastname
     }
  }
}

hope this helps!

mark

tdors

Mark - Thanks for the info, I didn't know I could do a for each on the variables of a post, that's going to be super helpful that will provide me some ideas to get it going. Thanks!!!!! 😃 😃 😃