Laravel 5如何将两个相关表插入（多个）到一个查询中

Question

I have a table which is Order and Product

• orders table: id, order_name
• products table: id, orders_id, product_name

In my model: Order can have many products. Product belongs to order

Below is my view:

<input type="text" name="order_name"> 
<input type="text" name="product_name">

<input type="text" name="order_name"> 
<input type="text" name="product_name">

From the view above, I have two forms whereby the users can add two form with two input.

Now my problem is how do I write the logic in the controller?

I just know the way to write insert one order with multiple product. But I don't know how to insert multiple orders with its related product.

Answer 1

You should use a pivot table, as it's a many to many relationship between the two tables.

Since a product belongs to not just one order but many and an order can have many products, pivot table is the way to go.

See here if you don't know what a pivot table is : http://laraveldaily.com/pivot-tables-and-many-to-many-relationships/

They explain it in an example very similar to yours.