> For the complete documentation index, see [llms.txt](https://hummasoft.gitbook.io/hummasoft-training-laravel-1/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://hummasoft.gitbook.io/hummasoft-training-laravel-1/training/laravel-web-development/step-4-materials/laravel-crud-dengan-eloquen-orm.md).

# Laravel CRUD (Dengan Eloquen ORM)

1.Koneksikan project laravel dengan database dengan mengatur .env

2\. Buat controller nya

```
php artisan make:controller PostController --resource
```

3..buat routes nya

```
Route::resource('post', 'PostController');
```

| url                    | Methods  | handler                  | Keterangan                                                                                     |
| ---------------------- | -------- | ------------------------ | ---------------------------------------------------------------------------------------------- |
| `/post`                | `GET`    | `PostController@index`   | menampilkan list data pertanyaan-pertanyaan (boleh menggunakan table html atau bootstrap card) |
| `/post/create`         | `GET`    | `PostController@create`  | menampilkan form untuk membuat pertanyaan baru                                                 |
| `/post`                | `POST`   | `PostController@store`   | menyimpan data baru ke tabel pertanyaan                                                        |
| `/post/{post_id}`      | `GET`    | `PostController@show`    | menampilkan detail pertanyaan dengan id tertentu                                               |
| `/post/{post_id}/edit` | `GET`    | `PostController@edit`    | menampilkan form untuk edit pertanyaan dengan id tertentu                                      |
| `/post/{post_id}`      | `PUT`    | `PostController@update`  | menyimpan perubahan data pertanyaan (update) untuk id tertentu                                 |
| `/post/{post_id}`      | `DELETE` | `PostController@destroy` | menghapus pertanyaand dengan id tertentu                                                       |

4\. buat databasenya\
5\. buat table menggunakan migration

| Id    | `bigIncrements` | pk auto\_increment |
| ----- | --------------- | ------------------ |
| Title | string          | –                  |
| Body  | text            | –                  |

6\. buat modelnya

```
php artisan make:model Post
```

**Post.php**

```
class post extends model
{
    protected $table = "post";
    protected $fillable = ["title", "body"];
}
```

protect $table = “post”; berfungsi mengarahkan model ke table post di database\
protect $fillable berfungsi Kolom apa saja yang akan di manipulasi

## **Create Data**

**PostController.php**

```
<?php
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
 
use App\Post;
 
class PostController extends Controller
{
    public function create()
    {
    	return view('post.create');
    }
 
    public function store(Request $request)
    {
    	$this->validate($request,[
    		'title' => 'required',
    		'body' => 'required'
    	]);
 
        Post::create([
    		'title' => $request->title,
    		'body' => $request->body
    	]);
 
    	return redirect('/post');
    }
```

use App\Post;\
berfungsi import model yang berada si direktori folder app\
Post::create(\[\
‘title’ => $request->nama,\
‘body’ => $request->alamat\
]);

\
berfungsi melakukan pengimputan data ke database fitur eloquent dengan method create()

&#x20;

**resources/views/post/create.blade.php**

```
 <h2>Tambah Data</h2>
        <form action="/posts" method="POST">
            @csrf
            <div class="form-group">
                <label for="title">Title</label>
                <input type="text" class="form-control" name="title" id="title" placeholder="Masukkan Title">
                @error('title')
                    <div class="alert alert-danger">
                        {{ $message }}
                    </div>
                @enderror
            </div>
            <div class="form-group">
                <label for="body">body</label>
                <input type="text" class="form-control" name="body" id="body" placeholder="Masukkan Body">
                @error('body')
                    <div class="alert alert-danger">
                        {{ $message }}
                    </div>
                @enderror
            </div>
            <button type="submit" class="btn btn-primary">Tambah</button>
        </form>
```

## **Tampil Data**

**PostController.php**

```
public function index()
    {
        $post = Post::all();
        return view('post.index', compact('post'));
    }
```

Post::all();\
berfungsi mengambil semua data di database fitur eloquent dengan method all()

**resources/views/post/index.blade.php**

```
<a href="/posts/create" class="btn btn-primary mb-3">Tambah</a>
        <table class="table">
            <thead class="thead-light">
              <tr>
                <th scope="col">#</th>
                <th scope="col">Title</th>
                <th scope="col">Body</th>
                <th scope="col">Actions</th>
              </tr>
            </thead>
            <tbody>
                @forelse ($post as $key=>$value)
                    <tr>
                        <td>{{$key + 1}}</th>
                        <td>{{$value->title}}</td>
                        <td>{{$value->body}}</td>
                        <td>
                            <a href="/posts/{{$value->id}}" class="btn btn-info">Show</a>
                            <a href="/posts/{{$value->id}}/edit" class="btn btn-primary">Edit</a>
                            <form action="/posts/{{$value->id}}" method="POST">
                                @csrf
                                @method('DELETE')
                                <input type="submit" class="btn btn-danger my-1" value="Delete">
                            </form>
                        </td>
                    </tr>
                @empty
                    <tr colspan="3">
                        <td>No data</td>
                    </tr>  
                @endforelse              
            </tbody>
        </table>
```

## **Tampil data berdasarakan id**

**PostController.php**

```
public function show($id)
    {
        $post = Post::find($id);
        return view('post.show', compact('post'));
    }
```

Post::find($id);\
berfungsi mengambil semua data berdasarkan variabel id $id di database fitur eloquent dengan method find()

**resources/views/post/show\.blade.php**

```
<h2>Show Post {{$post->id}}</h2>
<h4>{{$post->title}}</h4>
<p>{{$post->body}}</p>Update Data
```

#### **PostController.php**

```
public function edit($id)
    {
        $post = Post::find($id);
        return view('post.edit', compact('post'));
    }

    public function update($id, Request $request)
    {
        $request->validate([
            'title' => 'required|unique:post',
            'body' => 'required',
        ]);

        $post = post::find($id);
        $post->title = $request->title;
        $post->body = $request->body;
        $post->update();
        return redirect('/post');
    }
```

$post = post::find($id);\
$post->title = $request->title;\
$post->body = $request->body;\
$post->update();\
berfungsi mengubah data bedasarkan method find($id) ke database fitur eloquent dengan method update()

&#x20;

**resources/views/post/edit.blade.php**

```
<div>
        <h2>Edit Post {{$post->id}}</h2>
        <form action="/posts/{{$post->id}}" method="POST">
            @csrf
            @method('PUT')
            <div class="form-group">
                <label for="title">Title</label>
                <input type="text" class="form-control" name="title" value="{{$post->title}}" id="title" placeholder="Masukkan Title">
                @error('title')
                    <div class="alert alert-danger">
                        {{ $message }}
                    </div>
                @enderror
            </div>
            <div class="form-group">
                <label for="body">body</label>
                <input type="text" class="form-control" name="body"  value="{{$post->body}}"  id="body" placeholder="Masukkan Body">
                @error('body')
                    <div class="alert alert-danger">
                        {{ $message }}
                    </div>
                @enderror
            </div>
            <button type="submit" class="btn btn-primary">Edit</button>
        </form>
    </div>
```

## **DELETE DATA**

**PostController.php**

```
public function destroy($id)
    {
        $post = Post::find($id);
        $post->delete();
        return redirect('/post');
    }
```

```
$post = Post::find($id);$post->delete();
```

Berfungsi menghapus data berdasarkan method find($id) ke database fitur eloquent dengan method delete()