• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Updating a MySql table issue

#1
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?
Reply


Messages In This Thread
Updating a MySql table issue - by frobak - 07-18-2016, 08:38 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.