Laravel 9 Simple CRUD Application Example

In this tutorial you will learn about the Laravel 9 Simple CRUD Application Example and its application with practical example.

In this Laravel 9 Simple CRUD Application Example Tutorial, you will learn to create a simple CRUD (Create, Read, Update and Delete) application in Laravel 9. In this Laravel 9 CRUD operation example tutorial I’ll show you how to create a simple crud application in laravel 9. In this example we will learn how to create a simple crud operation application in laravel 9.

Table Of Contents−

Laravel CRUD Appliction
Laravel 9 Simple CRUD Application Example

Laravel CRUD Appliction

Laravel crud application is simple laravel application. We create a simple application perform basic CRUD (Create, Read, Update and Delete) operation on any resource in Laravel.

In this step by step guide, we will be creating a simple company crud operation application with validation in laravel 9. In this example you will learn how to insert, read, update and delete data from database in laravel 9.

Install Laravel 9
Setup Database with App
Create Company Model & Migration For CRUD App

Create Routes
Create Company CRUD Controller By Artisan Command
Create Blade Views File

Run Laravel CRUD App on Development Server

Install Laravel 9

First of all we need to create a fresh laravel project, download and install Laravel 9 using the below command

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

1	composer create-project --prefer-dist laravel/laravel lara9blog

Configure Database In .env file

Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .env file.

.env

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=lara9blog
DB_USERNAME=root
DB_PASSWORD=

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=lara9blog

DB_USERNAME=root

DB_PASSWORD=

Create Model & Migration

Now, in this step we will create model and migration file for form. Please run the following command:

php artisan make:model Company -m

1	php artisan make:model Company -m

Once above command is executed there will be a migration file created inside database/migrations/ directory, just open create_companies_table.php migration file and update the function up() method as following:

public function up()
{
    Schema::create('companies', function (Blueprint $table) {
        $table->id();
        $table->string('name');
        $table->string('email');
        $table->string('address');
        $table->timestamps();
    });
}

public function up()

{

Schema::create('companies', function (Blueprint $table) {

$table->id();

$table->string('name');

$table->string('email');

$table->string('address');

$table->timestamps();

});

}

Now, run following command to migrate database schema.

php artisan migrate

1	php artisan migrate

Create Routes

After this, we need to define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.

routes/web.php

use App\Http\Controllers\CompanyCRUDController;
 
Route::resource('companies', CompanyCRUDController::class);

use App\Http\Controllers\CompanyCRUDController;

Route::resource('companies', CompanyCRUDController::class);

Create Company CRUD Controller By Artisan Command

Next, we have to create a controller company crud application. Lets Create a controller named CompanyCRUDController using command given below –

php artisan make:controller CompanyCRUDController

1	php artisan make:controller CompanyCRUDController

Open the CompanyCRUDController.php file and put the following code in it.

app/Http/Controllers/CompanyCRUDController.php

<?php
namespace App\Http\Controllers;
use App\Models\Company;
use Illuminate\Http\Request;
class CompanyCRUDController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$data['companies'] = Company::orderBy('id','desc')->paginate(5);
return view('companies.index', $data);
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
return view('companies.create');
}
/**
* Store a newly created resource in storage.
*
* @param  \Illuminate\Http\Request  $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$request->validate([
'name' => 'required',
'email' => 'required',
'address' => 'required'
]);
$company = new Company;
$company->name = $request->name;
$company->email = $request->email;
$company->address = $request->address;
$company->save();
return redirect()->route('companies.index')
->with('success','Company has been created successfully.');
}
/**
* Display the specified resource.
*
* @param  \App\company  $company
* @return \Illuminate\Http\Response
*/
public function show(Company $company)
{
return view('companies.show',compact('company'));
} 
/**
* Show the form for editing the specified resource.
*
* @param  \App\Company  $company
* @return \Illuminate\Http\Response
*/
public function edit(Company $company)
{
return view('companies.edit',compact('company'));
}
/**
* Update the specified resource in storage.
*
* @param  \Illuminate\Http\Request  $request
* @param  \App\company  $company
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$request->validate([
'name' => 'required',
'email' => 'required',
'address' => 'required',
]);
$company = Company::find($id);
$company->name = $request->name;
$company->email = $request->email;
$company->address = $request->address;
$company->save();
return redirect()->route('companies.index')
->with('success','Company Has Been updated successfully');
}
/**
* Remove the specified resource from storage.
*
* @param  \App\Company  $company
* @return \Illuminate\Http\Response
*/
public function destroy(Company $company)
{
$company->delete();
return redirect()->route('companies.index')
->with('success','Company has been deleted successfully');
}
}

100

101

<?php

namespace App\Http\Controllers;

use App\Models\Company;

use Illuminate\Http\Request;

class CompanyCRUDController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

$data['companies'] = Company::orderBy('id','desc')->paginate(5);

return view('companies.index', $data);

}

