Laravel自定义主键：解决更新操作中“未知列'id'”错误

<?php

namespace App\Models;

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

class Page extends Model
{
    use HasFactory;

    // 声明自定义主键
    protected $primaryKey = 'pages_id';

    // 允许批量赋值的字段
    protected $fillable = [
        'is_default_home',
        'is_default_not_found',
        'title',
        'slug',
        'content',
    ];

    // 其他模型方法...
}

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'where clause' (SQL: select count(*) as aggregate from `pages` where `slug` = about and `id` <> 3)

<?php

namespace App\Http\Controllers;

use App\Models\Page;
use Illuminate\Http\Request;
use Illuminate\Validation\Rule; // 引入 Rule 类

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

    public function update(Request $request, $modelId) // 假设modelId是pages_id的值
    {
        // 定义验证规则
        $request->validate([
            'title' => 'required|string|max:255',
            'slug' => [
                'required',
                'string',
                'max:255',
                // 关键：使用 Rule::unique() 并指定排除列
                // 'pages' 是表名, 'slug' 是要验证唯一性的列
                // $modelId 是当前记录的主键值
                // 'pages_id' 是你的自定义主键列名
                Rule::unique('pages', 'slug')->ignore($modelId, 'pages_id'),
            ],
            'content' => 'nullable|string',
            'is_default_home' => 'boolean',
            'is_default_not_found' => 'boolean',
        ]);

        // 查找并更新记录
        $page = Page::find($modelId); // find() 方法会自动使用 $primaryKey 定义的列
        if (!$page) {
            // 处理未找到记录的情况
            abort(404);
        }

        $page->update([
            'title' => $request->title,
            'slug' => $request->slug,
            'content' => $request->content,
            'is_default_home' => $request->is_default_home,
            'is_default_not_found' => $request->is_default_not_found,
        ]);

        // ... 其他逻辑
        return redirect()->back()->with('success', '页面更新成功！');
    }
}

<?php

namespace App\Http\Livewire;

use Livewire\Component;
use App\Models\Page;
use Illuminate\Validation\Rule;

class PagesCrud extends Component
{
    public $modelId; // 存储当前编辑记录的pages_id
    public $title, $slug, $content, $isSetToDefaultHomePage, $isSetToDefaultNotFoundPage;

    // ... 其他属性和方法

    public function rules()
    {
        return [
            'title' => 'required|string|max:255',
            'slug' => [
                'required',
                'string',
                'max:255',
                Rule::unique('pages', 'slug')->ignore($this->modelId, 'pages_id'),
            ],
            'content' => 'nullable|string',
            'isSetToDefaultHomePage' => 'boolean',
            'isSetToDefaultNotFoundPage' => 'boolean',
        ];
    }

    public function update()
    {
        $this->validate(); // 这将触发上面的 rules() 方法

        $this->unassignedDefaultHomePage();
        $this->unassignedDefaultNotFoundPage();

        // 确保 $this->modelId 确实是 pages_id 的值
        Page::find($this->modelId)->update($this->modelData());

        $this->modalFormVisible = false;
        $this->reset();
    }

    public function modelData()
    {
        return [
            'title' => $this->title,
            'slug' => $this->slug,
            'content' => $this->content,
            'is_default_home' => $this->isSetToDefaultHomePage,
            'is_default_not_found' => $this->isSetToDefaultNotFoundPage,
        ];
    }
}