// การเปลี่ยนสิทธิ์การเข้าใช้ระบบของผู้ใช้งานรหัส ID
DB::table('users')
    ->where('id', $id)
    ->update(['status' => 'inactive']);

// routes/web.php
Route::get('/change/{id}', [AdminController::class, 'change'])->name('change');

// app/Http/Controllers/AdminController.php
function change($id)
{
    dd($id);
}

<!-- resources/views/blog.blade.php -->
@if($item->status)
    <a href="{{route('change', $item->id)}}" class="btn btn-outline-success">เผยแพร่</a>
@else
    <a href="{{route('change', $item->id)}}" class="btn btn-outline-danger">ฉบับร่าง</a>
@endif

// app/Http/Controllers/AdminController.php
function change($id)
{
    dd(DB::table("blogs")->where('id', $id)->first());
}

// app/Http/Controllers/AdminController.php
function change($id)
{
    $blog = DB::table("blogs")->where('id', $id)->first();
    dd($blog);
}

// app/Http/Controllers/AdminController.php
$blog = DB::table("blogs")->where('id', $id)->first();
$data = [
    'status' => !$blog->status
];

// app/Http/Controllers/AdminController.php
DB::table("blogs")->where('id', $id)->update($data);
return redirect('/blog');

<form action="/book/update/{{ $book->id }}" method="POST">
    @csrf
    @method('PUT') <!-- แทรกเมธอดสำหรับส่งคำขออัปเดตข้อมูล -->
    <div class="mb-3">
        <label>ชื่อหนังสือ</label>
        <input type="text" name="title" value="{{ $book->title }}" class="form-control">
    </div>
    <button type="submit" class="btn btn-warning">ปรับปรุงข้อมูล</button>
</form>

<!-- resources/views/blog.blade.php -->
<table class="table table-bordered text-center">
    <thead>
        <tr>
            <th scope="col">บทความ</th>
            <th scope="col">สถานะ</th>
            <th scope="col">แก้ไขบทความ</th>
            <th scope="col">ลบบทความ</th>
        </tr>
    </thead>
    ...
</table>

<!-- resources/views/blog.blade.php -->
@foreach ($blogs as $item)
<tr>
    <td>{{$item->title}}</td>
    ...
    <td><a href="#" class="btn btn-primary">แก้ไขบทความ</a></td>
    ...
</tr>
@endforeach

// routes/web.php
Route::get('/edit/{id}', [AdminController::class, 'edit'])->name('edit');

<!-- resources/views/blog.blade.php -->
<td>
    <a href="{{route('edit', $item->id)}}" class="btn btn-primary">แก้ไขบทความ</a>
</td>

// app/Http/Controllers/AdminController.php
function edit($id){
    $blog = DB::table("blogs")->where('id', $id)->first();
    dd($blog);
}

// app/Http/Controllers/AdminController.php
function edit($id){
    $blog = DB::table("blogs")->where('id', $id)->first();
    return view("edit", compact('blog'));
}

<!-- resources/views/edit.blade.php -->
<div class="form-group">
    <label for="title">ชื่อบทความ</label>
    <input type="text" name="title" class="form-control" value="{{$blog->title}}">
</div>

<!-- resources/views/edit.blade.php -->
<div class="form-group">
    <label for="content">เนื้อหา</label>
    <textarea name="content" cols="30" rows="5" class="form-control">{{$blog->content}}</textarea>
</div>

public function update(Request $request, $id)
{
    $request->validate(['title' => 'required']);
    DB::table('books')->where('id', $id)->update([
        'title' => $request->title,
        'updated_at' => now()
    ]);
    return redirect('/books')->with('success', 'บันทึกแก้ไขแล้ว');
}

// routes/web.php
Route::post('/update/{id}', [AdminController::class, 'update'])->name('update');

<!-- resources/views/edit.blade.php -->
<form method="POST" action="{{route('update', $blog->id)}}">
    @csrf
    ...
</form>

// app/Http/Controllers/AdminController.php
function update(Request $request, $id)
{
    $request->validate([
        'title' => 'required|max:50',
        'content' => 'required',
    ], [
        'title.required' => 'กรุณาใส่ชื่อบทความ',
        'title.max' => 'ชื่อบทความต้องไม่เกิน 50 ตัวอักษร',
        'content.required' => 'กรุณาใส่เนื้อหา',
    ]);
    $data = [
        'title' => $request->title,
        'content' => $request->content,
    ];
    DB::table("blogs")->where('id', $id)->update($data);
    return redirect('/blog');
}

// สลับสถานะการเผยแพร่
$blog = DB::table('blogs')->where('id', $id)->first();
DB::table('blogs')->where('id', $id)->update(['status' => !$blog->status]);

// บันทึกแก้ไขบทความ
DB::table('blogs')->where('id', $id)->update([
    'title' => $request->title,
    'content' => $request->content
]);