Insert multipal checked value in multiple row in mysql with codeigniter

Question

I have face a problem. I want to insert multi checked value in multi row in mysql data table.... But When i insert it store all in one row... How can i fix it... My Model is:

    public function apply_for_work_check()
    {
    $variable = $this->input->post('Infrashtructure');
     $data = array(
    'id' =>null,
    'works_id' => 1,
    'infrashtructure_name' => json_encode(implode(",", $variable)),
    );
    $result=$this->db->insert('infrashtructure_txn_info',$data);
    if($result)
    {
    return TRUE;
    }
    else
    {
    return FALSE;
    }
    }

Do insert for each value in $variable not once with implode() — JustOnUnderMillions
– JustOnUnderMillions, Commented Mar 7, 2017 at 10:59
Please show the content of $variable using print_r($variable) — Indrasis Datta
– Indrasis Datta, Commented Mar 7, 2017 at 11:09

JustOnUnderMillions · Accepted Answer · 2017-03-07 11:04:38Z

1

public function apply_for_work_check()
{
 $result=array();
 $variable = $this->input->post('Infrashtructure');
 foreach($variable as $var){
     $data = array('id' =>null,'works_id' => 1,
                   'infrashtructure_name' => json_encode($var));
     $result[]=$this->db->insert('infrashtructure_txn_info',$data);
 }

 if(count($result)==array_sum($result)) {#checks if all was TRUE
   return TRUE;
 } else {
   return FALSE;
 }
}

answered Mar 7, 2017 at 11:04

JustOnUnderMillions

3,80511 silver badges14 bronze badges

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

Comments

Rahul · Accepted Answer · 2017-03-07 11:17:12Z

1

Change your method as below:

public function apply_for_work_check()
{
    $variable = $this->input->post('Infrashtructure');
    foreach ($variable as $key => $value) {
        $data = array(
            'id'                   => null,
            'works_id'             => 1,
            'infrashtructure_name' => $value,
        );
        $result = $this->db->insert('infrashtructure_txn_info', $data);
    }
    if ($result) {
        return true;
    } else {
        return false;
    }
}

edited Mar 7, 2017 at 11:17

Rahul

18.6k7 gold badges43 silver badges64 bronze badges

answered Mar 7, 2017 at 11:03

B. Desai

16.4k5 gold badges28 silver badges48 bronze badges

Comments

Rabin Lama Dong · Accepted Answer · 2017-03-07 12:05:59Z

0

$data = explode(",", $variable);

After this.

'infrashtructure_name' => json_encode(implode(",", $data))

edited Mar 7, 2017 at 12:05

Rabin Lama Dong

2,4761 gold badge29 silver badges34 bronze badges

answered Mar 7, 2017 at 11:07

Pradeep

3910 bronze badges

Collectives™ on Stack Overflow

Insert multipal checked value in multiple row in mysql with codeigniter

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related