Laravel Crud Tutorial From Scratch – Laravel Insert Update Delete

Table of Contents

Laravel Crud Tutorial From Scratch – Laravel Insert Update Delete

In this Post We Will Explain About is Laravel Crud Tutorial From Scratch – Laravel Insert Update Delete With Example and Demo.Welcome on infinityknow.com – Examples, The best For Learn web development Tutorials,Demo with Example! Hi Dear Friends here u can know to Laravel 5.4 CRUD (Create Read Update Delete) Example from Scratch Example

In this post we will show you Best way to implement Simple Laravel CRUD with Resource Controllers , hear for Laravel 5 – Create Simple CRUD(Create Read Update Delete) with Download .we will give you demo,Source Code and examples for implement Step By Step Good Luck!.

Laravel 5.4 Crud Example From Scratch

Welcome, infinityknow.com, In today’s infinityknow Tutorial, I have Learn the Simple simple code of Laravel Crud Example From Scratch as well as steps by step. It is simple Laravel 5 Comments for beginners.

Overview Laravel 5 Crud Example From Scratch

[php]
1 Laravel
2 Phase 1: Make a Laravel project
3 Phase 2: Edit .env simple file data for database configuration
4 Phase 3: Use migrations Available by laravel In to some Make users and password_resets table
5 Phase 4: Make a controller simple file data for our CRUD operations.
6 Phase 5: Make a model simple file data for CRUD operations.
7 Phase 6: Edit crud migration simple file data and Make the Simple required fields for the Simple database.
8 Phase 7: Make views for set up a form
9 Phase 8: Make a form in create.blade.php
10 Phase 9: Setup a route for the Simple request handling.
11 Phase 10: Edit SimpleCRUDCtrl File
12 Phase 11: Add CSRF token and set the Simple comments route of the Simple form.
13 Phase 12: Source Code the Simple DataAdd function and use Crud model In to some insert the Simple data
14 Phase 13: Source Code index() function in the Simple SimpleCRUDCtrl File.
15 Phase 14: Need In to some update index.blade.php
16 Phase 15: Add Edit and Delete Button in the Simple index.blade.php
17 Phase 16: Make an edit function In to some pass the Simple data In to some the Simple edit view.
18 Phase 17: Make an edit view.
19 Phase 18: Source Code update() in the Simple SimpleCRUDCtrl.
20 Phase 19: Make a delete form In to some delete the Simple data.
21 Phase 20: Source Code the Simple destroy() method in the Simple SimpleCRUDCtrl.
22 Output
22.1 Github: Github Download
22.2 Steps In to some use Github code
[/php]

READ :  AngularJS Nested ng-repeat Get Multiple checkbox value

Laravel

For creating Laravel simple Project, We need In to some have below following simple some things Like as a.

1. Latest PHP >= 5.6.4
2. simple OpenSSL PHP Extension
3. PDO version PHP Extension
4. Mbstring of the Simple PHP Extension
5. Tokenizer PHP simple Extension
6. XML some PHP Extension
7. Setup Composer

Phase 1: Make a Laravel project

Type below following simple command in our CMD(terminal) Command Prompt In to some create a project.

[php]
composer create-project –prefer-dist laravel/laravel Laravel5.4
[/php]

It shall take 2 minutes In to some install a brand new Laravel Framework

and then installing, After that, Now our project root Dirctory and type php artisan serve in CMD(terminal) Command Prompt, our project URL might look like It’s

[php]
http://localhost:8000
[/php]

Now open that laravel project Dirctory in our favorite editor Like as a Notepad++.

Phase 2: Edit .env simple file data for database setting means configuration

In our project root Dirctory, there is a simple file data called .env, Extentions, which we need In to some edit In to some set up a database setting means configuration. We Are using MySQL database.

[php]
//setup .env

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laravel5.4
DB_USERNAME=root
DB_PASSWORD=mysql
[/php]

Phase 3: Use migrations Available by laravel In to some Make users and password_resets table

Now After that, Now CMD(terminal) Command Prompt, and run below following simple command

[php]
php artisan migrate
[/php]

If We have Making the Simple database in simple MySQL and We have Available correct setting means credentials In to some the Simple .env simple file data, then We shall learn In to some there are created simple three tables generated in MySQL dynemically database.

Phase 4: Make a controller simple file data for our Laravel CRUD operations.

After That CMD(terminal) Command Prompt, type the Simple below following simple command in our root project.

[php]
php artisan create:controller SimpleCRUDCtrl –resource
[/php]

Now After that, Now laravel5.4 Versions > app > Http > Controllers, We shall learn In to some SimpleCRUDCtrl simple file data in that Dirctory.

This simple file data has all the Simple boilerplate some needed for our Crud operations using Laravel.

Phase 5: Make a model simple file data for CRUD operations.

In the Simple CMD(terminal) Command Prompt, type the Simple below following simple command in our root project.

[php]
php artisan create:model Crud -m
[/php]

This command shall also create a migration simple file data for our CRUD operations.

Phase 6: Edit Laravel crud Operations migration simple file data and make the Simple required fields for the Simple database.

