PHP Codeigniter delete return true but table not deleted

Question

If i remember correctly, i have tested this function a month ago and its working. Now its not.

This is the model :

function delete($table, $id) {
    $query = $this->db->delete($table, array('id'=>$id));
    //return $this->db->affected_rows();
    return $query;
}

And i use it on my controller :

 $schedule_id = $this->post('id');
   $result = $this->schedule_m->delete('schedule', $schedule_id);
   if($result == true )
        {
            $this->response(array('result' => 'true'), 200);
        }

The response is always true, but the row is never deleted.

I tried to return $this->db->affected_rows(); and use var_dump, the result is int(0).

Please kindly help me. Thanks for your time.

GautamD31 · Accepted Answer · 2014-10-16 06:04:32Z

2

Try with WHERE condition like

function delete($table, $id) {
    $this->db->where('id' , $id);
    $query = $this->db->delete($table);
}

And also check whether the table still have the same field id.

answered Oct 16, 2014 at 6:04

GautamD31

28.8k10 gold badges66 silver badges86 bronze badges

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

1 Comment

Blaze Tama Over a year ago

Its working now..i dont know what happened @@. I will accept your answer in 9 minutes (SO's system). Thanks a lot

Collectives™ on Stack Overflow

PHP Codeigniter delete return true but table not deleted

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related