Laravel 入門 ④（ブラウザからデータベースにデータを格納する）

<x-app-layout>
    <x-slot name="header">
        <h2 class="font-semibold text-xl text-gray-800 leading-tight">
            {{ __('Dashboard') }}
        </h2>
    </x-slot>

    <div class="py-12">
        <div class="max-w-7xl mx-auto sm:px-6 lg:px-8">
            <div class="bg-white overflow-hidden shadow-sm sm:rounded-lg">
                <div class="p-6 bg-white border-b border-gray-200">
                    You're logged in!
                </div>
            </div>
        </div>
    </div>
</x-app-layout>

<x-app-layout>
    <x-slot name="header">
        <h2 class="font-semibold text-xl text-gray-800 leading-tight">
            {{ __('Dashboard') }}
        </h2>
    </x-slot>

    <div class="py-5">
        <div class="max-w-3xl mx-auto px-4">
            <form class="grid grid-cols-1 gap-3" method='POST' action="/store" enctype="multipart/form-data">
                @csrf
                <label class="block">
                    <span class="text-gray-700">新しいタスク</span>
                    <input name="title" type="text" class="mt-2 block w-full rounded-md border-gray-300 shadow-sm">
                </label>
                <button type='submit' class="w-20 bg-blue-600 hover:bg-blue-500 text-white rounded px-4 py-2">作成</button>
            </form>
        </div>
    </div>
</x-app-layout>

<?php

use Illuminate\Support\Facades\Route;
use App\Http\Controllers\TaskController; // 追記

/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/

Route::get('/', function () {
    return view('welcome');
});

Route::get('/dashboard', function () {
    return view('dashboard');
})->middleware(['auth'])->name('dashboard');

Route::post('/store', [TaskController::class, 'store'])->middleware(['auth'])->name('store'); // 追記

require __DIR__.'/auth.php';

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class TaskController extends Controller
{
    //
}

PS C:\Users\Public\ToDoApp> php artisan make:model Task --migration

   INFO  Model created successfully.  

   INFO  Created migration [2022_08_06_091030_create_tasks_table].  

PS C:\Users\Public\ToDoApp>

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('tasks', function (Blueprint $table) {
            $table->id();
            // 追記ここから
            $table->unsignedBigInteger('user_id'); // 'user_id' という名前のカラムを作成します
            $table->string('title'); // 'title' という名前のカラムを作成します
            $table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP')); // タスクが作成された日時をあらわすカラム
            $table->timestamp('updated_at')->default(DB::raw('CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP')); // タスクが更新された日時をあらわすカラム
            // 追記ここまで
            // $table->timestamps(); この行はコメントアウトまたは削除します
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('tasks');
    }
};

PS C:\Users\Public\ToDoApp> php artisan migrate

   INFO  Running migrations.  

  2022_08_06_091030_create_tasks_table .......................................... 46ms DONE
PS C:\Users\Public\ToDoApp>

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\Task; // 追記

class TaskController extends Controller
{
    // 追記ここから
    public function store(Request $request)
    {
        $data = $request->all(); // フォームで送信されたデータをすべてとってきます

        Task::insertGetId([
            'user_id' => \Auth::id(), // ログイン中のユーザーの ID を格納します
            'title' => $data['title'], // 入力された文字列を格納します
        ]);

        return redirect()->route('dashboard'); // 処理が終わったらダッシュボードにリダイレクトします
    } // 追記ここまで
}