Tutorial Create Read Update Delete (CRUD) Laravel 5.8
Laravel menjadi salah satu framework yang sangat populer beberapa tahun terkhir.
Laravel sangat populer karena salah satunya sangat mudah digunakan dan berbasis command base. Operasi-operasi yang bisa digunakan jadi lebih efesien.
Salah satu operasinya yakni CRUD atau Create Read Update Delete.
Laravel upate versi terbarunya yakni 5.8 di tanggal 26 Februari 2019.
Lalu bagaimana cara untuk membuat CRUD di laravel, berikut ini adalah cara untuk membuat operasi tersebut:
1. Install Laravel 5.8
composer create-project --prefer-dist laravel/laravel larave58_crud 5.8
2. Konfigurasi Basis Data
Setelah instalasi lengkap laravel. kita harus konfigurasi database. sekarang kita akan membuka file .env dan mengubah nama database, nama pengguna, kata sandi dalam file .env. Lihat perubahan di bawah dalam file .env.
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=Enter_Your_Database_Name(larave58_crud)
DB_USERNAME=Enter_Your_Database_Username(root)
DB_PASSWORD=Enter_Your_Database_Password(root)
3. Membuat tabel dengan migration
Sekarang, Kita perlu membuat migrasi. jadi kita akan perintah di bawah ini menggunakan membuat tabel migrasi siswa.
php artisan make:migration create_students_table --create=students
Setelah migrasi lengkap. kita perlu perubahan di bawah ini dalam file database/migrations/create_students_table.
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateStudentsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('students', function (Blueprint $table) {
$table->bigIncrements('id');
$table->string('first_name');
$table->string('last_name');
$table->text('address');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('students');
}
}
?>
Jalankan perintah di bawah ini. setelah perubahan file di atas.
php artisan migrate
4. Buat file Resource Route in web.php
Kita harus meletakkannya di bawah student resource route in routes/web.php
Route::resource('student','StudentController');
5. Membuat Model dan Controller
Di sini di bawah ini perintah membantu untuk membuat controller dan model.
php artisan make:controller StudentController --resource --model=Student
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Student extends Model
{
protected $fillable = [
'first_name','last_name', 'address'
];
}
?>
StudentController.php
<?php
namespace App\Http\Controllers;
use App\Student;
use Illuminate\Http\Request;
class StudentController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//
$students = Student::all();
return view('admin.student.list', compact('students','students'));
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
//
return view('admin.student.create');
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
//
$request->validate([
'txtFirstName'=>'required',
'txtLastName'=> 'required',
'txtAddress' => 'required'
]);
$student = new Student([
'first_name' => $request->get('txtFirstName'),
'last_name'=> $request->get('txtLastName'),
'address'=> $request->get('txtAddress')
]);
$student->save();
return redirect('/student')->with('success', 'Student has been added');
}
/**
* Display the specified resource.
*
* @param \App\Student $student
* @return \Illuminate\Http\Response
*/
public function show(Student $student)
{
//
return view('admin.student.view',compact('student'));
}
/**
* Show the form for editing the specified resource.
*
* @param \App\Student $student
* @return \Illuminate\Http\Response
*/
public function edit(Student $student)
{
//
return view('admin.student.edit',compact('student'));
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param \App\Student $student
* @return \Illuminate\Http\Response
*/
public function update(Request $request,$id)
{
//
$request->validate([
'txtFirstName'=>'required',
'txtLastName'=> 'required',
'txtAddress' => 'required'
]);
$student = Student::find($id);
$student->first_name = $request->get('txtFirstName');
$student->last_name = $request->get('txtLastName');
$student->address = $request->get('txtAddress');
$student->update();
return redirect('/student')->with('success', 'Student updated successfully');
}
/**
* Remove the specified resource from storage.
*
* @param \App\Student $student
* @return \Illuminate\Http\Response
*/
public function destroy(Student $student)
{
//
$student->delete();
return redirect('/student')->with('success', 'Student deleted successfully');
}
}
?>
Akhirnya, kita akan membuat file layout.blade.php dan kita akan membuat list.blade.php, create.blade.php, view.blade.php, dan edit.blade.php di direktori "resources/ views/student/" .
layout.blade.php
<!DOCTYPE html>
<html lang="en">
<head>
<title>Bootstrap Example</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
@yield('content')
</div>
</body>
</html>
list.blade.php
@extends('student.layouts.app')
@section('content')
<div class="row">
<div class="col-lg-11">
<h2>Laravel 5.8 CRUD Example</h2>
</div>
<div class="col-lg-1">
<a class="btn btn-success" href="{{ route('student.create') }}">Add</a>
</div>
</div>
@if ($message = Session::get('success'))
<div class="alert alert-success">
<p>{{ $message }}</p>
</div>
@endif
<table class="table table-bordered">
<tr>
<th>No</th>
<th>First Name</th>
<th>Last Name</th>
<th>Address</th>
<th width="280px">Action</th>
</tr>
@php
$i = 0;
@endphp
@foreach ($students as $student)
<tr>
<td>{{ ++$i }}</td>
<td>{{ $student->first_name }}</td>
<td>{{ $student->last_name }}</td>
<td>{{ $student->address }}</td>
<td>
<form action="{{ route('student.destroy',$student->id) }}" method="POST">
<a class="btn btn-info" href="{{ route('student.show',$student->id) }}">Show</a>
<a class="btn btn-primary" href="{{ route('student.edit',$student->id) }}">Edit</a>
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
@endforeach
</table>
@endsection
create.blade.php
@extends('student.layouts.app')
@section('content')
<div class="row">
<div class="col-lg-11">
<h2>Add New Product</h2>
</div>
<div class="col-lg-1">
<a class="btn btn-primary" href="{{ url('student') }}"> Back</a>
</div>
</div>
@if ($errors->any())
<div class="alert alert-danger">
<strong>Whoops!</strong> There were some problems with your input.<br><br>
<ul>
@foreach ($errors->all() as $error)
<li>{{ $error }}</li>
@endforeach
</ul>
</div>
@endif
<form action="{{ route('student.store') }}" method="POST">
@csrf
<div class="form-group">
<label for="txtFirstName">First Name:</label>
<input type="text" class="form-control" id="txtFirstName" placeholder="Enter First Name" name="txtFirstName">
</div>
<div class="form-group">
<label for="txtLastName">Last Name:</label>
<input type="text" class="form-control" id="txtLastName" placeholder="Enter Last Name" name="txtLastName">
</div>
<div class="form-group">
<label for="txtAddress">Address:</label>
<textarea class="form-control" id="txtAddress" name="txtAddress" rows="10" placeholder="Enter Address"></textarea>
</div>
<button type="submit" class="btn btn-default">Submit</button>
</form>
@endsection
view.blade.php
@extends('student.layouts.app')
@section('content')
<div class="row">
<div class="col-lg-11">
<h2>Laravel 5.7 CRUD Example</h2>
</div>
<div class="col-lg-1">
<a class="btn btn-primary" href="{{ url('student') }}"> Back</a>
</div>
</div>
<table class="table table-bordered">
<tr>
<th>First Name:</th>
<td>{{ $student->first_name }}</td>
</tr>
<tr>
<th>Last Name:</th>
<td>{{ $student->first_name }}</td>
</tr>
<tr>
<th>Address:</th>
<td>{{ $student->address }}</td>
</tr>
</table>
@endsection
edit.blade.php
@extends('student.layouts.app')
@section('content')
<div class="row">
<div class="col-lg-11">
<h2>Update Student</h2>
</div>
<div class="col-lg-1">
<a class="btn btn-primary" href="{{ url('student') }}"> Back</a>
</div>
</div>
@if ($errors->any())
<div class="alert alert-danger">
<strong>Whoops!</strong> There were some problems with your input.<br><br>
<ul>
@foreach ($errors->all() as $error)
<li>{{ $error }}</li>
@endforeach
</ul>
</div>
@endif
<form method="post" action="{{ route('student.update',$student->id) }}" >
@method('PATCH')
@csrf
<div class="form-group">
<label for="txtFirstName">First Name:</label>
<input type="text" class="form-control" id="txtFirstName" placeholder="Enter First Name" name="txtFirstName" value="{{ $student->first_name }}">
</div>
<div class="form-group">
<label for="txtLastName">Last Name:</label>
<input type="text" class="form-control" id="txtLastName" placeholder="Enter Last Name" name="txtLastName" value="{{ $student->last_name }}">
</div>
<div class="form-group">
<label for="txtAddress">Address:</label>
<textarea class="form-control" id="txtAddress" name="txtAddress" rows="10" placeholder="Enter Address">{{ $student->address }}</textarea>
</div>
<button type="submit" class="btn btn-default">Submit</button>
</form>
@endsection
Mungkin itu saja materi pada hari ini, kalian bisa mencobanya langsung agar lebih mengena.
Sumber : https://xpertphp.com/post/laravel-58-crud-tutorial-example
Post a Comment for "Tutorial Create Read Update Delete (CRUD) Laravel 5.8 "