Codeigniter updating database with checkbox

Question

i have a table named group where i have columns like admin,editor,user,guest they are all boolean.
i want to create a group using checkbox. so in my view i got checkbox like admin,editor,user,guest and a create button. When i click the create button i want the checked options to be true in database and unchecked remains false. how can i do that?

I am new in codeigniter.

<html>
<head>
    <title>Create A group</title>
</head>
<body>
    <?php echo form_open('group/create_group'); ?>
    <div>
        <?php echo form_label("Gruop Name"); ?> 
        <?php 
        $data=array(
        'name'=>'group_name',
        'placeholder'=>'enter group name'
        );
     ?>
         <?php echo form_input($data); ?>
    </div>
    <div>
        <?php $data=array(
        'name'=>'role[]',
        'value'=>'1',
        'type'=>'checkbox'
        );
        ?>
        <?php echo form_label('Admin'); ?>
        <?php echo form_checkbox($data); ?>
    </div>
    <div>
        <?php $data=array(
        'name'=>'role[]',
        'value'=>'2'
        );
        ?>
        <?php echo form_label('User'); ?>
        <?php echo form_checkbox($data); ?>
    </div>
    <div>
        <?php $data=array(
        'name'=>'role[]',
        'value'=>'3'
        );
        ?>
        <?php echo form_label('Editor'); ?>
        <?php echo form_checkbox($data); ?>
    </div>
    <div>
        <?php $data=array(
        'name'=>'role[]',
        'value'=>'4'
        );
        ?>
        <?php echo form_label('Others'); ?>
        <?php echo form_checkbox($data); ?>
    </div>
    <div>
        <?php $data=array(
        'type'=>'submit',
        'value'=>'Create'
        ); ?>
        <?php echo form_submit($data); ?>
    </div>
    <?php echo form_close(); ?>
</body>

refer the link for how to use model in codeigniter ellislab.com/codeigniter/user-guide/general/models.html — msvairam
– msvairam, Commented Feb 4, 2016 at 11:52

jpganz18 · Accepted Answer · 2016-02-04 17:34:00Z

2

First

Set "false" as default value at all those fields.

Second

If you can set only one role per user then you should use radiobox instead checkbox

Third

Capture the parameters sent by the post.

Assuming that you created a route for group/create_group that goes to the data_submitted method

public function data_submitted() {
    $data = array(
    'role' => $this->input->post('role'),
    //more info that you get from the post..
    );
    Now load your model and save it...

}

answered Feb 4, 2016 at 17:34

jpganz18

5,90821 gold badges74 silver badges131 bronze badges

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

1 Comment

Fayed Over a year ago

thnx for that...i get it :)

E. Spiroux · Accepted Answer · 2016-02-04 17:32:16Z

0

Put off [] and in your php file logic your can do : $this->input->post("role"); and get value. If you want to do multi-choice's checkbox your must change to an unique name and set value to true for each of them.

Have nice day !

answered Feb 4, 2016 at 17:32

E. Spiroux

4286 silver badges15 bronze badges

Collectives™ on Stack Overflow

Codeigniter updating database with checkbox

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related