Update page to modify database

Hi. Happy New Year..
You helped me a while back with this page to modify the database. That worked perfectly. I had to add a checkbox array to the page. I was able to figure it out for the initial add page and that works great. What I cant figure out is how to make it work with the update page. I see what you did on the single checkboxes to have them show if they were checked and update correctly but I have not the faintest idea how to make it work for an ARRAY. I would appreciate any guidance you could provide. The page is attached.

You would probably want to:

1) create a recordset to return the previously selected infractions
2) loop through the recordset to get the infractions into an array
3) use the in_array() function to check the previously selected boxes

Then on update you will want to delete all of the previously selected incident records and use the same logic from the insert page to re-insert the ones checked on the update form.

Ok. I got the recordset to read the 'infractions' field. I think I am confusing myself. The 'infractions' field in one recordset reads as follows:

B4NR,4571,AAUP,ADDY,BATT,290R.

So if I read that field how do I get it to pull each one (comma seperated) into an the array to make this happen. Do I use 'explode()?
I really want to figure this out myself but....
Thanks.
Gary

Yes.

$InfractionsArray = explode(",",$RecordsetName->getColumnVal("InfractionsColumn"));

Ok.. I get that part now. I entered it as:

$InfractionsArray = explode(",",$Recordset3->getColumnVal("infractions"));

var_dump($InfractionsArray); puts this on the top of the page.
array(6) { [0]=> string(4) "B4NR" [1]=> string(4) "4571" [2]=> string(4) "AAUP" [3]=> string(4) "ADDY" [4]=> string(4) "BATT" [5]=> string(4) "290R" }
That part now makes sense.

Being I am using the individual check boxes for each infraction, does each checkbox <input statement need to loop through the InfractionsArray to see if it is selected.

Reference the out of state checkbox (which you helped me with a few months ago). I know this (below) is not an array but how do I make it check to see if it is being used or not.

<input <?php if (!(strcmp(($Recordset1->getColumnVal("outofstate")),1))) {echo "checked=\"checked\"";} ?> type="checkbox" name="outofstate" id="outofstate" value="1" class="formCheckboxField_Standard" tabindex="13" title="Please enter a value" />

Thanks again for all the help.
Gary.

Thanks Ray,
That got it working.
I used <input <?php if (in_array("B4NR",$InfractionsArray)) {echo "checked=\"checked\"";} ?> type="checkbox" name="B4NR" id="B4NR" value="1" class="formCheckboxField_Standard" title="Please select an infraction" />

You had it "1",$InfractionsArray)) I assumed that would work if I was just using numbered items. I put in the checkbox name instead and it works perfectly.. Now to get it to update.. Thanks again.

I've got it working in the way it checks all the boxes that are selected for the record. Set up the update record and had it blank the entry. Problem is when updated it changes the entry in the field in the db to on,on. At one time it was 1,1. Not sure what changed. Plus obviously not adding the new entries. Attaching the updated page.

Also on this same page, near the bottom, it lists the <script src="../webassist/forms/wa_servervalidation.js" type="text/javascript"></script>
10 plus times. Question is, can I delete all that are duplicates?
Thanks.
Gary.

You can delete duplicate script references.

The issue with the checkboxes is that they are missing the value attribute. Each checkbox should have a value set that matches what you want inserted into the database. (Also the "for" attribute of the label should match the id of the checkbox although that isn't related to your problem)

So the first one should be:

<label for="B4NR">

                                 <input value="B4NR" id="B4NR" <?php if (in_array("B4NR",$InfractionsArray)) {echo "checked=\"checked\"";} ?> type="checkbox" name="infractions[]" /></label>

Just wanted to thank you for your help. This is working great.