laravel 5.4 การ Creating, reading, updating, and deleting (CRUD) โดยใช้ Controllers

26 ก.ค. 2017 , 10,108 Views , หมวดหมู่ Laravel ทุกหมวดหมู่ โค๊ดดิ้ง , ป้ายกำกับ:laravel

เตรียมฐานข้อมูลให้พร้อม

เริ่มจากเตรียม Database ก่อนโดยเราจะใช้ตารางที่ชื่อ blogs โดยดูการสร้างจากหัวข้อนี้ laravel 5.4 การใช้งาน MIGRATIONS และ SEEDING

สร้าง Eloquent Model สำหรับ Blogs (ดูเพิ่มเติม)

โดยเข้าไปในโฟลเดอร์ app\Models หากไม่มีโฟลเดอร์ Models ก็ให้สร้างขึ้นมา แล้วสร้างไฟล์ชื่อ Blog.php ใว้ในโฟลเดอร์ Models

* การตั้งชื่อไฟล์จะใช้ชื่อตารางโดยตัด(s)ออก เช่น ตารางชื่อ blogs ก็จะตั้งชื่อเป็น Blog.php แต่หากจะตั้งแบบอื่นก็ได้ แล้วระบุชื่อตารางที่ต้องการ เช่น

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Flight extends Model
{
    /**
     * The table associated with the model.
     *
     * @var string
     */
    protected $table = 'blogs';
}

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Flight extends Model

{

/**

* The table associated with the model.

* @var string

protected $table = 'blogs';

}

มาเขียนต่อครับ ในไฟล์ Blog.php ให้เพิ่มโค๊ดดังนี้

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Blog extends Model
{
    /**
     * The table associated with the model.
     *
     * @var string
     */
}

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Blog extends Model

