LARAVEL Tutorial


Laravel 6 Build CRUD Application Example Tutorial


Laravel CRUD(Create, Read, Update, Delete) Example Tutorial. In this tutorial, you will learn how to insert, update, read, delete data from MySQL database table. And create CRUD (Create, Read, Update, Delete) application in Laravel.

This tutorial has the purpose to explain to you, how you easily insert, update, read, delete data from MySQL database tables and built a CRUD web application in Laravel.

Laravel CRUD Example Tutorial

  • Install Laravel Application
  • Configure Database Detail
  • Create Model and Migration
  • Run Migration
  • Create Routes
  • Generate Controller By Artisan
  • Create Blade View
  • Start Development Server

Install Laravel Application

First Step, you need to download or install laravel web application new setup on your local machine. you can use the following command to download or install laravel application new setup:

composer create-project laravel/laravel Laravel-Crud-App –-prefer-dist

If you want to install a specific version of laravel, you can follow the following tutorial

https://w3alert.com/laravel-tutorial/laravel-install-on-windows-ubuntu-with-composer

Configure Database Detail

After that, you will set up the database credentials in .env file. So open your .env file and update database credentials following:

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

Create Model and Migration

Next, we need to create a model and migration in your laravel web application using the php artisan make:model model_name -m. So run the following command in your project root directory.

Go to the command prompt

cd/project_root_directory

php artisan make:model Post -m

after that, go to database/migrations/ and find created migration file and add fields, as you want to in your database table.

Your migration file looks like:

<?php

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

class CreatePostsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('posts', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('title');
            $table->text('description');
            $table->timestamps();
        });
    }

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

And go to the app/ directory and find the model file.

Your model file looks like:

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model
{
    //
}

Run Migration

Before you will run php artisan migrate command. Go to app/providers/AppServiceProvider.php and update the below code :

..
use Illuminate\Support\Facades\Schema;
 
....
function boot()
{
    Schema::defaultStringLength(191);
}
... 

Next, go to command prompt and run the following command:

php artisan migrate
OR
php artisan migrate:fresh

This php artisan migrate command creates a table in your database.

Create Routes

Next step, go to routes/web.php file and update the following routes into your file:

//retrive data and display list
Route::get('list','PostController@index');

//show insert form and store data into database
Route::get('show-form','PostController@showForm');
Route::post('insert-record','PostController@insertRecord');

//display and update data into database
Route::get('edit/{id?}','PostController@edit');
Route::post('update-record','PostController@updateRecord');

//delete data into database laravel
Route::get('delete/{id?}','PostController@deleteRecord');

Generate Controller By Artisan

Now, you need to generate or create a controller file using artisan command, so use the php artisan make:controller command and create a new controller file:

php artisan make:controller PostController

In this controller file, we will create 5 methods for performing crud operation in laravel web application.

After that, go to App/Http/Controllers/ directory and find the created PostController file and update the following code into your file:

<?php
namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Validator,Redirect,Response;
use App\Post;

class PostController extends Controller
{  

    public function index()
    {  
       $data['posts'] = Post::paginate(10);
       return view('list', $data);
    }

    public function showForm()
    {
      return view('insert-form');
    }

    public function insertRecord(Request $request)
    {
        $data = request()->validate([
        'title' => 'required',
        'description' => 'required',
        ]);
       
        $check = Post::insert($data);
        return Redirect::to("show-form")->withSuccess('Great! Form successfully submit with validation.');
    }
    public function edit(Request $request, $id)
    {
       
        $data['post'] = Post::where('id', $id)->first();

        if(!$data['post']){
           return redirect('/list');
        }
        return view('edit', $data);
    }

    public function updateRecord(Request $request)
    {
        $data = request()->validate([
        'title' => 'required',
        'description' => 'required',
        ]);
       
        if(!$request->id){
           return redirect('/list');
        }

        $check = Post::where('id', $request->id)->update($data);
        return Redirect::to("list")->withSuccess('Great! Form data successfully updated');
    }    
    public function deleteRecord(Request $request, $id)
    {
       
        if(!$id){
           return redirect('/list');
        }

        $check = Post::where('id', $id)->delete();
        return Redirect::to("list")->withSuccess('Great! data successfully deleted');
    }

}

Create Blade Views

Next, you need to create some blade view files, so go resource/views directory and create the following blade views file.

These files name are the following:

  • insert-form.blade.php
  • edit.blade.php
  • list.blade.php

Go to resource/views/insert-form.blade.php and update the following code:

