PHP delete from database with codeigniter

Question

I want to delete an entry in one table of my database. The table name is book. But in table title use foreign key book.

book: id, name
title: id, book_id, title

Now I want to delete an entry in book. So, I have to delete related entries in title table. My code is :

$this->db->where(book_id,$deleteid);
$this->db->delete(title);

$this->db->where(id,$deleteid);
$this->db->delete(book);

My question is whether the first where clause will affect my second delete clause? If it affects the second one, what should I do to avoid this?

Thanks. I am a beginner of PHP.

peterm · Accepted Answer · 2013-08-29 03:25:17Z

4

No the first where won't affect the second delete.

You may find it more intuitive if you rewrite it like this

$this->db->delete('title', array('book_id' => $deleteid));
$this->db->delete('book', array('id' => $deleteid));

answered Aug 29, 2013 at 3:25

peterm

93k16 gold badges157 silver badges162 bronze badges

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

Comments

goryo · Accepted Answer · 2013-08-29 03:15:02Z

0

Remember that you are deleting these entries in different tables. Each clauses you have are separate to each other so it will not affect each other.

answered Aug 29, 2013 at 3:15

goryo

246 bronze badges

user1289896 · Accepted Answer · 2013-08-29 03:21:04Z

0

You are doing it right , Just delete the foreign key row from title table then delete the primary key row from the book table.

answered Aug 29, 2013 at 3:21

user1289896