Laravel多对多关系中pivot表数据存储失败问题排查

问题描述 #

在Laravel的CRUD操作中，尝试将product_id与supplier_id存入多对多关系的中间表product_supplier，但数据并未在数据库的该中间表中显示。相关代码如下：

ProductController #

public function index()
{
    $products = Product::all();
    return view('manymany.product.index',compact('products'));
}
public function create()
{
    $suppliers = Supplier::all();
    return view('manymany.product.create',compact('suppliers'));
}
public function store(Request $request)
{
    $product = new Product;
    $product->create([
        'name'=>$request->productname,
        'detail'=>$request->detail
    ]);
    $product->suppliers()->attach($request->suppliers);
    return redirect()->route('product.index')->with('successs','Product added successfully!!!');
}

Product Model #

protected $fillable = ['name','detail'];

public function suppliers(){
    return $this->belongsToMany(Supplier::class, 'product_supplier','product_id','supplier_id');
}

SupplierController #

public function index()
{
    $suppliers=Supplier::all();
    return view('manymany.supplier.index',compact('suppliers'));
}
public function create()
{
    $products = Product::all();
    return view('manymany.supplier.create',compact('products'));
}
public function store(Request $request)
{
    $supplier = new Supplier;
    $supplier->create([
        'name'=>$request->suppliername,
        'contact'=>$request->contact,
        'email'=>$request->email
    ]);
    $supplier->products()->attach($request->products);
    return redirect()->route('supplier.index')->with('successs','Supplier added successfully!!!');
}

Supplier Model #

protected $fillable = ['name','contact','email'];

public function products(){
    return $this->belongsToMany(Product::class, 'product_supplier','supplier_id','product_id');
}

product_supplier 迁移文件 #

public function up(): void
{
    Schema::create('product_supplier', function (Blueprint $table) {
        $table->id();
        $table->foreignId('product_id')->constrained()->onDelete('cascade');
        $table->foreignId('supplier_id')->constrained()->onDelete('cascade');
        $table->timestamps();
    });
}

问题原因 #

核心问题出在ProductController和SupplierController的store方法中：

• 先实例化模型对象（如$product = new Product;），但随后调用的create()是静态方法，会创建并保存新的模型实例并返回，但你未将该返回实例赋值给原变量。
• 原变量仍为未保存的空实例，没有有效的id，调用attach()时因缺少模型ID，无法向中间表插入关联数据。

解决方法 #

修改两个控制器的store方法，接收create()返回的已保存模型实例：

修改后的ProductController store方法 #

public function store(Request $request)
{
    $product = Product::create([
        'name'=>$request->productname,
        'detail'=>$request->detail
    ]);
    $product->suppliers()->attach($request->suppliers);
    return redirect()->route('product.index')->with('successs','Product added successfully!!!');
}

修改后的SupplierController store方法 #

public function store(Request $request)
{
    $supplier = Supplier::create([
        'name'=>$request->suppliername,
        'contact'=>$request->contact,
        'email'=>$request->email
    ]);
    $supplier->products()->attach($request->products);
    return redirect()->route('supplier.index')->with('successs','Supplier added successfully!!!');
}

额外检查项 #

• 确保请求中的suppliers（创建产品时）和products（创建供应商时）参数为数组格式，比如表单中使用name="suppliers[]"。
• 确认模型的fillable属性已包含所有需要批量赋值的字段（当前代码已正确配置）。
• 中间表迁移文件的外键约束与字段配置无误（当前迁移文件符合要求）。

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