How To Create CRUD Operation in Laravel 10

in this Laravel tutorial, We’ll demonstrate how to perform CRUD operations with Laravel and MySQL. The CRUD(creates, reads, updates, and deletes) operations on a database using Laravel 10 with the help of Eloquent. Laravel application using Laravel’s Eloquent ORM and perform the operation.

CRUD Functionality in Laravel

Let’s perform create, read, update, and delete operations on a database using Laravel 10.

There are the following pre-requisite for this tutorial:

• XAMPP
• Composer

We’ll follow the following steps to create the CRUD Laravel app:

• Install Laravel and create a new application
• Create a database
• Create a table using migartion
• Create a controller
• Set up the model
• Add a route
• Generate Blade files
• run laravel application

Create a New Laravel Application

Open your terminal to create your Laravel application by running the following command:

composer create-project laravel/laravel laravel-crud

Once Your project has been created, You’ll have to install the Laravel dependencies. To do so, execute the following command inside your project directory:

composer update

Create a Database and Table

Let’s create a ‘test’ database and create a new migration file using the below command:

php artisan make:migration create_employees_table --create=employees

You can get more information from Laravel migartion.

public function up()
{
  Schema::create('employees', function (Blueprint $table) {
    $table->id();
    $table->string('name');
    $table->integer('salary');
$table->integer('age');
    $table->timestamps();
  });
}

Connect Your database with ‘Test’ db:

You need to edit your application’s .env file at the root of your Laravel application. Locate the variables prefixed with DB_ and edit them with your database credentials:

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3036
DB_DATABASE=test
DB_USERNAME=root
DB_PASSWORD=pass

It would help if you replaced variable values as per your MySQL host credentials.

Run the migrations files:

php artisan migrate

Create A Model

Let’s  create the employee table in the database by running the below command:

php artisan make:model Employee

Create a Controller Using Model

Let’s create a controller file scaffolding of all CRUD methods using Artisan:

php artisan make:controller EmployeeController --resource --model=Employee

The above command creates an EmployeeController.php file in app/Http/Controllers, This file contains the empty function index, store, show, update, and destroy.

The updated Code:

use App\Models\Employee
use Illuminate\Http\Request;

class EmployeeController extends Controller
{
    public function index()
    {
        $emps = Employee::all();

        return view('emps.index', ['emps' => $emps]);
    }

    public function create()
    {
        return view('emps.create');
    }

    public function store(Request $request)
    {
        $validatedData = $request->validate([
            'name' => 'required|string|max:255',
            'age' => 'required',
            'salary' => 'required',
        ]);
  
        Employee::create($validatedData);
  
        return redirect()
            ->route('emps.index')
            ->with('success', 'Employee created successfully.');
    }

    public function show(Employee $emp)
    {
        return view('emps.show', ['emp' => $emp]);
    }

    public function edit(string $id)
    {
  $emp = Employee::findOrFail($id);
        return view('emps.edit', ['emp' => $emp]);
    }

    public function update(Request $request, string $id)
    {
        $emp = Employee::findOrFail($id);
        $validatedData = $request->validate([
            'name' => 'required|string|max:255',
            'age' => 'required',
            'salary' => 'required',
        ]);
        $emp->update($validatedData);
        return redirect()
            ->route('emps.index')
            ->with('success', 'Employee updated successfully.');
 }
 
 public function destroy(string $id)
    {
        $emp = Employee::findOrFail($id);
        $emp->delete();
       return redirect()->route('emps.index')->with('success', 'Employee deleted successfully.');
    }

}

Define Routes

Define the routes for users and emps in the `routes/web.php` file:

// routes/web.php
use App\Http\Controllers\EmployeeController;
Route::resource('emps', EmployeeController::class);

Create a Views blade template

Create a new directory named `emps` inside the `resources/views` directory and add the following files:

• resources/index.blade.php
• resources/create.blade.php
• resources/show.blade.php
• resources/edit.blade.php

I am creating one index.blade.php file to display all listings of employee data.

<! - resources/views/emps/index.blade.php -->
<!DOCTYPE html>
<html>
<head>
    <title>Employee List</title>
</head>

<body class="bg-gray-200">
    <a href="{{url('/')}}">
        <button class="bg-sky-500 my-2 mx-2 text-white text-black px-3 py-2 h-10" type="submit">Home</button>
    </a>

    <div
        class="flex justify-center  items-center content-center flex-col align-items-center min-h-screen border-2 border-black">
        <div class="w-1/4">
            <div class="flex justify-between w-full">
                <h1 class="text-xl font-bold">Employee List</h1>
                <a class="ms-3 bg-sky-500 text-white text-black px-3 py-2"
                    href="{{ route('emps.create') }}">Create</a>

            </div>
            <ul>
                @foreach ($emps as $emp)
                    <li class="my-3 list-none bg-white px-10 py-3">
                        <div class="flex justify-between items-center">
                            <div class="flex flex-col ">

                                <p>
                                    {{ ucwords($emp->name) }} - .{{ $emp->age }} - .{{ $emp->salary }}
                                </p>
                            </div>
                            <div class="flex items-center">

                                <a class="ms-3 bg-sky-500 text-white text-black px-3 py-2 h-10"
                                    href="{{ route('emps.edit', $emp->id) }}">Edit</a>
                                <form method="post" class="pt-4s"
                                    action="{{ route('emps.destroy', $emp->id) }}">
                                    @csrf
                                    @method('DELETE')
                                    <button type="submit"
                                        class="ms-3  bg-red-500 text-white text-black place-self-center  px-3 py-2">Delete</button>
                                </form>
                            </div>

                        </div>
                    </li>
                @endforeach
            </ul>
        </div>
    </div>
</body>

</html>

You need to create the rest of the views file.

Run the development server:

php artisan serve

Open your web browser and navigate to `http://localhost:8000/emps` to see the list of employees.

Conclusion

The popular Laravel framework is ideal for developing web applications. The CRUD functionality is necessary for scalable web applications. This article explained the basic ideas behind CRUD operations and how to use Laravel’s built-in functionality to implement them.