Delete all related comments on deleting a post in Laravel
You can delete all the related comments to a post in laravel using the deleted event.
In Laravel, the deleted event trigger can be used to perform additional actions related to a deleted record. For example, if you have a Post model with a relationship to a Comment model, you can use the deleted event trigger to automatically delete all related comments when a post is deleted.
To delete the comments table records related to posts table record using deleted event, you have to create the posts table with id, title, slug ,body, created_at, updated_at columns and comments table with id, post_id, body, created_at and updated_at columns where post_id is the foreign key related to posts table id column. You also have to create the relationship between two tables (posts and comments) using hasMany relationship in the Post model.
app\Models\Post
class Post extends Model
{
use HasFactory;
protected $table = "posts";
protected $fillable = [
'title', 'slug', 'body', 'created_at', 'updated_at'
];
protected static function boot(){
parent::boot();
static::deleted (function($post){
$post->comments()->delete();
});
}
public function comments(){
return $this->hasMany (Comment::class);
}
}
routes/web.php
<?php
use Illuminate\Support\Facades\Route;
use App\Models\Post;
/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/
Route::get('/', function () {
Post::whereId(1)->first()->delete();
echo "Post with comments deleted";
});
Manually delete the comments table records
routes/web.php
<?php
use Illuminate\Support\Facades\Route;
use App\Models\Post;
use App\Models\Comment;
/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/
Route::get('/', function () {
$postId = 1;
Post::whereId($postId)->delete();
Comment::wherePostId($postId)->delete();
echo "deleted";
});
If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.
Don't forget to share this article! Help us spread the word by clicking the share button below.
We appreciate your support and are committed to providing you valuable and informative content.
We are thankful for your never ending support.
Random Code Snippet Queries: Laravel
- How to make Copy or Duplicate table row in laravel
- How to get count of all records created at yesterday
- How to upload multiple images after preview in laravel using cropper js
- How to avoid duplicate entries in pivot table in Laravel
- How to restore multiple records after soft-deletes in Laravel
- Get products with number of orders in Laravel
- Setup laravel project with docker
- The use statement with non-compound name 'DB' has no effect
- How to validate URL with https using regex in laravel
- How to add class to tr in table using foreach in laravel
- How to add unique records in pivot columns of Laravel pivot table
- Update last created record in Laravel
- Get laravel version
- Ajax POST request in laravel
- How to get random string in Laravel
- How to get session in blade Laravel ?
- How to add active class to menu item in laravel
- How to get only time from created_at in laravel
- How to get last year records count with month wise in Laravel
- Global scope in Laravel with example
- PhpMyAdmin - Error The mysqli extension is missing
- Database transactions in laravel
- Delete file from amazon s3 bucket using Laravel
- Add [name] to fillable property to allow mass assignment on [App\Models\Project]
- InRandomOrder() method with example in laravel