Migration database simple file data is path ti located in laravel5.4 Versions -> database -> migrations Dirctory.

READ :  AngularJS File Upload using Ajax POST Form Web API

[php]
increments(‘id’);
$table->string(‘subject’);
$table->string(‘comments’);
$table->timestamps();
});
}

/**
* Devloped By infinityknow.com Reverse the Simple migrations.
*
* Devloped By infinityknow.com @return void
*/
public function down()
{
Schema::dropIfExists(‘cruds’);
}
}
[/php]

Run the Simple below following simple command in our CMD(terminal) Command Prompt.

[php]
php artisan migrate
[/php]

Phase 7: Make views for set up a HTML form

After That laravel5.4 Versions -> resources -> views . Locate into that Dirctory and then make a master view called master.blade.php. A create blade is templating some engine used by laravel.

[php]

Devloped By infinityknow.com CRUD Operations

@yield(‘content’)

[/php]

Now Make a new Dirctory inside views directory called crud. Go inside that Dirctory and Make below following simple files data

index.blade.php
create.blade.php
edit.blade.php

Phase 8: Make a form in create.blade.php

[php]

@extends(‘master’)
@section(‘content’)

@endsection
[/php]

Phase 9: Setup a route for the Simple some request handling.

After That the Simple routes -> web.php

[php]
welcome’);
});
Route::resource(‘crud’, ‘SimpleCRUDCtrl’);
[/php]

Here we have added some resource route, and all the Simple functions reside in app -> Http -> controllers -> SimpleCRUDCtrl

Phase 10: Edit SimpleCRUDCtrl File

[php]
//Devloped By infinityknow.com SimpleCRUDCtrl.php

/**
*Devloped By infinityknow.com Show the Simple form for creating a new resource.
*
*Devloped By infinityknow.com @return \Illuminate\Http\Response
*/
public function create()
{
return view(‘crud.create’);
}
[/php]

Here we have In to some return the Simple view when the Simple request hits the Simple route; it shall be redirected In to some It’s controller’s make method. Our view should be accessible via below following simple URL the Simple form.

[php]
http://localhost:8000/crud/create
[/php]

We are now able In to some learn In to some the Simple form with the Simple two fields.

Phase 11: Add CSRF some token and set the Simple comments route of the Simple form.

[php]

@extends(‘master’)
@section(‘content’)

{{csrf_field()}}

@endsection
[/php]

We have put the Simple {{csrf_field()}} in the Simple form so that malicious attack could not harm our web application.

Phase 12: Source Code the Simple DataAdd function and use Crud model In to some insert the Simple data

[php]
$request->get(‘subject’),
‘comments’ => $request->get(‘comments’)
]);

$liveCrud->save();
return redirect(‘/crud’);
}

/**
*Devloped By infinityknow.com Display the Simple specified resource.
*
*Devloped By infinityknow.com @param int $id
*Devloped By infinityknow.com @return \Illuminate\Http\Response
*/
public function show($id)
{
//Devloped By infinityknow.com
}

/**
*Devloped By infinityknow.com Show the Simple form for editing the Simple specified resource.
*
*Devloped By infinityknow.com @param int $id
*Devloped By infinityknow.com @return \Illuminate\Http\Response
*/
public function edit($id)
{
//Devloped By infinityknow.com
}

/**
*Devloped By infinityknow.com Update the Simple specified resource in storage.
*
*Devloped By infinityknow.com @param \Illuminate\Http\Request $request
*Devloped By infinityknow.com @param int $id
*Devloped By infinityknow.com @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
//Devloped By infinityknow.com
}

/**
*Devloped By infinityknow.comDevloped By infinityknow.com Remove the Simple specified resource from storage.
*
*Devloped By infinityknow.com @param int $id
*Devloped By infinityknow.com @return \Illuminate\Http\Response
*/
public function destroy($id)
{
//Devloped By infinityknow.com
}
}
[/php]

Here we need In to some create a protected field called $fillable in the Simple Crud model. Otherwise, it shall throw a mass assignment exception.

READ :  PHP Laravel CRUD Application Tutorial for Beginners

[php]
//Devloped By infinityknow.com Crud.php
<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Crud extends Model
{
protected $fillable = ['subject','comments'];
}
[/php]

Now, when We fill the Simple subject and comments field in our form and submit the Simple form, the Simple new entry shall be added In to some the Simple database. We could confirm it by below following simple steps.

Phase 13: Source Code index() function in the Simple SimpleCRUDCtrl File.

[php]
//Devloped By infinityknow.com CrudController.php

toArray();

return view(‘crud.index’, compact(‘cruds’));
}

/**
*Devloped By infinityknow.com Show the Simple form for creating a new resource.
*
*Devloped By infinityknow.com @return \Illuminate\Http\Response
*/
public function create()
{
return view(‘crud.create’);
}

