CodeIgniter UPDATE query to add a variable amount to a column value [duplicate]

Question

I am executing an UPDATE query with variable onterpolation, but I want to use CodeIgniter's query builder methods.

$query = "update employee
          set employee_salary=employee_salary+ '" . $bones . '"
          where employee_id='" . $data['employee_id'] . "'
            and employee_code='" . $data['employee_code'] . "'";

i use the following code but does not work as below

$this->db->where('employee_id', $data['employee_id']);
$this->db->where('employee_code', $data['employee_code']);
$this->db->set('employee_salary', 'employee_salary+ $bones', FALSE);
$this->db->update('spar_m_in_out');

I want to update the employee salary by summing the current value with $bones.

Rahul Kaushik · Accepted Answer · 2014-09-02 12:38:31Z

2

You should update the third line as below:

$employee_salary  =   $employee_salary + $bones
$this->db->set('employee_salary', $employee_salary ), FALSE);

answered Sep 2, 2014 at 12:38

Rahul Kaushik

1,4648 silver badges16 bronze badges

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

2 Comments

Rahul Kaushik Over a year ago

yes it will work.. Try to debug using echo $this->db->last_query();

mickmackusa Over a year ago

This answer's score is not indicative of its quality. This answer recommends clearly invalid code and flawed thinking. $employee_salary doesn't even exist, but the code is acting like the value has been pre-fetched from the database.

Damien Pirsy · Accepted Answer · 2014-09-02 12:37:47Z

1

The variable isn't interpreted since it's inside single quotes, and gets passed down as is.

Concatenate the string so as to evaluate the variable and pass it as a whole string expression to the DB:

$this->db->set('employee_salary', 'employee_salary + '.$bones, FALSE);

answered Sep 2, 2014 at 12:37

Damien Pirsy

25.5k8 gold badges72 silver badges77 bronze badges

Collectives™ on Stack Overflow

CodeIgniter UPDATE query to add a variable amount to a column value [duplicate]

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related