Codeigniter delete record where some select query?

Question

In codeigniter I want to delete record from a table. But at the same time I want to remove a record from another table which having foreign key to that record. Is there any possible way to do this using codeigniter?

1st delete query

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

1st table

id | description | image

2nd table

id | category_id | parent_category

You don't need PHP/codeigniter for this, just use mysql triggers after deletion. — Ben Fortune
– Ben Fortune, Commented Jul 14, 2014 at 10:59

Ben Fortune · Accepted Answer · 2014-07-14 11:03:04Z

2

Instead of having PHP doing the heavy work, you can do this straight from MYSQL with a trigger. This will trigger after a deletion.

CREATE TRIGGER delete_trigger_tbl_2 AFTER DELETE ON category_info
FOR EACH ROW
BEGIN
DELETE FROM tbl_2
    WHERE tbl_2.id = old.id; 
-- Or category_id, not clear in your question.
END

answered Jul 14, 2014 at 11:03

Ben Fortune

32.2k10 gold badges82 silver badges82 bronze badges

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

Collectives™ on Stack Overflow

Codeigniter delete record where some select query?

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