1.3 Crud tutorial

composer create-project laravel/laravel student-crud
cd student-crud

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=student_crud
DB_USERNAME=root
DB_PASSWORD=

CREATE DATABASE student_crud;

php artisan make:model Student -m

<?php

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

return new class extends Migration
{
    public function up()
    {
        Schema::create('students', function (Blueprint $table) {
            $table->id(); // অটো-ইনক্রিমেন্ট প্রাইমারি কি
            $table->string('name'); // স্টুডেন্ট নাম
            $table->string('email')->unique(); // ইউনিক ইমেইল
            $table->string('phone'); // ফোন নাম্বার
            $table->string('course'); // কোর্স নাম
            $table->string('image')->nullable(); // ইমেজ পাথ (নাল হতে পারে)
            $table->timestamps(); // created_at ও updated_at টাইমস্ট্যাম্প
        });
    }

    public function down()
    {
        Schema::dropIfExists('students');
    }
};

php artisan migrate

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Student extends Model
{
    use HasFactory;

    protected $fillable = [
        'name',
        'email',
        'phone',
        'course',
        'image'
    ];
}

php artisan make:controller StudentController --resource

<?php

namespace App\Http\Controllers;

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

class StudentController extends Controller
{
    // সব স্টুডেন্ট দেখাবে
    public function index()
    {
        $students = Student::all(); // সব স্টুডেন্ট নেয়া
        return view('students.index', compact('students')); // ভিউতে ডাটা পাস করা
    }

    // নতুন স্টুডেন্ট ফর্ম দেখাবে
    public function create()
    {
        return view('students.create'); // ক্রিয়েট ফর্ম ভিউ
    }

    // নতুন স্টুডেন্ট স্টোর করবে
    public function store(Request $request)
    {
        // ভ্যালিডেশন
        $request->validate([
            'name' => 'required',
            'email' => 'required|email|unique:students',
            'phone' => 'required',
            'course' => 'required',
            'image' => 'required|image|mimes:jpeg,png,jpg,gif|max:2048',
        ]);

        // ইমেজ আপলোড
        $imageName = time().'.'.$request->image->extension();  
        $request->image->move(public_path('images'), $imageName);

        // ডাটাবেসে সেভ
        Student::create([
            'name' => $request->name,
            'email' => $request->email,
            'phone' => $request->phone,
            'course' => $request->course,
            'image' => $imageName,
        ]);

        return redirect()->route('students.index')->with('success', 'Student created successfully.');
    }

    // একটি স্টুডেন্ট দেখাবে
    public function show(Student $student)
    {
        return view('students.show', compact('student'));
    }

    // স্টুডেন্ট এডিট ফর্ম দেখাবে
    public function edit(Student $student)
    {
        return view('students.edit', compact('student'));
    }

    // স্টুডেন্ট আপডেট করবে
    public function update(Request $request, Student $student)
    {
        $request->validate([
            'name' => 'required',
            'email' => 'required|email|unique:students,email,'.$student->id,
            'phone' => 'required',
            'course' => 'required',
            'image' => 'nullable|image|mimes:jpeg,png,jpg,gif|max:2048',
        ]);

        // নতুন ইমেজ আপলোড হলে
        if($request->hasFile('image')){
            // পুরাতন ইমেজ ডিলিট
            if($student->image && file_exists(public_path('images/'.$student->image))){
                unlink(public_path('images/'.$student->image));
            }

            // নতুন ইমেজ সেভ
            $imageName = time().'.'.$request->image->extension();  
            $request->image->move(public_path('images'), $imageName);
            $student->image = $imageName;
        }

        // ডাটা আপডেট
        $student->name = $request->name;
        $student->email = $request->email;
        $student->phone = $request->phone;
        $student->course = $request->course;
        $student->save();

        return redirect()->route('students.index')->with('success', 'Student updated successfully.');
    }

    // স্টুডেন্ট ডিলিট করবে
    public function destroy(Student $student)
    {
        // ইমেজ ডিলিট
        if($student->image && file_exists(public_path('images/'.$student->image))){
            unlink(public_path('images/'.$student->image));
        }

        // ডাটাবেস থেকে ডিলিট
        $student->delete();
        return redirect()->route('students.index')->with('success', 'Student deleted successfully.');
    }
}

<?php

use Illuminate\Support\Facades\Route;
use App\Http\Controllers\StudentController;

// রিসোর্স রাউট সব CRUD রাউট একসাথে তৈরি করে
Route::resource('students', StudentController::class);

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Student CRUD</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
    <div class="container">
        @yield('content')
    </div>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>

@extends('layouts.app')

@section('content')
<div class="container mt-5">
    <h2 class="mb-4">Students List</h2>
    <a href="{{ route('students.create') }}" class="btn btn-success mb-3">Add New Student</a>

    @if(session('success'))
        <div class="alert alert-success">
            {{ session('success') }}
        </div>
    @endif

    <table class="table table-bordered">
        <thead>
            <tr>
                <th>ID</th>
                <th>Image</th>
                <th>Name</th>
                <th>Email</th>
                <th>Phone</th>
                <th>Course</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach($students as $student)
            <tr>
                <td>{{ $student->id }}</td>
                <td>
                    @if($student->image)
                        <img src="{{ asset('images/'.$student->image) }}" width="50" height="50" class="rounded-circle">
                    @else
                        No Image
                    @endif
                </td>
                <td>{{ $student->name }}</td>
                <td>{{ $student->email }}</td>
                <td>{{ $student->phone }}</td>
                <td>{{ $student->course }}</td>
                <td>
                    <a href="{{ route('students.show', $student->id) }}" class="btn btn-info btn-sm">View</a>
                    <a href="{{ route('students.edit', $student->id) }}" class="btn btn-primary btn-sm">Edit</a>
                    <form action="{{ route('students.destroy', $student->id) }}" method="POST" class="d-inline">
                        @csrf
                        @method('DELETE')
                        <button type="submit" class="btn btn-danger btn-sm">Delete</button>
                    </form>
                </td>
            </tr>
            @endforeach
        </tbody>
    </table>
</div>
@endsection

@extends('layouts.app')

@section('content')
<div class="container mt-5">
    <h2>Create New Student</h2>

    <form method="POST" action="{{ route('students.store') }}" enctype="multipart/form-data">
        @csrf

        <div class="mb-3">
            <label for="name" class="form-label">Name</label>
            <input type="text" class="form-control" id="name" name="name" required>
        </div>

        <div class="mb-3">
            <label for="email" class="form-label">Email</label>
            <input type="email" class="form-control" id="email" name="email" required>
        </div>

        <div class="mb-3">
            <label for="phone" class="form-label">Phone</label>
            <input type="text" class="form-control" id="phone" name="phone" required>
        </div>

        <div class="mb-3">
            <label for="course" class="form-label">Course</label>
            <input type="text" class="form-control" id="course" name="course" required>
        </div>

        <div class="mb-3">
            <label for="image" class="form-label">Image</label>
            <input type="file" class="form-control" id="image" name="image" required>
        </div>

        <button type="submit" class="btn btn-primary">Submit</button>
        <a href="{{ route('students.index') }}" class="btn btn-secondary">Cancel</a>
    </form>
</div>
@endsection

mkdir public/images
chmod -R 755 public/images

$imageName = time().'.'.$request->image->extension();  
$request->image->move(public_path('images'), $imageName);

php artisan serve