Update Database Field Error CodeIgniter

Question

I am getting the following error message in CodeIgniter 2.1:

A PHP Error was encountered

Severity: Notice

Message: Array to string conversion

Filename: database/DB_active_rec.php

Line Number: 1407

I'm trying to update fields in my database. I have this code and every tutorial are just the same for batch upload. It works anyway but the thing is it display such an error.

this what i have in my model:

function update2($data){
   $this->db->update_batch('users',$data, "id");
}

This what i have in my controller:

public function updateValues(){
    $this->load->model('get_db');
    $newRow = array(
        array(
            'id' => '3',
            'firstname' => 'Rapphie'
        ),
        array(
            'id' => '2',
            'firstname' => 'Charmie'
        )
    );
    $this->get_db->update2($newRow);
    echo "it has been updated";
}

Which version of CodeIgniter are you running? You can see that with <?php echo CI_VERSION; ?> — P M
Dumb question, but if you do a print_r or var_export of ($data) just above the update_batch call in update2(), do you get the same array that you passed in? — King Skippus
the instruction you have written for update is wrong you should use a where condition see the documents codeigniter.com/user_guide/database/active_record.html#update — Muhammad Raheel

M_A_K M_A_K · Accepted Answer · 2012-07-02T12:39:59

try this hope its work

function update2($data){
   foreach($data as $string_val){
   $this->db->update_batch('users',$string_val, "id");
    }
}

or

function update2($data){
   foreach($data as $string_val){
   $this->db->update_batch('users',$string_val->first_name, "id");
    }
}

Update Database Field Error CodeIgniter

5 Answers