SQL queries in Cdeigniter

 Query for data insertion :

    public function insert_department($data)

    {

        $this->db->insert('departments', $data); 

        //echo $this->db->last_query();exit;            

        return true;

    }

Query for data updation :

public function update_department($data, $id)

    {

        $this->db->where('id', $id);

        $this->db->update('departments', $data);             

        return true;

    }

Query for data updation :

public function DeleteColors()

    {

        $this->db->where('id', $this->uri->segment(4));

        $query = $this->db->delete('color_codes');               

        return true;

    }