Skip to content
Readerstacks logo Readerstacks
  • Home
  • Softwares
  • Angular
  • Php
  • Laravel
  • Flutter
Readerstacks logo
Readerstacks
How to Permanent Delete Soft Deleted Records in Laravel 9

How to Permanent Delete Soft Deleted Records in Laravel 9 ?

Aman Jain, June 18, 2022June 18, 2022

In this article we will learn to Permanent Delete soft deleted records in Laravel. In our recent article How to fetch Soft Deleted Records in Laravel 9 ? and How to Restore Soft Deleted Records in Laravel 9 we learnt to fetch the records from database and Restore the records which is soft deleted and sometimes we want to permanent delete the records that are soft deleted so to permanent delete the trashed items in database we need to call forceDelete method of eloquent model.

forceDelete indicates the model that we want to permanently delete the record which is soft deleted. we can use as follow

Article::withTrashed()->find($id)->forceDelete();

forceDelete also worked with relationships for example we want permanently delete all users along with soft deleted roles then we can use as below

$user->roles()->withTrashed()->forceDelete();

But make sure you have enable the Soft delete trait in model as below

Illuminate\Database\Eloquent\SoftDeletes

This trait instruct the eloquent model to exclude the trashed data while querying from the database so we will only get the data which is not deleted means we don’t need to do any extra efforts to tell laravel its deleted this trait Illuminate\Database\Eloquent\SoftDeletes will handle everything and forceDelete accordingly.

In this article I am going to create route, one controller, model and migrations file to learn the soft delete functionality.

Let’s start fetch Soft Deleted Records in Laravel 9 with simple step by step

Step 1: Create a fresh laravel project

Open a terminal window and type below command to create a new project

composer create-project --prefer-dist laravel/laravel blog

You can also read this to start with new project

Step 2 : Create a table and model

I assume the you have already installed the laravel and basic connection of it like database connection and composer.

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laravel-jwt
DB_USERNAME=root
DB_PASSWORD=

Now, for an example i am creating here a table using migration and then i am going to fill the data in it, so create model and migration

php artisan make:model Article -m

this will generate the model and migration file

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class Article extends Model
{
   use SoftDeletes;
   use HasFactory;
    
}

things to note here is we have added Illuminate\Database\Eloquent\SoftDeletes; and then used in class article as below

use SoftDeletes;

