Laravel 8 更新用户资料时忽略特定字段唯一性验证的专业指南

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\Hash;
use Illuminate\Support\Facades\Auth; // 确保引入 Auth Facade

use App\Models\User;
use App\Models\Button;
use App\Models\Link;

class UserController extends Controller
{
    // ... 其他方法 ...

    /**
     * 显示用户页面编辑表单。
     *
     * @param Request $request
     * @return \Illuminate\View\View
     */
    public function showPage(Request $request)
    {
        $userId = Auth::user()->id;

        $data['pages'] = User::where('id', $userId)
                             ->select('littlelink_name', 'littlelink_color', 'littlelink_fontcolor', 'littlelink_pixiv', 'littlelink_description')
                             ->get();

        return view('/studio/page', $data);
    }

    /**
     * 保存用户页面（名称、描述、图片）的编辑。
     *
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function editPage(Request $request)
    {
        // 获取当前认证用户的ID，用于排除唯一性验证
        $userId = Auth::user()->id;

        $request->validate([
            'image' => 'nullable|mimes:jpeg,jpg,png|max:100',
            // 关键修正：在 unique 规则中排除当前用户的ID
            'pageName' => 'nullable|alpha_dash|unique:users,littlelink_name,' . $userId,
            'pageColor' => 'nullable',
            'pageFontcolor' => 'nullable',
            'pageDescription' => 'nullable|regex:/^[\w.\- ]+$/i',
            'pagePixiv' => 'nullable|url',
        ]);

        // 从请求中获取数据
        $pageName = $request->pageName;
        $pageColor = $request->pageColor;
        $pageFontcolor = $request->pageFontcolor;
        $pageDescription = $request->pageDescription;
        $pagePixiv = $request->pagePixiv;

        // 更新用户记录
        User::where('id', $userId)->update([
            'littlelink_name' => $pageName,
            'littlelink_color' => $pageColor,
            'littlelink_fontcolor' => $pageFontcolor,
            'littlelink_pixiv' => $pagePixiv,
            'littlelink_description' => $pageDescription
        ]);

        // 处理图片上传
        if ($request->hasFile('image')) {
            $profilePhoto = $request->file('image');
            // 确保文件名唯一或与用户关联，这里使用新的 pageName 作为文件名
            $profilePhoto->move(public_path('/img'), $pageName . ".png");
        }

        return back()->with('message', 'Saved');
    }

    // ... 其他方法 ...
}