how to store multiple checkbox values in database using codeigniter

Question

<tr><th>Option Subject</th>
 <th>
<input type="checkbox" name="skills" id="skills[]" value="C++"> C++<br>
<input type="checkbox" name="skills" id="skills[]" value="JAVA"> JAVA<br>
<input type="checkbox" name="skills" id="skills[]" value="HTML"> HTML<br>
<input type="checkbox" name="skills" id="skills[]" value="PHP"> PHP<br>
<input type="checkbox" name="skills" id="skills[]" value="ASP.NET">ASP.NET<br>
<font color="#FF0000"><?php echo form_error('skills');?></font>
 </th>
</tr>

controler public function insert() { $skills=$this->form_validation->set_rules('skills', 'Option Subject','required');

$data = array(
    'skills' => implode(",", $skills);       
);
}



if(isset($options['skills'])) 
 $this->db->set('skills',($options['skills']));  
 $this->db->insert("regi_user");  
 return $this->db->insert_id();

Roshni hegde · Accepted Answer · 2018-04-09 10:25:41Z

0

You have to convert imploded value to string.

Try the following code

 $data = array(
        'skills' => json_encode(implode(",", $skills));       
    );

    $this->db->insert("regi_user");  
    return $this->db->insert_id();

answered Apr 9, 2018 at 10:25

Roshni hegde

4253 silver badges14 bronze badges

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

1 Comment

Kiran Patil Over a year ago

Not Work @Roshni

Ravi Sachaniya · Accepted Answer · 2018-04-09 11:42:43Z

0

To add multiple value in table try following code.

$language = $this->input->post('skills');

if (is_array($language) && !empty($language))
{
    foreach($language as $lan)
    {
        $insert['language'] = $lan;
        $this->db->insert("table name");
    }
}

edited Apr 9, 2018 at 11:42

Ravi Sachaniya

1,65819 silver badges21 bronze badges

answered Apr 9, 2018 at 10:28

Ravi Thanki

2892 silver badges14 bronze badges

1 Comment

Kiran Patil Over a year ago

Contoller public function insert() { $skills=$this->form_validation->set_rules('skills', 'Option Subject','required'); How to insert Multiple value in database

Collectives™ on Stack Overflow

how to store multiple checkbox values in database using codeigniter

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related