Level 61
$room = Room::find($id);
$room->bookings()->delete();
$room->delete();
2 likes
Jan 18, 2021
5
Level 1
Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails
excuse me how can delete i try use of of this method but not successful
1- $room_info = Room::where("id", $id)->delete();
2- DB::table('rooms')->where('id',$id)->delete();
i understand that Rooms have foreign in bookings what best method to delete it with foreign key. thxs
Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (hotelbooking.bookings, CONSTRAINT bookings_room_id_foreign FOREIGN KEY (room_id) REFERENCES rooms (id)) (SQL: delete from rooms where id = 3) in file
Level 1
thxs man it worked with me. was trying some method like it but not worked $room=Room::find($id); $room->bookings()->detach(); $room>delete(); but your method work thxs
Level 61
You probably have one-to-many relationship and I've never tried detach() for it. So maybe that failed. It is important that it works for you. Thanks. All best.
Level 1
yes relation was one-to-many because it detach() wasn't work .
Level 60
Looks like in your bookings table you have some records where room_id = 3, first you have to delete records from bookings table, then delete everything from rooms table. Or learn about https://www.techonthenet.com/sql_server/foreign_keys/foreign_delete.php
add a constraint to cascade delete
Please or to participate in this conversation.