2019-02-21 14:55
浏览 255

Laravel 5.7雄辩地更新/删除多条记录

My table structure is like this:


        id, title, desciption, total_amount, --


        id, name, price, --


        id, invoice_id, product_id, --
  • One invoice can have multiple products, so,

  • I created an invoice with products, then data fills according to above DB structure.

  • When i update invoice (let say invoice_id = 2 ), then, i am confused what is the best way to update "invoice_products" table.

  • My approach is ( for "invoice_products" table):

    • delete * from invoice_products where invoice_id=2;
    • then insert modified products again.
  • I think this is not good approach, as i am force deleting the rows in "invoice_products" and again inserting new updated products.

  • is there any way to do via eloquent ?

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • dswqz24846
    dswqz24846 2019-02-21 15:03

    I think invoice_products is pivot table. You should use sync method.

    $productIds = [1,2,3];

    Also in your invoice Model the relationship should be like this

    public function products()
        return $this->belongsToMany(Invoice::class, 'invoice_products', 'invoice_id', 'product_id');

    More Details

    点赞 评论
  • doukuanghuan7582
    doukuanghuan7582 2019-02-21 15:05

    You can use Laravel many to many relation to achieve this functionality:

    Invoice Model

    public function products()
        return $this->belongsToMany('App\Product', 'invoice_products');

    Product Model

    Though it is not required here but you can use this to get invoice for related products.

    public function invoices()
        return $this->belongsToMany('App\Product', 'invoice_products');

    To update the existing data you can use sync method:

    $products = [1, 2, 3, 4];

    You can read more about relationship over

    点赞 评论