/**
*Devloped By infinityknow.com Store a newly created resource in storage.
*
*Devloped By infinityknow.com @param \Illuminate\Http\Request $request
*Devloped By infinityknow.com @return \Illuminate\Http\Response
*/
public function DataAdd(Request $request)
{
$liveCrud = new Crud([
‘subject’ => $request->get(‘subject’),
‘comments’ => $request->get(‘comments’)
]);

$liveCrud->save();
return redirect(‘/crud’);
}

/**
*Devloped By infinityknow.com Display the Simple specified resource.
*
*Devloped By infinityknow.com @param int $id
*Devloped By infinityknow.com @return \Illuminate\Http\Response
*/
public function show($id)
{
//Devloped By infinityknow.com
}

/**
* Show the Simple form for editing the Simple specified resource.
*
*Devloped By infinityknow.com @param int $id
*Devloped By infinityknow.com @return \Illuminate\Http\Response
*/
public function edit($id)
{
//Devloped By infinityknow.com
}

/**
*Devloped By infinityknow.com Update the Simple specified resource in storage.
*
*Devloped By infinityknow.com @param \Illuminate\Http\Request $request
*Devloped By infinityknow.com @param int $id
*Devloped By infinityknow.com @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
//Devloped By infinityknow.com
}

/**
*Devloped By infinityknow.com Remove the Simple specified resource from storage.
*
*Devloped By infinityknow.com @param int $id
*Devloped By infinityknow.com @return \Illuminate\Http\Response
*/
public function destroy($id)
{
//Devloped By infinityknow.com
}
}
[/php]

Phase 14: Need In to some update index.blade.php

[php]

@extends(‘master’)
@section(‘content’)

@foreach($cruds as $data_val)

@endforeach

ID Title Comments
{{$comments[‘id’]}} {{$comments[‘subject’]}} {{$comments[‘comments’]}}

@endsection
[/php]

Next, shoot the Simple below following simple URL.

[php]
http://localhost:8000/crud
[/php]

You shall learn In to some a table which has the Simple id, subject and comments column with their respective data.

Phase 15: Add Edit and Delete Button in the Simple index.blade.php

[php]

@extends(‘master’)
@section(‘content’)

@foreach($cruds as $data_val)

@endforeach

ID Title Comments Action
{{$comments[‘id’]}} {{$comments[‘subject’]}} {{$comments[‘comments’]}} Edit Delete

@endsection
[/php]

Phase 16: Make an edit function In to some pass the Simple data In to some the Simple edit view.

[php]
<?php

//Devloped By infinityknow.com SimpleCRUDCtrl.php
/**
*Devloped By infinityknow.com Show the Simple form for editing the Simple specified resource.
*
*Devloped By infinityknow.com @param int $id
*Devloped By infinityknow.com @return \Illuminate\Http\Response
*/
public function edit($id)
{
$liveCrud = Crud::find($id);

return view('crud.edit', compact('crud','id'));

}
[/php]

Phase 17: Make an edit view.

[php]

@extends(‘master’)
@section(‘content’)

{{csrf_field()}}

subject}}”>

@endsection
[/php]

Here we have used one more hidden field called _method, which shall be a PATCH request In to some the Simple server so that we could update the Simple data very quickly.

Phase 18: Source Code update() in the Simple SimpleCRUDCtrl.

[php]
subject = $request->get(‘subject’);
$liveCrud->comments = $request->get(‘comments’);
$liveCrud->save();
return redirect(‘/crud’);
}
[/php]

and then filling the Simple update form, we could learn In to some the Simple index page that our data is updated. Therefore now only Delete functionality is remaining.

Phase 19: Make a delete form In to some delete the Simple data.

[php]

@extends(‘master’)
@section(‘content’)

@foreach($cruds as $data_val)

@endforeach

ID Title Comments Action
{{$comments[‘id’]}} {{$comments[‘subject’]}} {{$comments[‘comments’]}} Edit
{{csrf_field()}}


@endsection
[/php]

Phase 20: Source Code the Simple destroy() method in the Simple SimpleCRUDCtrl.

[php]
delete();

return redirect(‘/crud’);
}
[/php]

Here in delete functionality, we have not put the Simple any confirm dialog box, but it is very okay for the Simple demo. We just want We In to some data take It’s live demo and learn In to some how the Simple laravel’ flow step by step is working.

Output

There is some routes list in resource controller. Type in the Simple CMD(terminal) Command Prompt: php artisan route:list

If We are curious how some resource controller works data behind the Simple scenes,and then It’s is very our answer.

Github:

Github code

Steps In to some use Github code

  • Clone the Simple repo in our local.
  • After That root of the Simple project and run command “composer update“
  • Edit .env simple file data and use our MySQL database credentials.
  • Run the Simple command “php artisan migrate“
  • Now, we need In to some bootstrap Laravel server so run “php artisan serve“
  • If now After that, Now It’s URL: http://localhost:8000/crud/create

Example

I hope you have Got What is how to use insert update delete in laravel 5.4 And how it works.I would Like to have FeadBack From My Blog(infinityknow.com) readers.Your Valuable FeadBack,Any Question,or any Comments abaout This Article(infinityknow.com) Are Most Always Welcome.

Leave a Comment