codeigniter active record batch update where where clause equals array index

Question

I have an array of post data ($data) in codeigniter that looks like the attached image.

And a database that looks like:

id: 3 val: 37.10119357072203

-

id: 4 val: -122.06634521484374

I want to insert the array value into the 'val' field based on the array key matching the database 'id' field. How do I do this using codeigniter's update_batch. My model is currently:

public function edit_config($data){
        $this->db->update_batch('extra_config', $data,'val');
    }

but I get the error:

One or more rows submitted for batch updating is missing the specified index.

can you echo the query using $this->db->last_query() and post it here? — newCodex
– newCodex, Commented Nov 25, 2015 at 15:37
@Svetlio - Array ( [val] => Array ( [3] => 37.10119357072203 [4] => -122.06634521484374 [5] => 37.51571709945411 ... is print_r($data) — mheavers
– mheavers, Commented Nov 25, 2015 at 15:51
@newCodex - I'm not sure where to do this echo - I tried placing it after the call to the edit_config function in my controller and I just get a blank page — mheavers
– mheavers, Commented Nov 25, 2015 at 15:54
@mheavers go to Codeigniter documentation and see how your array must be structured for update_batch as it is not the right way at the moment ;) — Svetoslav
– Svetoslav, Commented Nov 25, 2015 at 15:58

mheavers · Accepted Answer · 2015-11-25 16:29:32Z

1

You have to prepare your data its not normal not to touch it from the incoming request..

public function edit_config($data){
     $updateData = array();
     foreach($data['val'] as $key=>$value) {
         $updateData[] = array('id'=>$key, 'val'=>$value);
     }

     $this->db->update_batch('extra_config', $updateData,'id');
}

edited Nov 25, 2015 at 16:29

mheavers

30.2k63 gold badges201 silver badges328 bronze badges

answered Nov 25, 2015 at 16:04

Svetoslav

4,6862 gold badges30 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

codeigniter active record batch update where where clause equals array index

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