[eluser]Unknown[/eluser]
Hello CI community ---
I'm pretty new to CI and I'm trying to figure out the best way to persist multiple checkbox values to the DB. I searched the forums for a bit but did find anything I was looking for.
Here is what I have so far..In the DB I have a column set up for each checkbox with the goal of persisting either a 1 or 0 depending if the checkboxes is checked.
Code:
<input type="checkbox" name="day[]" value="1" id="monday" /><label for="monday"> Monday</label><br />
<input type="checkbox" name="day[]" value="1" id="tuesday" /><label for="tuesday"> Tuesday</label><br />
<input type="checkbox" name="day[]" value="1" id="wednesday" /><label for="wednesday"> Wednesday</label><br />
<input type="checkbox" name="day[]" value="1" id="thursday" /><label for="thursday"> Thursday</label><br />
<input type="checkbox" name="day[]" value="1" id="friday" /><label for="friday"> Friday</label><br />
Most of the checkboxes are grouped so I have named them the same. My issue, as I understand it, is sometimes not all the checkboxes are checked every time the form is submitted so they won't show up in the POST. Which then leads me to my next problem of mapping each value in the POST to my DB table. What is the most effective way to handle this issue?
Thanks,
Ryan