/**

* Show the form for creating a new resource.

* @return \Illuminate\Http\Response

public function create()

{

return view('companies.create');

}

/**

* Store a newly created resource in storage.

* @param \Illuminate\Http\Request $request

* @return \Illuminate\Http\Response

public function store(Request $request)

{

$request->validate([

'name' => 'required',

'email' => 'required',

'address' => 'required'

]);

$company = new Company;

$company->name = $request->name;

$company->email = $request->email;

$company->address = $request->address;

$company->save();

return redirect()->route('companies.index')

->with('success','Company has been created successfully.');

}

/**

* Display the specified resource.

* @param \App\company $company

* @return \Illuminate\Http\Response

public function show(Company $company)

{

return view('companies.show',compact('company'));

}

/**

* Show the form for editing the specified resource.

* @param \App\Company $company

* @return \Illuminate\Http\Response

public function edit(Company $company)

{

return view('companies.edit',compact('company'));

}

/**

* Update the specified resource in storage.

* @param \Illuminate\Http\Request $request

* @param \App\company $company

* @return \Illuminate\Http\Response

public function update(Request $request, $id)

{

$request->validate([

'name' => 'required',

'email' => 'required',

'address' => 'required',

]);

$company = Company::find($id);

$company->name = $request->name;

$company->email = $request->email;

$company->address = $request->address;

$company->save();

return redirect()->route('companies.index')

->with('success','Company Has Been updated successfully');

}

/**

* Remove the specified resource from storage.

* @param \App\Company $company

* @return \Illuminate\Http\Response

public function destroy(Company $company)

{

$company->delete();

return redirect()->route('companies.index')

->with('success','Company has been deleted successfully');

}

Create Blade File

Now, create blade file for CRUD Operations accordingly. Let’s directory and some blade view, as following:

Make Directory Name Companies
index.blade.php
create.blade.php

edit.blade.php

Create directory name companies inside resources/views directory.

index.blade.php

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Laravel 9 CRUD Tutorial From Scratch</title>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" >
</head>
<body>
<div class="container mt-2">
<div class="row">
<div class="col-lg-12 margin-tb">
<div class="pull-left">
<h2>Laravel 9 CRUD Example Tutorial</h2>
</div>
<div class="pull-right mb-2">
<a class="btn btn-success" href="{{ route('companies.create') }}"> Create Company</a>
</div>
</div>
</div>
@if ($message = Session::get('success'))
<div class="alert alert-success">
<p>{{ $message }}</p>
</div>
@endif
<table class="table table-bordered">
<tr>
<th>S.No</th>
<th>Company Name</th>
<th>Company Email</th>
<th>Company Address</th>
<th width="280px">Action</th>
</tr>
@foreach ($companies as $company)
<tr>
<td>{{ $company->id }}</td>
<td>{{ $company->name }}</td>
<td>{{ $company->email }}</td>
<td>{{ $company->address }}</td>
<td>
<form action="{{ route('companies.destroy',$company->id) }}" method="Post">
<a class="btn btn-primary" href="{{ route('companies.edit',$company->id) }}">Edit</a>
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
@endforeach
</table>
{!! $companies->links() !!}
</body>
</html>

<!DOCTYPE html>

<head>

<title>Laravel 9 CRUD Tutorial From Scratch</title>

</head>

<body>

<h2>Laravel 9 CRUD Example Tutorial</h2>

</div>

<a class="btn btn-success" href="{{ route('companies.create') }}"> Create Company</a>

</div>

@if ($message = Session::get('success'))

<p>{{ $message }}</p>

</div>

@endif

<tr>

<th>Company Name</th>

<th>Company Email</th>

<th>Company Address</th>

<th width="280px">Action</th>

</tr>

@foreach ($companies as $company)

<tr>

<td>{{ $company->id }}</td>

<td>{{ $company->name }}</td>

<td>{{ $company->email }}</td>

<td>{{ $company->address }}</td>

<td>

<form action="{{ route('companies.destroy',$company->id) }}" method="Post">

@csrf

@method('DELETE')

<button type="submit" class="btn btn-danger">Delete</button>

</form>

</td>

</tr>

@endforeach

</table>

{!! $companies->links() !!}

</body>

</html>

create.blade.php

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Add Company Form - Laravel 9 CRUD</title>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" >
</head>
<body>
<div class="container mt-2">
<div class="row">
<div class="col-lg-12 margin-tb">
<div class="pull-left mb-2">
<h2>Add Company</h2>
</div>
<div class="pull-right">
<a class="btn btn-primary" href="{{ route('companies.index') }}"> Back</a>
</div>
</div>
</div>
@if(session('status'))
<div class="alert alert-success mb-1 mt-1">
{{ session('status') }}
</div>
@endif
<form action="{{ route('companies.store') }}" method="POST" enctype="multipart/form-data">
@csrf
<div class="row">
<div class="col-xs-12 col-sm-12 col-md-12">
<div class="form-group">
<strong>Company Name:</strong>
<input type="text" name="name" class="form-control" placeholder="Company Name">
@error('name')
<div class="alert alert-danger mt-1 mb-1">{{ $message }}</div>
@enderror
</div>
</div>
<div class="col-xs-12 col-sm-12 col-md-12">
<div class="form-group">
<strong>Company Email:</strong>
<input type="email" name="email" class="form-control" placeholder="Company Email">
@error('email')
<div class="alert alert-danger mt-1 mb-1">{{ $message }}</div>
@enderror
</div>
</div>
<div class="col-xs-12 col-sm-12 col-md-12">
<div class="form-group">
<strong>Company Address:</strong>
<input type="text" name="address" class="form-control" placeholder="Company Address">
@error('address')
<div class="alert alert-danger mt-1 mb-1">{{ $message }}</div>
@enderror
</div>
</div>
<button type="submit" class="btn btn-primary ml-3">Submit</button>
</div>
</form>
</body>
</html>

<!DOCTYPE html>

<head>

<title>Add Company Form - Laravel 9 CRUD</title>

</head>

<body>

<h2>Add Company</h2>

</div>

</div>

@if(session('status'))

</div>

@endif

@csrf

<strong>Company Name:</strong>

@error('name')

<div class="alert alert-danger mt-1 mb-1">{{ $message }}</div>

@enderror

</div>

<strong>Company Email:</strong>

@error('email')

<div class="alert alert-danger mt-1 mb-1">{{ $message }}</div>

@enderror

</div>

<strong>Company Address:</strong>

@error('address')

<div class="alert alert-danger mt-1 mb-1">{{ $message }}</div>

@enderror

</div>

<button type="submit" class="btn btn-primary ml-3">Submit</button>

</div>

</form>

</body>

</html>

edit.blade.php

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Edit Company Form - Laravel 9 CRUD Tutorial</title>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" >
</head>
<body>
<div class="container mt-2">
<div class="row">
<div class="col-lg-12 margin-tb">
<div class="pull-left">
<h2>Edit Company</h2>
</div>
<div class="pull-right">
<a class="btn btn-primary" href="{{ route('companies.index') }}" enctype="multipart/form-data"> Back</a>
</div>
</div>
</div>
@if(session('status'))
<div class="alert alert-success mb-1 mt-1">
{{ session('status') }}
</div>
@endif
<form action="{{ route('companies.update',$company->id) }}" method="POST" enctype="multipart/form-data">
@csrf
@method('PUT')
<div class="row">
<div class="col-xs-12 col-sm-12 col-md-12">
<div class="form-group">
<strong>Company Name:</strong>
<input type="text" name="name" value="{{ $company->name }}" class="form-control" placeholder="Company name">
@error('name')
<div class="alert alert-danger mt-1 mb-1">{{ $message }}</div>
@enderror
</div>
</div>
<div class="col-xs-12 col-sm-12 col-md-12">
<div class="form-group">
<strong>Company Email:</strong>
<input type="email" name="email" class="form-control" placeholder="Company Email" value="{{ $company->email }}">
@error('email')
<div class="alert alert-danger mt-1 mb-1">{{ $message }}</div>
@enderror
</div>
</div>
<div class="col-xs-12 col-sm-12 col-md-12">
<div class="form-group">
<strong>Company Address:</strong>
<input type="text" name="address" value="{{ $company->address }}" class="form-control" placeholder="Company Address">
@error('address')
<div class="alert alert-danger mt-1 mb-1">{{ $message }}</div>
@enderror
</div>
</div>
<button type="submit" class="btn btn-primary ml-3">Submit</button>
</div>
</form>
</div>
</body>
</html>

<!DOCTYPE html>

<head>

<title>Edit Company Form - Laravel 9 CRUD Tutorial</title>

</head>

<body>

<h2>Edit Company</h2>

</div>

</div>

@if(session('status'))

</div>

@endif

<form action="{{ route('companies.update',$company->id) }}" method="POST" enctype="multipart/form-data">

@csrf

@method('PUT')

<strong>Company Name:</strong>

<input type="text" name="name" value="{{ $company->name }}" class="form-control" placeholder="Company name">

@error('name')

<div class="alert alert-danger mt-1 mb-1">{{ $message }}</div>

@enderror

</div>

<strong>Company Email:</strong>

<input type="email" name="email" class="form-control" placeholder="Company Email" value="{{ $company->email }}">

@error('email')

<div class="alert alert-danger mt-1 mb-1">{{ $message }}</div>

@enderror

</div>

<strong>Company Address:</strong>

<input type="text" name="address" value="{{ $company->address }}" class="form-control" placeholder="Company Address">

@error('address')

<div class="alert alert-danger mt-1 mb-1">{{ $message }}</div>

@enderror

</div>

<button type="submit" class="btn btn-primary ml-3">Submit</button>

</div>

</form>

</div>

</body>

</html>

Start Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Now, open the following URL in browser to see the output –

http://localhost:8000/companies

1	http://localhost:8000/companies

AngularJS

CodeIgniter

Laravel

Node Js

Wordpress

More Blog

Learn

ABOUT PAGES

Laravel 9 Simple CRUD Application Example

Laravel CRUD Appliction