Insert multiple checkbox with different value into corresponding database column

Question

I am trying to insert multiple checkbox with different value into corresponding database column.

For example:

View:

I have 4 checkbox:

<input type="checkbox" name="approverAccess[]" value="LA" >
<input type="checkbox" name="approverAccess[]" value="OA" >
<input type="checkbox" name="approverAccess[]" value="PC" >
<input type="checkbox" name="approverAccess[]" value="TS" >

And the table is something like this:

So the scenario is, If the first checkbox is checked, C1 column will have a value of '1' and the rest is '0', if second checkbox is checked C2 column will have a value of '1' and the rest is '0' and so on. Whatever checkbox is check it should be show or add in the corresponding table column.

Controller:

foreach($approverAccess as $selected) {     
    // ***What I'm going to do here****  
}

$data = array(
'ID' => '',
'USERID' => $adminID,
'C1' => $selected,
'C2' => $selected,
'C3' => $selected,
'C4' => $selected

);

$this->dbquery->modInsertval('tblapprover',$data);

How can I proceed with this?

Why not just name them approverAccessC1, approverAccessC2, approverAccessC3, and approverAccessC4? In this case, I'm not sure using an array really provides any benefit. — Patrick Q
– Patrick Q, Commented May 16, 2019 at 17:39
The table is something like this: what is a table in this context — Strawberry
– Strawberry, Commented May 16, 2019 at 21:47

Astrea · Accepted Answer · 2019-05-16 17:57:24Z

2

$data = array(
    'ID' => '',
    'USERID' => $adminID,
    'C1' => in_array('LA', $approverAccess) ? 1 : 0, 
    'C2' => in_array('OA', $approverAccess) ? 1 : 0,
    'C3' => in_array('PC', $approverAccess) ? 1 : 0,
    'C4' => in_array('TS', $approverAccess) ? 1 : 0
);

$this->dbquery->modInsertval('tblapprover',$data);

answered May 16, 2019 at 17:57

Astrea

1469 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert multiple checkbox with different value into corresponding database column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related