【Laravel】DBテーブルからデータを取得する方法を複数種類解説｜取得したデータをページに表示

php artisan make:model Product

php artisan make:controller ProductController

<?php

namespace App\Http\Controllers;

use App\Models\Product; // 追加
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Schema;

class ProductController extends Controller
{
    public function index()
    {
        // カラム名を取得
        $columns = Schema::getColumnListing('products');

        // ここに取得するデータを記述する
        $products = [];

        // compact()メソッドで$columnsと$productsデータをproductに渡す
        return view('product', compact('columns', 'products'));
    }
}

<div class="relative overflow-x-auto shadow-md sm:rounded-lg">
    <table class="w-full text-sm text-left rtl:text-right text-gray-500 dark:text-gray-400">
        <thead class="text-xs text-gray-700 uppercase bg-gray-50 dark:bg-gray-700 dark:text-gray-400">
            <tr>
                @foreach ($columns as $column)
                <th scope="col" class="px-6 py-2">{{ $column }}</th>
                @endforeach
            </tr>
        </thead>
        <tbody>
            @foreach ($products as $product)
            <tr class="odd:bg-white odd:dark:bg-gray-900 even:bg-gray-50 even:dark:bg-gray-800 border-b dark:border-gray-700">
                <td class="px-6 py-2">{{ $product->id }}</td>
                <td class="px-6 py-2">{{ $product->name }}</td>
                <td class="px-6 py-2">{{ $product->description }}</td>
                <td class="px-6 py-2">{{ $product->price }}</td>
                <td class="px-6 py-2">{{ $product->stock }}</td>
                <td class="px-6 py-2">{{ $product->created_at }}</td>
                <td class="px-6 py-2">{{ $product->updated_at }}</td>
            </tr>
            @endforeach
        </tbody>
    </table>
</div>

 $products = Product::all();

$products = Product::where('name', 'like', '%フィカス%')->get();

$products = Product::select('name', 'price')->get();

$products = Product::where('stock', '>', 10)->get();

$products = Product::where('price', '>=', 1000)
                   ->where('stock', '>=', 5)
                   ->get();

$products = Product::orderBy('price', 'desc')->get();

$products = Product::limit(5)->get();

$products = Product::find(1); 

$product = Product::where('price', '>', 1000)->first();

$products = Product::where('stock', '<', 5)
                   ->orWhere('price', '>', 3000)
                   ->get();