Error in updating data in code igniter model

Question

this is model function

<?php
class change_data extends CI_Model {
    function __construct() {
        parent::__construct();
    }

    function change($id,$action)
    {
        if($action==0)
        $st=1;
        else
        $st=0;
        $data = array('gud_status' => $st);
        $where = "id=".$id; 
        $this->db->update_string('gallery', $data, $where);

        return $this->db->affected_rows();
    }

}

everything is working fine.. also getting 2 parameter values but table updation fails.. affect 0 rows!!!

any body can sort this!!

is you try your query in phpmyadmin is your query work fine? — Yaseen Ahmad
– Yaseen Ahmad, Commented May 27, 2016 at 5:25
yes its working fine in phpmyadmin.. is there any way to print mysql query errors in code igniter — NEET JASSI
– NEET JASSI, Commented May 27, 2016 at 5:30
use this for print query echo $this->db->last_query(); exit; — Yaseen Ahmad
– Yaseen Ahmad, Commented May 27, 2016 at 5:32
use this for last execute query echo $this->db->last_query();die; — SAUMYA
– SAUMYA, Commented May 27, 2016 at 5:33

Arvind Jaiswal · Accepted Answer · 2016-05-27 06:39:12Z

1

Pass where condition in array. Ex-

function change($id,$action)
{
    if($action==0)
    $st=1;
    else
    $st=0;
    $data = array('gud_status' => $st);
    $where = array('id'=>$id); 
    $this->db->update_string('gallery', $data, $where);

    return $this->db->affected_rows();
}

answered May 27, 2016 at 6:39

Arvind Jaiswal

4425 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Error in updating data in code igniter model

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related