After deleting a row. how to get its id.
we can receive inserted ID from $this->db->insert_id(). Is there similar function for getting deleted records id.
Asked
Active
Viewed 5,087 times
-2
-
No, you should remember this yourself. In whatever way. You could just store it as a setting, or in a session. But that is very user-specific. – Dec 31 '13 at 15:05
-
1first retrieve the id and then delete the record ! it would be the better way to get id...... – Pranav C Balan Dec 31 '13 at 15:07
-
before to delete a row save ID – Domenico Luciani Dec 31 '13 at 15:08
-
I might have a great solution for this (triggers). But first, what are to trying to achieve? – andershagbard Dec 31 '13 at 15:27
-
you can delete a row only with ID!! so you have it! – Majid Golshadi Dec 31 '13 at 16:52
-
The thing is i am deleting it with some other where columns but i wanted the deleted primary key id. No problem i made a get where to get primary key id then i deleted the rows. – user3002327 Jan 02 '14 at 04:26
2 Answers
1
However you will the id to delete a record.
In model, you will pass id as parameter. try below code.
public function delete_row($id)
{
$this->db->where(array("id"=>$id));
$this->db->delete("my_table");
if($this->db->affected_rows()>0)
return $id;
else
return false;
}
Note: If you didn't pass id. then you have to use same parameters which are used to delete to get the record before deleting the record.
Kumar V
- 8,810
- 9
- 39
- 58
0
You should first save the id you are about to delete in a variable then after passing the variable(id) to the query and the row is deleted you will be able to do whatever you want with the id that is still stored in the the variable. simple and straight forward no functions added needed.
Orville Patterson
- 524
- 4
- 20