PHP array value passes to next row

Question

I have an array building multiple instances of the following fields    lt div class  checkbox vm  gt       lt input type  hidden  name  fk row    value   lt  php echo  i    gt   gt       lt input type  hidden  name  fk id    value   lt  php echo  vehicle feature  i - gt fk id    gt   gt       lt input type  checkbox  class  checkbox veh  id  checkbox addveh lt  php echo  i    gt    lt  php if   vehicle feature  i - gt check  echo  checked     gt  name  feature    value   lt  php echo  vehicle feature  i - gt id    gt   gt       lt label for  checkbox addveh lt  php echo  i    gt   gt  lt  php echo  vehicle feature  i - gt name    gt  lt  label gt       lt input type  text  class    id  input addveh lt  php echo  i    gt   name  featureInput    value   lt  php echo  vehicle feature  i - gt fk value    gt   gt   lt  div gt    The following actions work as intended     Checking a checkbox and enter text in the input field creates a new record Editing the text in an input field  that still has a checkbox checked  saves the changes Unchecking a checkbox removes the record row from the database   This is the problem    If you UNCHECK a checkbox and save  whatever text value was in the input field next to it will then be carried over into the next row in the array   Example  the 3rd checkbox had a value of 3  and the 4th checkbox had a value of 4  If you uncheck the 3rd checkbox then save  the 4th checkbox s value is now 3  And every row record after that is updated to the previous row s value    Here is the script   function saveVehicle  option   task       global  database       fk row     POST  fk row         fk id     POST  fk id         feature     POST  feature         featureInput     POST  featureInput        for   i   0   i  lt  count  fk row    i              if  isset  feature  i                 if   fk id  i                     database- gt setQuery  UPDATE    vehiclemanager feature vehicles SET fk vehicleid    vehicle- gt id  fk featureid    feature  i   fk value     featureInput  i   WHERE id    fk id  i                      database- gt query                  else                    database- gt setQuery  INSERT INTO    vehiclemanager feature vehicles  fk vehicleid  fk featureid  fk value  VALUES   vehicle- gt id   feature  i     featureInput  i                        database- gt query                            else               if   fk id  i                     database- gt setQuery  DELETE FROM    vehiclemanager feature vehicles WHERE id    fk id  i                      database- gt query

User · Accepted Answer

Change the checkboxes so that the name includes the index inside the brackets:

<input type="checkbox" class="checkbox_veh" id="checkbox_addveh<?php echo $i; ?>" <?php if ($vehicle_feature[$i]->check) echo "checked"; ?> name="feature[<?php echo $i; ?>]" value="<?php echo $vehicle_feature[$i]->id; ?>">

The checkboxes that aren't checked are never submitted. The boxes that are checked get submitted, but they get numbered consecutively from 0, and won't have the same indexes as the other corresponding input fields.

[arrays] PHP array value passes to next row

Examples related to arrays

Examples related to skip