Codeigniter DB insert is not working properly(it inserts wrong value)

Question

Currently, I am using Codeigniter 3.1.0. I am trying to insert data using $this->db->insert('table') in Model.

The problem is that when I try to insert a certain filed value as 0, it would not insert 0, instead, it inserts 10.

I have verified the value of the data and its type.

Any suggestion or advice would be appreciated. Thank you in advance.

    $data['Vat'] = 0;

    foreach ( $data as $key => $value ) {
        if ( $value === null ) {
            continue;
        }
        $this->db->set($key, $value);
    }
    // $this->db->set('Vat', 0);

    $this->db->insert(self::TABLE);
    $q = $this->db->affected_rows();
    return $this->db->insert_id();

Does the table column have a default value, and is the column itself have the same name (and case) as the data key you are using? — gabe3886
– gabe3886, Commented Feb 28, 2017 at 16:33
@gabe3886 I don't have a default value for that column 'Vat'. The name of the column is different from the data key(the name of the column is 'Vat' and the data key is 'vat'). However, I have another columns that are all lower-cased and they dont have any problem with inserting. — Hax0r
– Hax0r, Commented Mar 2, 2017 at 1:27

Ashish Tiwari · Accepted Answer · 2017-02-28 16:29:08Z

1

You can have look on your query by using last_query() function. just add below line after $this->db->insert(self::TABLE); and check whether query is perfect or not. You will get idea where you missing.

 echo $this->db->last_query(); die;

answered Feb 28, 2017 at 16:29

Ashish Tiwari

2,3971 gold badge18 silver badges28 bronze badges

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

1 Comment

Hax0r Over a year ago

Thank you for the response. I have tried your suggestion; I copied the query and executed it. It inserts correct value for vat. However, when I try to insert date through model, it inserts 10 instead of 0 which is desired value.

Hax0r · Accepted Answer · 2017-03-02 01:46:42Z

0

The query was correct, however, after put function, update function(which I did not expect) was executed and it updated its value to 10. Thank you all for your responses.

answered Mar 2, 2017 at 1:46

Hax0r

1,8334 gold badges29 silver badges45 bronze badges

Collectives™ on Stack Overflow

Codeigniter DB insert is not working properly(it inserts wrong value)

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related