<html>
   <head>
      <title>Laravel Insert Form Data Example</title>
      <meta charset="utf-8">
      <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
      <meta name="csrf-token" content="{{ csrf_token() }}">
      <link href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" rel="stylesheet">
   </head>
   <body>
      <div class="container mt-5">
         <div class="row">
            <div class="col-md-12">
 
               <form action="{{ url('insert-record') }}" method="post" accept-charset="utf-8">@csrf
                  <div class="form-group">
                     <label class="control-label col-sm-2" for="fname">Title</label>
                     <div class="col-sm-10">          
                        <input type="text" class="form-control" placeholder="Enter Title" name="title">
                        <span class="text-danger">{{ $errors->first('title') }}</span>
                     </div>
                  </div>
                  <div class="form-group">
                     <label class="control-label col-sm-2" for="comment">Description</label>
                     <div class="col-sm-10">
                        <textarea class="form-control" rows="5" name="description"></textarea>
                        <span class="text-danger">{{ $errors->first('description') }}</span>
                     </div>
                  </div>
                  <div class="form-group">
                     <div class="col-sm-offset-2 col-sm-10">
                        <button type="submit" class="btn btn-success">Submit</button>
                     </div>
                  </div>
               </form>
            </div>
         </div>
      </div>
   </body>
</html>

Next, Go to resource/views/edit.blade.php and update the following code:

<html>
   <head>
      <title>Laravel Update Form Data Example</title>
      <meta charset="utf-8">
      <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
      <meta name="csrf-token" content="{{ csrf_token() }}">
      <link href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" rel="stylesheet">
   </head>
   <body>
      <div class="container mt-5">
         <div class="row">
            <div class="col-md-12">
 
               <form action="{{ url('update-record') }}" method="post" accept-charset="utf-8">@csrf

                  <input type="hidden" class="form-control" name="id" value="{{ $post->id }}">

                  <div class="form-group">
                     <label class="control-label col-sm-2" for="fname">Title</label>
                     <div class="col-sm-10">          
                        <input type="text" class="form-control" placeholder="Enter Title" name="title" value="{{ $post->title }}">
                        <span class="text-danger">{{ $errors->first('title') }}</span>
                     </div>
                  </div>
                  <div class="form-group">
                     <label class="control-label col-sm-2" for="comment">Description</label>
                     <div class="col-sm-10">
                        <textarea class="form-control" rows="5" name="description">{{ $post->description }}</textarea>
                        <span class="text-danger">{{ $errors->first('description') }}</span>
                     </div>
                  </div>
                  <div class="form-group">
                     <div class="col-sm-offset-2 col-sm-10">
                        <button type="submit" class="btn btn-success">Submit</button>
                     </div>
                  </div>
               </form>
            </div>
         </div>
      </div>
   </body>
</html>

Next, Go to resource/views/list.blade.php and update the following code:

<html>
   <head>
      <title>Laravel Retrieve Data from Database</title>
      <meta charset="utf-8">
      <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
      <meta name="csrf-token" content="{{ csrf_token() }}">
      <link href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" rel="stylesheet">
   </head>
   <body>
      <div class="container mt-5">
         <div class="row">
            <a href="{{ url('insert-form') }}" class="btn btn-success mb-2">Add</a> 
              <br>
            <div class="col-md-12">
                     
             <table class="table table-bordered" id="laravel_crud">
              <thead>
                 <tr>
                    <th>Id</th>
                    <th>Title</th>
                    <th>Description</th>
                    <th>Created at</th>
                    <td colspan="2">Action</td>
                 </tr>
              </thead>
              <tbody>
                 @foreach($posts as $post)
                 <tr>
                    <td>{{ $post->id }}</td>
                    <td>{{ $post->title }}</td>
                    <td>{{ $post->description }}</td>
                    <td>{{ date('Y-m-d', strtotime($post->created_at)) }}</td>
                    <td><a href="{{  url('edit/'.$post->id) }}" class="btn btn-primary">Edit</a></td>
                    <td>
                    <form action="{{  url('delete/'.$post->id) }}" method="get">
                     {{ csrf_field() }}
                     <button class="btn btn-danger" type="submit">Delete</button>
                   </form>
                   </td>
                 </tr>
                 @endforeach
              </tbody>
             </table>
             {!! $posts->links() !!}
 
            </div>
         </div>
      </div>
   </body>
</html>

Start development server

You can use the following command artisan command to start the development server:

php artisan serve

The final step, go to your browser and type the below-given URL into your browser:

http://localhost:8000/list

OR

http://localhost/Laravel-Crud-App/public/list

You can download the full source code of Laravel CRUD Application Here,

Download Laravel Crud App