Laravel INSERT UPDATE DELETE Example Step By Step

Laravel INSERT UPDATE DELETE Example Step By Step

In this Post We Will Explain About is Laravel INSERT UPDATE DELETE Example – CRUD Operations in Laravel 5 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 insert update delete example in phpExample

In this post we will show you Best way to implement insert update delete in Laravel Example, hear for Laravel crud application demo,with Download .we will give you demo,Source Code and examples for implement Step By Step Good Luck!.

CRUD Operations in Laravel 5

There are the following List of step By step Create file and folder

  • Database Table Creation
  • Model Creation (page)
  • Controller Creation (pages)
  • Routing
  • Layouts and
  • Views

Database Table Creation

First of all simple created this folder or directory

READ :  PHP Laravel CRUD Application Tutorial for Beginners

[php]
cd /var/www/html/laravel
[/php]

second step to simple create a Laravel Project to run this command

[php]
php artisan make:migration create_posts_table –create=article
[/php]

Open the your created : database/migrations/xxxxxx_create_posts_table.php file and simple add some Lines and structure the fields to store level the basic information Like as a:

[php]
increments(‘id’);
$table->string(‘header’, 100);
$table->text(‘datadesc’);
$table->dateTime(‘cr_date’);
$table->dateTime(‘modified’);
});
}

public function down()
{
Schema::drop(‘article’);
}
}
[/php]

run this command to create your table with database
[php]
php artisan migrate
[/php]

Model Creation (page)

[php]
php artisan make:model page
[/php]

The newly simple cr_date fields page model will be simple located in Like as a “app/” directory.

app/page.php

[php]
<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class page extends Model
{
//simple fillable fields
protected $fillable = ['header', 'datadesc'];

//simple custom timestamps name
const CREATED_AT = 'cr_date';
const UPDATED_AT = 'modified';
}
[/php]

Controller Creation (Posts)

app/Http/Controllers

define a myliveController by creating a simple “app/Http/Controllers/myliveController.php” file.

1.index() Method
2.details() Method
3.add() Method
4.insert() Method
5.edit() Method
6.update() Method
7.delete()

myliveController.php

[php]
get();

//pass article data to view and load simple list view
return view(‘article.index’, [‘article’ => $article]);
}

public function details($id){
//fetch page data
$page = page::find($id);

//pass article data to view and load list view
return view(‘article.details’, [‘page’ => $page]);
}

READ :  Autocomplete jQuery TextBox Dropdown Example

public function add(){
//load form view
return view(‘article.add’);
}

public function insert(Request $request){
//validate page data
$this->validate($request, [
‘header’ => ‘required’,
‘datadesc’ => ‘required’
]);

//get page data
$postData = $request->all();

//insert page data
page::create($postData);

//store status message
Session::flash(‘success_msg’, ‘page added successfully!’);

return redirect()->route(‘article.index’);
}

public function edit($id){
//get page data by id
$page = page::find($id);

//load form view
return view(‘article.edit’, [‘page’ => $page]);
}

public function update($id, Request $request){
//validate page data
$this->validate($request, [
‘header’ => ‘required’,
‘datadesc’ => ‘required’
]);

//get page data
$postData = $request->all();

//update page data
page::find($id)->update($postData);

//store status message
Session::flash(‘success_msg’, ‘page updated successfully!’);

return redirect()->route(‘article.index’);
}

public function delete($id){
//update page data
page::find($id)->delete();

//store status message
Session::flash(‘success_msg’, ‘page deleted successfully!’);

return redirect()->route(‘article.index’);
}

}
[/php]

Routing

app/Http/routes.php

[php]
name(‘article.index’);
Route::get(‘/article/details/{id}’, ‘myliveController@details’)->name(‘article.details’);
Route::get(‘/article/add’, ‘myliveController@add’)->name(‘article.add’);
Route::page(‘/article/insert’, ‘myliveController@insert’)->name(‘article.insert’);
Route::get(‘/article/edit/{id}’, ‘myliveController@edit’)->name(‘article.edit’);
Route::page(‘/article/update/{id}’, ‘myliveController@update’)->name(‘article.update’);
Route::get(‘/article/delete/{id}’, ‘myliveController@delete’)->name(‘article.delete’);
[/php]

Layouts

Create a simple resources/views/layouts/app.blade.php file.

app.blade.php

[php]

Simple Laravel CRUD Operations – Step by step



https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js

https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js

READ :  Advantages and Features of DOMO

h1{font-size:25px;}
.pull-left h2{margin-top:0;font-size:30px;}

CRUD simple (Create Read Update Delete) new Operations in Laravel

@yield(‘datadesc’)

[/php]

Views

resources/views/article

index.blade.php:

[php]
@extends(‘layouts.app’)

@section(‘datadesc’)

@if(Session::has(‘success_msg’))

{{ Session::get(‘success_msg’) }}

@endif

@if(!empty($article))

Posts List

@endif

@endsection
[/php]

details.blade.php:

[php]
@extends(‘layouts.app’)

@section(‘datadesc’)

Read page

header:
{{ $page->header }}

comments:
{{ $page->datadesc }}

Published On:
{{ $page->cr_date }}

@endsection
[/php]

add.blade.php:

[php]
@extends(‘layouts.app’)

@section(‘datadesc’)

@if($errors->any())

@foreach($errors->all() as $error)

{{ $error }}

@endforeach()

@endif

Add a New page Back
{{ csrf_field() }}

@endsection
[/php]

edit.blade.php:

[php]
@extends(‘layouts.app’)

@section(‘datadesc’)

@if($errors->any())

@foreach($errors->all() as $error)

{{ $error }}

@endforeach()

@endif

Edit page Back
id) }}” method=”POST” class=”form-horizontal”>
{{ csrf_field() }}

header }}”>

@endsection
[/php]

Simple run your Laravel Project URL

[php]
http://example.com/article
[/php]

Example

I hope you have Got What is CRUD (Create Read Update Delete) Example in Laravel 5.2 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 Reply

Your email address will not be published. Required fields are marked *