{

/**

* The table associated with the model.

* @var string

}

เราก็จะได้ Eloquent Model ที่ลิ้งค์กับตาราง blogs โดยสามารถเข้าถึงจาก Controllers ได้

สร้าง Controllers

โดยใช้ resource controller (ดูเพิ่มเติม) ใช้คำสั่ง Command Prompt ด้านล่างเพื่อสร้าง

php artisan make:controller BlogController --resource

1	php artisan make:controller BlogController --resource

หรือเข้าไปในโฟลเดอร์ app\Http\Controllers แล้วสร้างไฟล์ชื่อ BlogController.php ในไฟล์เขียนโค๊ดดังนี้

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class BlogController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        //
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        //
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //
    }

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

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

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

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        //
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class BlogController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

}

/**

* Show the form for creating a new resource.

* @return \Illuminate\Http\Response

public function create()

{

}

/**

* Store a newly created resource in storage.

* @param \Illuminate\Http\Request $request

* @return \Illuminate\Http\Response

public function store(Request $request)

{

}

/**

* Display the specified resource.

* @param int $id

* @return \Illuminate\Http\Response

public function show($id)

{

}

/**

* Show the form for editing the specified resource.

* @param int $id

* @return \Illuminate\Http\Response

public function edit($id)

{

}

/**

* Update the specified resource in storage.

* @param \Illuminate\Http\Request $request

* @param int $id

* @return \Illuminate\Http\Response

public function update(Request $request, $id)

{

}

/**

* Remove the specified resource from storage.

* @param int $id

* @return \Illuminate\Http\Response

public function destroy($id)

{

}

เนื่องจากเราสร้าง Model Blog ใว้ในโฟลเดอร์ app/Models ดังนั้นเราจึงต้องบอกให้ Controller รู้ว่าเราจะใช้ app/Models/Blog โดยกำหนด use App\Models\Blog; ใว้ที่ด้านบนของ Controller ดังนี้

<?php

namespace App\Http\Controllers;

use App\Models\Blog;
use Illuminate\Http\Request;

class BlogController extends Controller
{
.....

<?php

namespace App\Http\Controllers;

use App\Models\Blog;

use Illuminate\Http\Request;

class BlogController extends Controller

{

.....

กำหนดค่า Routes

เปิดไฟล์ routes/web.php แล้วเพิ่มโค๊ดดังนี้

Route::resource('blogs', 'BlogController');

1	Route::resource('blogs', 'BlogController');

โดยระบบจะกำหนด URL และ Action ในการ Creating, reading, updating, and deleting ให้อัตโนมัติ ตามตารางด้านล่าง

Actions Handled By the Controller

HTTP Verb	Path (URL)	Action (Method)	Route Name
GET	/blogs	index	blogs.index
GET	/blogs/create	create	blogs.create
POST	/blogs	store	blogs.store
GET	/blogs/{id}	show	blogs.show
GET	/blogs/{id}/edit	edit	blogs.edit
PUT/PATCH	/blogs/{id}	update	blogs.update
DELETE	/blogs/{id}	destroy	blogs.destroy

*สามารถกำหนดใช้เฉพาะบาง Action ใน Routes ได้ เช่น

Route::resource('blogs', 'BlogController', ['only' => [
    'index', 'show'
]]);

Route::resource('blogs', 'BlogController', ['except' => [
    'create', 'store', 'update', 'destroy'
]]);

Route::resource('blogs', 'BlogController', ['only' => [

'index', 'show'

]]);

Route::resource('blogs', 'BlogController', ['except' => [

'create', 'store', 'update', 'destroy'

]]);

View

ให้สร้าง view เพื่อใช้แสดงผลข้อมูลดังนี้

resources

views
- blogs
  - index.blade.php
  - create.blade.php
  - show.blade.php
  - edit.blade.php

หน้าแสดงทุกเรคคอร์ด

Description	URL	Controller Function	View File
Default page for showing all the blogs.	GET example.com/blogs	index()	resources/views/blogs/index.blade.php

Controller Function index() app\Http\Controllers\BlogController.php

<?php
...
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
       // get all the blogs
        $blogs = Blog::all()->sortByDesc('created_at');
		
        // load the view and pass the user
        return View('blogs.index')
            ->with('blogs', $blogs);
    }
...

<?php

...

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

// get all the blogs

$blogs = Blog::all()->sortByDesc('created_at');

// load the view and pass the user

return View('blogs.index')

->with('blogs', $blogs);

}

...

View resources/views/blogs/index.blade.php

<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="csrf-token" content="{{ csrf_token() }}" />
    <meta name="description" content="">
    <meta name="author" content="">

    <title> {{ config('app.name', 'Laravel') }}</title>
	<!-- Bootstrap Core CSS -->
	<link href="{{ asset('/assets/vendor/bootstrap/css/bootstrap.min.css') }}" rel="stylesheet">
	</head>
	<body>
		 <div class="container">
			<div class="row page-header">
				<div class="col-xs-12 col-md-6 col-lg-6">
					 <h1>Blogs</h1>
				 </div>
				 <div class="col-xs-12 col-md-6 col-lg-6">
						 <a href="{{ URL('/blogs/create') }}" class="btn btn-default pull-right"><i class="fa fa-plus"></i> Create Blog</a>
				 </div>
			</div>
			 <!-- /.row -->
			 
			 <!-- will be used to show any messages -->
			@if (Session::has('message'))
				<div class="alert alert-success">{{ Session::get('message') }}</div>
			@endif
			<div class="table-responsive">
			<table class="table table-striped table-bordered">
				<thead>
					<tr>
						<td>Title</td>
						<td>Content</td>
						<td>Created time</td>
						<td>Actions</td>
					</tr>
				</thead>
				<tbody>
				@foreach($blogs as $key => $value)
					<tr>
						<td>{{ $value->title }}</td>
						<td>{{ $value->content }}</td>
						<td>{{ $value->created_at }}</td>
			
						<!-- we will also add show, edit, and delete buttons -->
						<td>
			
							<!-- delete the nerd (uses the destroy method DESTROY /blogs/{id} -->
							<!-- we will add this later since its a little more complicated than the other two buttons -->
							<form class="form-horizontal" method="POST" action="{{ URL('blogs/'.$value->id) }}">
							{{ csrf_field() }}
							{{ method_field('DELETE') }}
							
							<!-- show the nerd (uses the show method found at GET /users/{id} -->
							<a class="btn btn-xs btn-success" href="{{ URL::to('blogs/' . $value->id) }}">Show</a>
			
							<!-- edit this nerd (uses the edit method found at GET /users/{id}/edit -->
							<a class="btn btn-xs btn-info" href="{{ URL::to('blogs/' . $value->id . '/edit') }}">Edit</a>
							
							<button type="submit" class="btn btn-xs btn-danger">Delete</button>
							</form>
			
			
						</td>
					</tr>
				@endforeach
				</tbody>
			</table>
			</div>
	</div>
</body>
</html>

<!DOCTYPE html>

<head>

<title> {{ config('app.name', 'Laravel') }}</title>

</head>

<body>

<h1>Blogs</h1>

</div>

<a href="{{ URL('/blogs/create') }}" class="btn btn-default pull-right"><i class="fa fa-plus"></i> Create Blog</a>

</div>

@if (Session::has('message'))

<div class="alert alert-success">{{ Session::get('message') }}</div>

@endif

<thead>

<tr>

<td>Title</td>

<td>Content</td>

<td>Created time</td>

<td>Actions</td>

</tr>

</thead>

<tbody>

@foreach($blogs as $key => $value)

<tr>

<td>{{ $value->title }}</td>

<td>{{ $value->content }}</td>

<td>{{ $value->created_at }}</td>

<td>

<button type="submit" class="btn btn-xs btn-danger">Delete</button>

</form>

</td>

</tr>

@endforeach

</tbody>

</table>

</div>

</body>

</html>

หน้าสร้างเรคคอร์ด

Description	URL	Controller Function	View File
Show the form to create a blogs.	GET example.com/blogs/create	create()	resources/views/blogs/create.blade.php

Controller Function create() app\Http\Controllers\BlogController.php

<?php
...
 /**
 * Show the form for creating a new resource.
 *
 * @return \Illuminate\Http\Response
 */
 public function create()
 {
 // load the create form (resources\views\blogs)
 return View('blogs.create');
 }
...

<?php

...

/**

* Show the form for creating a new resource.

* @return \Illuminate\Http\Response

public function create()

{

// load the create form (resources\views\blogs)

return View('blogs.create');

}

...

View resources/views/blogs/create.blade.php

<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="csrf-token" content="{{ csrf_token() }}" />
    <meta name="description" content="">
    <meta name="author" content="">

    <title> {{ config('app.name', 'Laravel') }}</title>
	<!-- Bootstrap Core CSS -->
	<link href="{{ asset('/assets/vendor/bootstrap/css/bootstrap.min.css') }}" rel="stylesheet">
	</head>
	<body>
		 <div class="container">
 <div class="row page-header">
	 <div class="col-xs-12 col-md-6 col-lg-6">
		 <h1>Create Blog</h1>
	 </div>
	 <div class="col-xs-12 col-md-6 col-lg-6">
		 <div class="btn-group pull-right" role="group" aria-label="..." >
			  <a href="{{ URL('/blogs') }}" class="btn btn-default "> Back</a>
		 </div>
	 </div>
</div>
 <!-- /.row -->

    <div class="row">
        <div class="col-md-8">
				
                    <form class="form-horizontal" method="POST" action="{{ URL('/blogs') }}">
					<!-- if there are creation errors, they will show here -->
					@if($errors->all())
					<ul class="has-error">
					@foreach ($errors->all() as $message)
						<li>{{ $message }}</li>
					@endforeach
					</ul>
					@endif
					
                        {{ csrf_field() }}
						
                        <div class="form-group{{ $errors->has('title') ? ' has-error' : '' }}">
                            <label for="title" class="col-md-4 control-label">Title *</label>

                            <div class="col-md-6">
                                <input id="title" type="text" class="form-control" name="title" value="{{ old('title') }}" required autofocus>

                                @if ($errors->has('title'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('title') }}</strong>
                                    </span>
                                @endif
                            </div>
                        </div>

                        <div class="form-group{{ $errors->has('content') ? ' has-error' : '' }}">
                            <label for="content" class="col-md-4 control-label">Content *</label>

                            <div class="col-md-6">
                                <textarea name="content" id="content" class="form-control" ></textarea>

                                @if ($errors->has('content'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('content') }}</strong>
                                    </span>
                                @endif
                            </div>
                        </div>

                        <div class="form-group">
                            <div class="col-md-6 col-md-offset-4">
                                <button type="submit" class="btn btn-primary">
                                    Create
                                </button>
                            </div>
                        </div>
                    </form>
			
        </div>
    </div>
</div>
</body>
</html>

<!DOCTYPE html>

<head>

<title> {{ config('app.name', 'Laravel') }}</title>

</head>

<body>

<h1>Create Blog</h1>

</div>

</div>

@if($errors->all())

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

<li>{{ $message }}</li>

@endforeach

</ul>

@endif

<div class="form-group{{ $errors->has('title') ? ' has-error' : '' }}">

<label for="title" class="col-md-4 control-label">Title *</label>

@if ($errors->has('title'))

<strong>{{ $errors->first('title') }}</strong>

</span>

@endif

</div>

<div class="form-group{{ $errors->has('content') ? ' has-error' : '' }}">

<label for="content" class="col-md-4 control-label">Content *</label>

@if ($errors->has('content'))

<strong>{{ $errors->first('content') }}</strong>

</span>

@endif

</div>

Create

</button>

</div>

</form>

</div>

</body>

</html>

ฟังค์ชันด้านบนสำหรับแสดงฟอร์มเพื่อกรอกข้อมูล เมื่อทำการคลิก Submit Form ระบบจะไปทำงานต่อที่ method store()

ตรวจสอบและสร้างข้อมูล

Description	URL	Controller Function	View File
Process the create form submit and save the blog to the database.	POST example.com/blog	store()	NONE

Controller Function store() app\Http\Controllers\BlogController.php

<?php
...
    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        // Validate read more on validation at https://laravel.com/docs/5.4/validation
		$this->validate($request, [
				'title' => 'required|string|max:150',
				'content' => 'required|string',
		]);
		
		// store
		$blog = new Blog;
		$blog->title = $request->input('title');
		$blog->content = $request->input('content');
		$blog->save();

		// redirect
		return redirect('blogs')->with('message', 'Successfully created blog!');
    }
...

<?php

...

/**

* Store a newly created resource in storage.

* @param \Illuminate\Http\Request $request

* @return \Illuminate\Http\Response

public function store(Request $request)

{

// Validate read more on validation at https://laravel.com/docs/5.4/validation

$this->validate($request, [

'title' => 'required|string|max:150',

'content' => 'required|string',

]);

// store

$blog = new Blog;

$blog->title = $request->input('title');

$blog->content = $request->input('content');

$blog->save();

// redirect

return redirect('blogs')->with('message', 'Successfully created blog!');

}

...

หน้าแสดงข้อมูลเรคคอร์ด

Description	URL	Controller Function	View File
Show one of the nerds.	GET example.com/nerds/{id}	show()	app/views/nerds/show.blade.php

Controller Function show() app\Http\Controllers\BlogController.php

<?php
...
    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        // get the blog
        $blog = Blog::findOrFail($id);

        // show the view and pass the blog to it
        return View('blogs.show')
            ->with('blog', $blog);
    }
...

<?php

...

/**

* Display the specified resource.

* @param int $id

* @return \Illuminate\Http\Response

public function show($id)

{

// get the blog

$blog = Blog::findOrFail($id);

// show the view and pass the blog to it

return View('blogs.show')

->with('blog', $blog);

}

...

View resources/views/blogs/show.blade.php

<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="csrf-token" content="{{ csrf_token() }}" />
    <meta name="description" content="">
    <meta name="author" content="">

    <title> {{ config('app.name', 'Laravel') }}</title>
	<!-- Bootstrap Core CSS -->
	<link href="{{ asset('/assets/vendor/bootstrap/css/bootstrap.min.css') }}" rel="stylesheet">
	</head>
	<body>
		 <div class="container">
  <div class="row page-header">
	 <div class="col-xs-12 col-md-8 col-lg-8">
		 <h1>Show Record : {{ $blog->title }}</h1>
	 </div>
	 <div class="col-xs-12 col-md-4 col-lg-4">
		 <div class="btn-group pull-right" role="group" aria-label="..." >
			  <a href="{{ url()->previous() }}" class="btn btn-default "> Back</a>
		 </div>
	 </div>
</div>
 <!-- /.row -->

 
 <div class="row">
 	<label  class="col-sm-2">Title</label>
	<div class="col-sm-10">{{ $blog->title }}</div>
</div>
 <div class="row">
 	<label  class="col-sm-2">Content</label>
	<div class="col-sm-10">{{ $blog->content }}</div>
</div>
 <!-- /.row -->
</div>
</body>
</html>

<!DOCTYPE html>

<head>

<title> {{ config('app.name', 'Laravel') }}</title>

</head>

<body>

<h1>Show Record : {{ $blog->title }}</h1>

</div>

<a href="{{ url()->previous() }}" class="btn btn-default "> Back</a>

</div>

<label class="col-sm-2">Title</label>

<div class="col-sm-10">{{ $blog->title }}</div>

</div>

<label class="col-sm-2">Content</label>

<div class="col-sm-10">{{ $blog->content }}</div>

</div>

</div>

</body>

</html>

หน้าฟอร์มแก้ไขข้อมูล

Description	URL	Controller Function	View File
Pull blog from the database and allow editing.	GET example.com/blogs/{id}/edit	edit()	resources/views/blogs/edit.blade.php

Controller Function edit() app\Http\Controllers\BlogController.php

<?php
...
    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        // get the blog
        $blog = Blog::findOrFail($id);

        // show the edit form and pass the blog
        return View('blogs.edit')
            ->with('blog', $blog);
    }
...

<?php

...

/**

* Show the form for editing the specified resource.

* @param int $id

* @return \Illuminate\Http\Response

public function edit($id)

{

// get the blog

$blog = Blog::findOrFail($id);

// show the edit form and pass the blog

return View('blogs.edit')

->with('blog', $blog);

}

...

View resources/views/blogs/edit.blade.php

<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="csrf-token" content="{{ csrf_token() }}" />
    <meta name="description" content="">
    <meta name="author" content="">

    <title> {{ config('app.name', 'Laravel') }}</title>
	<!-- Bootstrap Core CSS -->
	<link href="{{ asset('/assets/vendor/bootstrap/css/bootstrap.min.css') }}" rel="stylesheet">
	</head>
	<body>
		 <div class="container">
 <div class="row page-header">
	 <div class="col-xs-12 col-md-6 col-lg-6">
		 <h1>Edit Blog : {{ $blog->title }}</h1>
	 </div>
	 <div class="col-xs-12 col-md-6 col-lg-6">
		 <div class="btn-group pull-right" role="group" aria-label="..." >
			  <a href="{{ URL('/blogs') }}" class="btn btn-default "> Back</a>
		 </div>
	 </div>
</div>
 <!-- /.row -->

    <div class="row">
        <div class="col-md-8">
				
                    <form class="form-horizontal" method="POST" action="{{ route('blogs.update', $blog->id) }}">
					<!-- if there are creation errors, they will show here -->
					@if($errors->all())
					<ul class="has-error">
					@foreach ($errors->all() as $message)
						<li>{{ $message }}</li>
					@endforeach
					</ul>
					@endif
					
                        {{ csrf_field() }}
			{{ method_field('PUT') }}
												
                        <div class="form-group{{ $errors->has('title') ? ' has-error' : '' }}">
                            <label for="title" class="col-md-4 control-label">Title *</label>

                            <div class="col-md-6">
                                <input id="title" type="text" class="form-control" name="title" value="{{ $blog->title }}" required autofocus>

                                @if ($errors->has('title'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('title') }}</strong>
                                    </span>
                                @endif
                            </div>
                        </div>

                        <div class="form-group{{ $errors->has('content') ? ' has-error' : '' }}">
                            <label for="content" class="col-md-4 control-label">Content *</label>

                            <div class="col-md-6">
                                <textarea name="content" id="content" class="form-control" >{{ $blog->content }}</textarea>

                                @if ($errors->has('content'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('content') }}</strong>
                                    </span>
                                @endif
                            </div>
                        </div>

                        <div class="form-group">
                            <div class="col-md-6 col-md-offset-4">
                                <button type="submit" class="btn btn-primary">
                                    Update
                                </button>
                            </div>
                        </div>
                    </form>
			
        </div>
    </div>
</div>
</body>
</html>

<!DOCTYPE html>

<head>

<title> {{ config('app.name', 'Laravel') }}</title>

</head>

<body>

<h1>Edit Blog : {{ $blog->title }}</h1>

</div>

</div>

@if($errors->all())

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

<li>{{ $message }}</li>

@endforeach

</ul>

@endif

<div class="form-group{{ $errors->has('title') ? ' has-error' : '' }}">

<label for="title" class="col-md-4 control-label">Title *</label>

<input id="title" type="text" class="form-control" name="title" value="{{ $blog->title }}" required autofocus>

@if ($errors->has('title'))

<strong>{{ $errors->first('title') }}</strong>

</span>

@endif

</div>

<div class="form-group{{ $errors->has('content') ? ' has-error' : '' }}">

<label for="content" class="col-md-4 control-label">Content *</label>

<textarea name="content" id="content" class="form-control" >{{ $blog->content }}</textarea>

@if ($errors->has('content'))

<strong>{{ $errors->first('content') }}</strong>

</span>

@endif

</div>

Update

</button>

</div>

</form>

</div>

</body>

</html>

หลังจากกดปุ่มอัพเดทแล้วระบบจะไปทำงานต่อที่ method update()

ตรวจสอบและอัพเดทข้อมูล

Description	URL	Controller Function	View File
Process the create form submit and save the nerd to the database.	PUT example.com/blogs	update()	NONE

Controller Function update() app\Http\Controllers\BlogController.php

<?php
...
    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        // Validate read more on validation at https://laravel.com/docs/5.4/validation
		$this->validate($request, [
				'title' => 'required|string|max:150',
				'content' => 'required|string',
		]);
		
		// store
		$blog = Blog::findOrFail($id);
		$blog->title = $request->input('title');
		$blog->content = $request->input('content');
		$blog->save();

		// redirect
		return redirect('blogs')->with('message', 'Successfully updated blog!');
    }
...

<?php

...

/**

* Update the specified resource in storage.

* @param \Illuminate\Http\Request $request

* @param int $id

* @return \Illuminate\Http\Response

public function update(Request $request, $id)

{

// Validate read more on validation at https://laravel.com/docs/5.4/validation

$this->validate($request, [

'title' => 'required|string|max:150',

'content' => 'required|string',

]);

// store

$blog = Blog::findOrFail($id);

$blog->title = $request->input('title');

$blog->content = $request->input('content');

$blog->save();

// redirect

return redirect('blogs')->with('message', 'Successfully updated blog!');

}

...

การลบเรคคอร์ด

Description	URL	Controller Function	View File
Process the create form submit and save the blog to the database.	DELETE example.com/blogs/{id}	destroy()	NONE

Controller Function destroy() app\Http\Controllers\BlogController.php

<?php
...
    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        // delete
        $blog = Blog::findOrFail($id);
        $blog->delete();

		// redirect
		return redirect('blogs')->with('message', 'Successfully deleted the blog!');
    }
...

<?php

...

/**

* Remove the specified resource from storage.

* @param int $id

* @return \Illuminate\Http\Response

public function destroy($id)

{

// delete

$blog = Blog::findOrFail($id);

$blog->delete();

// redirect

return redirect('blogs')->with('message', 'Successfully deleted the blog!');

}

...

ในไฟล์

View resources/views/blogs/index.blade.php

ให้แทรกปุ่ม Delete ตามโค๊ดด้านล่าง

...
@foreach($blogs as $key => $value)
	<tr>
		<td>{{ $value->title }}</td>
		<td>{{ $value->content }}</td>
		<td>{{ $value->created_at }}</td>

		<!-- we will also add show, edit, and delete buttons -->
		<td>

			<!-- delete the nerd (uses the destroy method DESTROY /blogs/{id} -->
			<!-- we will add this later since its a little more complicated than the other two buttons -->
			<form class="form-horizontal" method="POST" action="{{ URL('blogs/'.$value->id) }}">
			{{ csrf_field() }}
			{{ method_field('DELETE') }}
			
			<!-- show the nerd (uses the show method found at GET /users/{id} -->
			<a class="btn btn-xs btn-success" href="{{ URL::to('blogs/' . $value->id) }}">Show</a>

			<!-- edit this nerd (uses the edit method found at GET /users/{id}/edit -->
			<a class="btn btn-xs btn-info" href="{{ URL::to('blogs/' . $value->id . '/edit') }}">Edit</a>
			
			<button type="submit" class="btn btn-xs btn-danger">Delete</button>
			</form>


		</td>
	</tr>
@endforeach
...

...

@foreach($blogs as $key => $value)

<tr>

<td>{{ $value->title }}</td>

<td>{{ $value->content }}</td>

<td>{{ $value->created_at }}</td>

<td>

<button type="submit" class="btn btn-xs btn-danger">Delete</button>

</form>

</td>

</tr>

@endforeach

...

อ้างอิง
https://scotch.io/tutorials/simple-laravel-crud-with-resource-controllers

https://laravel.com/docs/5.4/controllers#resource-controllers

ป้ายกำกับ:laravel

laravel 5.4 การ Creating, reading, updating, and deleting (CRUD) โดยใช้ Controllers

เตรียมฐานข้อมูลให้พร้อม

สร้าง Eloquent Model สำหรับ Blogs (ดูเพิ่มเติม)

สร้าง Controllers

กำหนดค่า Routes

Actions Handled By the Controller

View

หน้าแสดงทุกเรคคอร์ด

Controller Function index() app\Http\Controllers\BlogController.php

View resources/views/blogs/index.blade.php

หน้าสร้างเรคคอร์ด

Controller Function create() app\Http\Controllers\BlogController.php

View resources/views/blogs/create.blade.php

ตรวจสอบและสร้างข้อมูล

Controller Function store() app\Http\Controllers\BlogController.php

หน้าแสดงข้อมูลเรคคอร์ด

Controller Function show() app\Http\Controllers\BlogController.php

View resources/views/blogs/show.blade.php

หน้าฟอร์มแก้ไขข้อมูล

Controller Function edit() app\Http\Controllers\BlogController.php

View resources/views/blogs/edit.blade.php

ตรวจสอบและอัพเดทข้อมูล

Controller Function update() app\Http\Controllers\BlogController.php

การลบเรคคอร์ด

Controller Function destroy() app\Http\Controllers\BlogController.php

View resources/views/blogs/index.blade.php

หมวดหมู่

ติดต่อเรา

ติดตามเรา

laravel 5.4 การ Creating, reading, updating, and deleting (CRUD) โดยใช้ Controllers

เตรียมฐานข้อมูลให้พร้อม

สร้าง Eloquent Model สำหรับ Blogs (ดูเพิ่มเติม)

สร้าง Controllers

กำหนดค่า Routes

Actions Handled By the Controller

View

หน้าแสดงทุกเรคคอร์ด

Controller Function index() app\Http\Controllers\BlogController.php

View resources/views/blogs/index.blade.php

หน้าสร้างเรคคอร์ด

Controller Function create() app\Http\Controllers\BlogController.php

View resources/views/blogs/create.blade.php

ตรวจสอบและสร้างข้อมูล

Controller Function store() app\Http\Controllers\BlogController.php

หน้าแสดงข้อมูลเรคคอร์ด

Controller Function show() app\Http\Controllers\BlogController.php

View resources/views/blogs/show.blade.php

หน้าฟอร์มแก้ไขข้อมูล

Controller Function edit() app\Http\Controllers\BlogController.php

View resources/views/blogs/edit.blade.php

ตรวจสอบและอัพเดทข้อมูล

Controller Function update() app\Http\Controllers\BlogController.php

การลบเรคคอร์ด

Controller Function destroy() app\Http\Controllers\BlogController.php

View resources/views/blogs/index.blade.php

หมวดหมู่

Popular Posts

ป้ายกำกับ

ติดต่อเรา

ติดตามเรา