Create php code from UPDATE SQL statement (codeigniter)

Question

I have this query statement in SQL. I am using CodeIgniter and I would like to create these statements inline in PHP code.

UPDATE `dbhpl`.`pelayanan` 
    SET `pelayanan`.`ID_STATUS` = CASE 
    WHEN `pelayanan`.`LAMA` > `pelayanan`.`ESTIMASI` THEN '1' 
    WHEN `pelayanan`.`LAMA` <= `pelayanan`.`ESTIMASI` THEN '2' 
END

How is the code for controller.php and model.php?

Nithin Krishnan P · Accepted Answer · 2015-07-03 04:59:55Z

3

Model Function :

public function update_special() {
        $str = "UPDATE dbhpl.pelayanan SET "
                . "pelayanan.ID_STATUS = "
                . "CASE WHEN pelayanan.LAMA > pelayanan.ESTIMASI THEN '1'"
                . " WHEN pelayanan.LAMA <= pelayanan.ESTIMASI "
                . "THEN '2' END";
        $this->db->query($str);
        if ($this->db->affected_rows() > 0) {
            return true;
        } else {
            return false;
        }
    }

Controller Function

 function controller_function(){
        return $this->model->update_special();
    }

answered Jul 3, 2015 at 4:59

Nithin Krishnan P

7581 gold badge6 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Create php code from UPDATE SQL statement (codeigniter)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related