CodeIgniter Forums
Updating a MySql table issue - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forum-5.html)
+--- Forum: General Help (https://forum.codeigniter.com/forum-24.html)
+--- Thread: Updating a MySql table issue (/thread-65740.html)



Updating a MySql table issue - frobak - 07-18-2016

I am having an issue with updating a MySql table using codeigniter.

Basically, its inserting 'img' the characters, into the table column 'progress' rather than the value of the variable ($progress).

This is so strange!

Here is my model:


PHP Code:
    public function update_course_progress($progress_data) {
        $course_id  $progress_data['course_id'];
        $user_id   $progress_data['user_id'];
        $progress $progress_data['progress'];
        $status $progress_data['status'];
    
        $update_data 
= array (
            'progress'  => $progress,
            'status'    => $status,
        );
        // perform update on the matching row
        $this->db->update('training_stats'$update_data, array('course_id' => $course_id'user_id' => $user_id));
    


So, the issue is with 'progress' instead of inserting the value of this variable it is inserting 'img'???

So, if i var_dump $update_data i get this:

   
PHP Code:
array(2) { ["progress"]=> string(2"1a" ["status"]=> string(1"i" 


Which is correct:

And if i use the profiler in CI to get the db queries, this is what I get:


PHP Code:
     UPDATE `training_statsSET `progress` = '1a', `status` = 'i'
    WHERE `course_id` = '8'
    AND `user_id` = '2'   


Which is correct.

So why is it inserting 'img' into the db instead of 1a.

The table structure for this column is VARCHAR(4).


Code:
    progress varchar(4) NOT NULL DEFAULT '0',

I'm not getting any errors, and if I input the query above directly into phpmyadmin it works fine?

What can be wrong?