and migration file database/migrations/timestamp_create_articles_table.php

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return class extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
     public function up()
    {
        Schema::create('articles', function (Blueprint $table) {
            $table->id();
            $table->string('email')->unique();;
            $table->string('title');
            $table->string('body')->nullable();
            $table->timestamps();
            $table->softDeletes();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('articles');
    }
}

Make sure you have added $table->softDeletes(); line in your migration to create the deleted_at column in table.

$table->softDeletes();

and then migrate the migration

php artisan migrate

Step 3 : Create controller

Let’s create a controller and add a methods showArticle and addArticle

php artisan make:controller ArticleController

and add the below code

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\Article;
use Illuminate\Support\Facades\Validator;

class ArticleController extends Controller
{
    public function showArticle(Request $request)
    {

        $articles = new Article;
        $articles = $articles->when($request->show_trashed=='1',function($q){
          $q->withTrashed();
        })->get();
         //or we can use directly if don't want it conditionally as below
       // $articles->withTrashed()->get();
        return view('articles.article', ['articles' => $articles]);
    }

     

    function deleteArticle(Request $request)
    {

        $validator = Validator::make($request->all(), [
            'id' => "required",
        ]);
        if ($validator->fails()) {
            return redirect()->back()->withInput()->withErrors($validator->errors());
        }
        Article::find($request->id)->delete();
        return back()
            ->with('success', 'Article deleted successfully');
    }
    
    function forceDeleteArticle(Request $request)
    {

        $validator = Validator::make($request->all(), [
            'id' => "required",
        ]);
        if ($validator->fails()) {
            return redirect()->back()->withInput()->withErrors($validator->errors());
        }
        Article::withTrashed()->find($request->id)->forceDelete();
        return back()
            ->with('success', 'Article permanently deleted successfully');
    }
}

Here we used forceDeleteArticle method to permanently delete the article

function forceDeleteArticle(Request $request)
    {

        $validator = Validator::make($request->all(), [
            'id' => "required",
        ]);
        if ($validator->fails()) {
            return redirect()->back()->withInput()->withErrors($validator->errors());
        }
        Article::withTrashed()->find($request->id)->forceDelete();
        return back()
            ->with('success', 'Article permanently deleted successfully');
    }

Step 4 : Create View File

Now, show the upload form in view file and also show the list of compressed images

resources/views/articles/article.blade.php

<!DOCTYPE html>
<html>

<head>
    <title>How to Permanent Delete Soft Deleted Records in Laravel 9  -  readerstacks.com</title>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css">
</head>

<body>
    <div class="container">

        <div class="panel panel-primary">
            <div class="panel-heading">
                <h2>How to Permanent Delete Soft Deleted Records in Laravel 9  - readerstacks.com</h2>
            </div>
            <div class="panel-body">

                @if ($message = Session::get('success'))
                <div class="alert alert-success alert-block">
                    <button type="button" class="close" data-dismiss="alert">×</button>
                    <strong>{{ $message }}</strong>
                </div>

                @endif
                <br><br>
                  
                <h2>All Articles</h2>
                 <a  href="{{url('articles?show_trashed=1')}}" class="btn btn-success">Show with Trashed</a>
            
                <table class="table">
                    <tr>
                        <th>Name</th>
                        <th>Email</th>

                        <th>Action</th>

                    </tr>
                    @foreach( $articles as $article)
                    <tr>
                        <td>{{$article->title}}</td>
                        <td>
                        {{$article->email}}
                        </td>
                        <td>
                        @if(!$article->trashed())
                          <a class='btn btn-warning' href="{{url('delete-article?id='.$article->id)}}">Delete</a>
                        @endif   
                         @if($article->trashed())
                          <a  class='btn btn-danger' href="{{url('force-delete-article?id='.$article->id)}}">Permanent Delete</a>
                         @endif   
                       </td>
                    </tr>
                    @endforeach
                </table>
            </div>
        </div>
    </div>
</body>
</html>


create another view for show all

Step 4: Create routes in routes/web.php

One route for show all articles, another route for delete the article and restore the article.

routes/web.php

<?php

use App\Http\Controllers\ArticleController;
use Illuminate\Support\Facades\Route;


Route::get('/articles',[ArticleController::class,"showArticle"]);
Route::get('/force-delete-article',[ArticleController::class,"forceDeleteArticle"]);

Results Screenshot:

How to Permanent Delete Soft Deleted Records in Laravel 9
How to Permanent Delete Soft Deleted Records in Laravel 9
How to Permanent Delete Soft Deleted Records in Laravel 9
How to Permanent Delete Soft Deleted Records in Laravel 9

Related

Php Laravel Laravel 9 forece deletelaravelpermanent deletesoft deletewithTrashed

Post navigation

Previous post
Next post

Related Posts

Laravel 10 – Error During installation laravel/framework[v10.0.0] require composer-runtime-api ^2.2 – Solved

March 8, 2023March 16, 2024

Today i was installing laravel 10 with php version 8.2 and i encountered an issue laravel/framework[v10.0.0, …, v10.3.2] require composer-runtime-api ^2.2 -> found composer-runtime-api[2.1.0] but it does not match the constraint. This issue occurred due to old composer. So we can quickly fix this by running below command May be…

Read More
Php How to Import or Convert ExcelCSV to HTML in laravel 8 9

How to Import or Convert Excel/CSV to HTML in laravel 8 / 9?

May 7, 2022May 13, 2022

Excel or CSV are used to store large set of data to analyses and for reporting. In this article we will learn to import excel or CSV in laravel. This tutorial is best fit to you if you want to understand the basic of import in database table with custom…

Read More
Php Understanding laravel request

Understanding Laravel request with example

November 17, 2021November 22, 2021

Laravel provides a own class to handle the request which is Illuminate\Http\Request. Request is used to retrieve the user input(GET and POST), cookies and files that was submitted during the request. Get the request in controller Current Request can be get retrieved in controller by injecting the dependency in controller…

Read More

Aman Jain
Aman Jain

With years of hands-on experience in the realm of web and mobile development, they have honed their skills in various technologies, including Laravel, PHP CodeIgniter, mobile app development, web app development, Flutter, React, JavaScript, Angular, Devops and so much more. Their proficiency extends to building robust REST APIs, AWS Code scaling, and optimization, ensuring that your applications run seamlessly on the cloud.

Categories

  • Angular
  • CSS
  • Dart
  • Devops
  • Flutter
  • HTML
  • Javascript
  • jQuery
  • Laravel
  • Laravel 10
  • Laravel 11
  • Laravel 9
  • Mysql
  • Php
  • Softwares
  • Ubuntu
  • Uncategorized

Archives

  • July 2025
  • June 2025
  • May 2025
  • April 2025
  • October 2024
  • July 2024
  • February 2024
  • January 2024
  • December 2023
  • November 2023
  • October 2023
  • July 2023
  • March 2023
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021

Recent Posts

  • Mapping Together: The Vibrant Spirit of OpenStreetMap Japan
  • Understanding High Vulnerabilities: A Deep Dive into the Weekly Summary
  • Building a Million-Dollar Brand: The Journey of Justin Jackson
  • Mastering Schedule Management with Laravel Zap
  • The Resilience of Nature: How Forests Recover After Fires
©2023 Readerstacks | Design and Developed by Readerstacks
Go to mobile version