এক্সিস্টিং ল্যারাভেল প্রজেক্টে নতুন টেবিল যোগ করা

php artisan make:model Category -m

    public function up()
    {
        Schema::create('categories', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->timestamps();
        });
    }

<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
class Category extends Model
{
    protected $fillable = ['name'];

    public function products()
    {
        return $this->hasMany(Product::class);
    }
}

<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Product extends Model
{
    use HasFactory;
    protected $fillable = ['title', 'price', 'image', 'category_id'];

    public function category()
    {
        return $this->belongsTo(Category::class);
    }
}

php artisan make:migration add_category_id_to_products_table --table=products

    public function up(): void
    {
        Schema::table('products', function (Blueprint $table) {
            $table->unsignedBigInteger('category_id')->nullable();
            // Add a foreign key constraint
            $table->foreign('category_id')->references('id')->on('categories')->onDelete('cascade');
        });
    }

php artisan migrate

php artisan make:controller CategoryController --resource

Route::resource('category', CategoryController::class);

<x-layout>
    <div class="text-left mr-auto w-full">

        <h2 class="text-2xl font-bold">Add Category</h2>
        <form action="{{ route('category.store') }}" method="POST" class="space-y-4">
            @csrf
            <div class="form-group">
                <label for="name">Category Name</label>
                <input type="text"
                    class="bg-gray-50 border border-gray-300 text-gray-900 text-sm rounded-lg focus:ring-blue-500 focus:border-blue-500 block w-full p-2.5"
                id="name" name="name" value="{{ old('name') }}" required>
            </div>
            <button type="submit" class="inline-flex items-center px-5 py-2.5 text-sm font-medium text-center text-white bg-blue-700 rounded-lg focus:ring-4 focus:ring-blue-200 hover:bg-blue-800">

            Add Category</button>
        </form>

    </div>
</x-layout>

 return view('category.create');

    public function store(Request $request)
    {
        $request->validate([
            'name' => 'required|string|max:255'
        ]);

        Category::create([
            'name' => $request->name
        ]);

        return redirect()->route('category.index')->with('success', 'Category added successfully.');
    }

<x-layout>
    <div class="space-y-5">
<h2 class="mb-2 text-lg font-semibold text-gray-900 dark:text-white">Categories</h2>

@forelse($categories as $category)
    <div class="flex  max-w-sm flex-row  items-start justify-center">
        <div class="basis-1/2"> <h2 class="text-xl font-bold">{{ $category->name }}</h2></div>
        <div class="basis-1/4">
            <a class="text-white bg-blue-700 hover:bg-blue-800 focus:ring-4 focus:ring-blue-300 font-medium rounded-lg text-sm px-5 py-2.5  "
            href="{{ route('category.edit', $category->id) }}"
                class="btn btn-primary">Edit</a></div>
        <div class="basis-1/4">

            <form action="{{ route('category.destroy', $category->id) }}" method="POST"
                style="display:inline-block;">
                @csrf
                @method('DELETE')
                <button type="submit" class="focus:outline-none text-white bg-red-700 hover:bg-red-800 focus:ring-4 focus:ring-red-300 font-medium rounded-lg text-sm px-5 py-2.5 ">Delete</button>
            </form>
        </div>
    </div>
@empty
    <p>No categories available.</p>
@endforelse
    </div>
</x-layout>

           <div class="form-group">
                    <label for="category_id">Category</label>
                    <select name="category_id" class="bg-gray-50 border border-gray-300 text-gray-900 text-sm rounded-lg focus:ring-blue-500 focus:border-blue-500 block w-full p-2.5" required>
                        <option value="" disabled selected>Select a Category</option>
                        @foreach ($categories as $category)
                            <option value="{{ $category->id }}" {{ old('category_id') == $category->id ? 'selected' : '' }}>
                                {{ $category->name }}
                            </option>
                        @endforeach
                    </select>
                </div>

Undefined variable $categories

   public function create()
    {
       $categories = Category::all();

       return view('create', compact('categories'));
    }

    public function store(Request $request)
    {
        $data = $request->validate([
            'title' => ['required', 'string'],
            'price' => ['required', 'numeric'],
            'image' => 'nullable|image|mimes:jpeg,png,jpg,gif|max:2048',
            'category_id' => 'required|exists:categories,id', // new feild for adding category
        ]);
             // Handle the image upload if there is an image
             $imagePath = null;
             if ($request->hasFile('image')) {
                 $imagePath = $request->file('image')->store('images/products', 'public'); // Store the image in the public disk
             }

        $product =  Product::create([
            'title' => $request->input('title'),
            'price' => $request->input('price'),
            'image' => $imagePath,
            'category_id' => $data['category_id'], // creating product with category
        ]);

        return to_route('product.show', $product);
    }

 <h4>Category:</h4>
  <p>{{ $product->category ? $product->category->name : 'No Category' }}</p>

 <p>Category: {{ $product->category ? $product->category->name : 'No Category' }}</p>

php artisan make:seeder DefaultCategorySeeder

<?php

namespace Database\Seeders;

use Illuminate\Database\Console\Seeds\WithoutModelEvents;
use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;

class DefaultCategorySeeder extends Seeder
{
    /**
     * Run the database seeds.
     */
    public function run(): void
    {
        DB::table('categories')->insert([
            'name' => 'Default Category',
            'created_at' => now(),
            'updated_at' => now(),
        ]);
    }
}

php artisan db:seed --class=CategorySeeder

public function run()
{
    // Call the DefaultCategorySeeder
    $this->call(DefaultCategorySeeder::class);
}

git checkout category