updating multiple values to mysql database using codeigniter

Question

my post data from form is coming as

Array
(
    [radiogroup_1] => 1
    [radiogroup_2] => 4
    [radiogroup_4] => 11
    [submit] => submit
)

and my model is

 function add_votes(){

    foreach($POST[] as $k=> $v){
    $id = $v;
    }

    $this->db->where('answerid','radiogroup_'. $id );

    $this->db->set('votes', 'votes+1',FALSE);
    $this->db->update('vote_table');


 }

apparently, it's not working.

What's your question here? What are you trying to accomplish. It's confusing, you know! Also you apparently have a logical error in your code. $id is always equals to 'submit' after the foreach — Yasser Souri
– Yasser Souri, Commented Jul 10, 2011 at 18:28

Alfonso Rubalcava · Accepted Answer · 2011-07-10 18:18:48Z

1

Maybe

function add_votes(){
    foreach($_POST[] as $k=> $v){
        $this->db->where('answerid','radiogroup_'. $v );
        $this->db->set('votes', 'votes+1',FALSE);
        $this->db->update('vote_table');
    }
}

or

function add_votes(){
    foreach($_POST[] as $k=> $v){
        $this->db->where('answerid', $v );
        $this->db->set('votes', 'votes+1',FALSE);
        $this->db->update('vote_table');
    }
}

edited Jul 10, 2011 at 18:18

answered Jul 10, 2011 at 17:55

Alfonso Rubalcava

2,24717 silver badges27 bronze badges

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

Comments

Gopalakrishnan · Accepted Answer · 2016-02-20 12:42:49Z

0

Dont need to foreach to update. Just use update the table one time.

 function add_votes(){
 $radiogroup_1=$this->input->post('radiogroup_1');
 $radiogroup_2=$this->input->post('radiogroup_2');
 $radiogroup_4=$this->input->post('radiogroup_4');
$data=array('radiogroup_1'=>$radiogroup_1,'radiogroup_2'=>$radiogroup_2,'radiogroup_4'=>$radiogroup_4);
$this->db->where('answerid','radiogroup_'. $id );
$result=$this->db->update('vote_table',$data);
}

answered Feb 20, 2016 at 12:42

Gopalakrishnan

9578 silver badges21 bronze badges

Collectives™ on Stack Overflow

updating multiple values to mysql database using codeigniter

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related