php - 如何从其他表中插入常量值和选择值？

Question

我想将另一个表中的数据插入到另一个表中。但首先我还需要包含从父表中插入的最新 id。任何人都可以帮助我吗？

<?php 

        $insert1 = "INSERT INTO purhcase_order
        (Supp_ID, Approved_by, Prepared_by, Estemated_cost)
        VALUES ($suppname, '$appname', '$prepname', $total_cost)";
        // $resultToinsert1 = mysqli_query($connector, $insert1);
        // header('location: purchase-order_staff.php');
        if (mysqli_query($connector, $insert1)) {
            $lastInsertedId = mysqli_insert_id($connector);

            $insert2 = "INSERT INTO purchase_order_product
            (Pur_ord_id, Product_ID, Quantity, Estimated_amount)
            SELECT  $lastInsertedId, A.Product_ID, B.Qty_requested as 
            Quantity, (B.Qty_requested * C.Product_price ) as 
            Estimated_amount from 
            ware_house_product A, purchase_request_product B, 
            supplier_product C, purchase_request D, supplier E 
            WHERE A.Product_ID = B.Product_ID and 
            A.Product_ID=C.Product_ID AND C.Supp_ID=E.Supp_ID 
            AND E.Supp_ID='$suppname' AND 
            D.Pur_req_id='$Purchase_request_id'";

            $resultToinsert2 = mysqli_query($connector, $insert2);
            if ($resultToinsert2 == TRUE) {
                header('location: purchase-order_staff.php');

               }else {
                   echo "Data is not inserted";
               }
            }else {
                echo "Data is not inserted";
            }
        }
 }
?>

标签： phpmysql