使用 Laravel 同时插入两个表的主键和外键

Question

我有两个表“发票”，其中“invoice_no”作为主键，“invoice_details”以“invoice_no”作为外键。我想使用 Laravel 同时将数据插入到两个表中。问题是当我提交表单时，数据被存储到发票表中，但没有存储到invoice_details中，这给了我外键为空的完整性约束违规错误。

这是控制器代码：

public function insertInv(Request $request){

        

        //insert into invice

        $customer_name = $request->input('customer_name');

        $c_email = $request->input('c_email');

        $c_phone = $request->input('c_phone');

        $billing_address = $request->input('billing_address');

        $term = $request->input('term');

        $order_date = $request->input('order_date');

        $due_date = $request->input('due_date');

        $discount = $request->input('discount');

        $net_total = $request->input('net_total');

        $paid = $request->input('paid');

        $due = $request->input('due');

        $payment_type = $request->input('payment_type');

        $invoice_msg = $request->input('invoice_msg');

        

        //insert into invoice_details

        $invoice_no = $request->input('invoice_no');

        $product_name = $request->input('state');

        $inven_name = $request->input('country');

        $unit = $request->input('unit');

        $price = $request->input('price');

        $qty = $request->input('cqty');

        $sub_total = $request->input('sub_total');

        //insert into invoice

        $invo=array('customer_name'=>$customer_name,'c_email'=>$c_email,'c_phone'=>$c_phone,'billing_address'=>$billing_address,'term'=>$term,'order_date'=>$order_date,'due_date'=>$due_date,'discount'=>$discount,'net_total'=>$net_total,'paid'=>$paid,'due'=>$due,'payment_type'=>$payment_type,'invoice_msg'=>$invoice_msg );

        DB::table('invoice')->insert($invo);

        

        //insert into invoice_details

        $invo_det=array('invoice_no'=>$invoice_no,'product_name'=>$product_name,'inven_name'=>$inven_name,'unit'=>$unit,'price'=>$price,'qty'=>$qty,'sub_total'=>$sub_total);

        DB::table('invoice_details')->insert($invo_det);

        

     

        return redirect()->back();

}

Answer 1

您可以使用insertGetId方法：$invoiceId= DB::table('invoice')->insertGetId($invo);     $invo_det=array('invoice_no'=>$invoiceId,'product_name'=>$product_name,'inven_name'=>$inven_name,'unit'=>$unit,'price'=>$price,'qty'=>$qty,'sub_total'=>$sub_total);    DB::table('invoice_details')->insert($invo_det);