Laravel：借助关联表展示当前用户相关信息

Hey there! Let's walk through how to build this user-subject relationship in Laravel and display the current user's related info properly.

Looking at your tables, users (students/professors) and subjects have a many-to-many relationship—a student can enroll in multiple subjects, and a professor can teach multiple subjects. To make this work, we need an intermediate pivot table (let's call it user_subject). Its basic structure should include:

• id (primary key)
• user_id (foreign key referencing users.id)
• subject_id (foreign key referencing subjects.id)

If you need extra context (like enrollment date or class status), you can add additional columns here later.

Run this Artisan command to generate the migration file:

php artisan make:migration create_user_subject_table

Then open the generated file and update the up() method with the pivot table schema:

public function up()
{
    Schema::create('user_subject', function (Blueprint $table) {
        $table->id();
        $table->foreignId('user_id')->constrained()->onDelete('cascade');
        $table->foreignId('subject_id')->constrained()->onDelete('cascade');
        // Optional: add timestamps if needed
        $table->timestamps();
    });
}

Run the migration to create the table:

php artisan migrate

Update your User and Subject models to define the many-to-many associations.

In app/Models/User.php: #

namespace App\Models;

use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Database\Eloquent\Relations\BelongsToMany;

class User extends Authenticatable
{
    // ... existing code

    // Get all subjects related to the user (works for both students and professors)
    public function subjects(): BelongsToMany
    {
        return $this->belongsToMany(Subject::class, 'user_subject');
    }

    // Optional: Separate methods for role-specific subjects
    public function enrolledSubjects(): BelongsToMany
    {
        return $this->subjects()->where('users.role', 'student');
    }

    public function taughtSubjects(): BelongsToMany
    {
        return $this->subjects()->where('users.role', 'professor');
    }
}

In app/Models/Subject.php: #

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsToMany;

class Subject extends Model
{
    // ... existing code

    public function users(): BelongsToMany
    {
        return $this->belongsToMany(User::class, 'user_subject');
    }
}

Once the relationships are set up, you can easily get the current user's subjects in your controller or view.

Example in a Controller: #

namespace App\Http\Controllers;

use Illuminate\Support\Facades\Auth;

class UserController extends Controller
{
    public function showSubjects()
    {
        $user = Auth::user();
        // Get all related subjects
        $subjects = $user->subjects;

        // Or use role-specific methods if needed
        // if ($user->role === 'student') {
        //     $subjects = $user->enrolledSubjects;
        // } elseif ($user->role === 'professor') {
        //     $subjects = $user->taughtSubjects;
        // }

        return view('user.subjects', compact('user', 'subjects'));
    }
}

Example in a Blade View (resources/views/user/subjects.blade.php): #

<div class="user-info">
    <h2>Welcome, {{ $user->name }}!</h2>
    <p>Your Role: {{ ucfirst($user->role) }}</p>

    <h3>Your Subjects:</h3>
    @if($subjects->isEmpty())
        <p>No subjects assigned yet.</p>
    @else
        <ul>
            @foreach($subjects as $subject)
                <li>{{ $subject->name }}</li>
            @endforeach
        </ul>
    @endif
</div>

• Make sure your users and subjects tables are already set up with the columns you provided (id, name, role for users; id, name for subjects).
• If you need to attach subjects to a user (e.g., during enrollment), you can use:

  // Attach a single subject
  $user->subjects()->attach($subjectId);
  
  // Attach multiple subjects
  $user->subjects()->attach([$subjectId1, $subjectId2]);
  

That's it! This setup will let you seamlessly fetch and display the current user's related subject information in Laravel.

内容的提问来源于stack exchange，提问作者Julles