php - mysqli_insert_id 的问题

Question

我尝试在多个查询中使用 mysqli_insert_id，但我一直收到 无法添加或更新子行:外键约束失败。下面是我的代码:

$con=mysqli_connect("Stuff");
            if(mysqli_connect_errno()){
                echo "There was a mistake connecting". mysqli_connect_errno();
                }
        $First=mysqli_real_escape_string($con,$_POST["FirstName"]);
        $Last=mysqli_real_escape_string($con, $_POST["LastName"]);
        $Phone=mysqli_real_escape_string($con,$_POST["Number"]);
        $Product=mysqli_real_escape_string($con,$_POST["Product"]);
        $Quantity=mysqli_real_escape_string($con,$_POST["Quantity"]);


            if(!empty($_POST["FirstName"]) && !empty($_POST["LastName"])){
                $sql="INSERT INTO Customer(First,Last)
                    VALUE('$First', '$Last')";
                    $id = mysqli_insert_id($con);
                        if(!mysqli_query($con,$sql)) {
                            die("ERROR". mysqli_error($con));

                                }
                            }


            if(!empty($_POST["Number"])){
                $sql="INSERT INTO Customer_Number(Customer_ID,Number)
                    VALUE('$id','$Phone')";

                        if(!mysqli_query($con,$sql)) {
                            die("ERROR". mysqli_error($con));

                                }
                            }

                            if(!empty($_POST["Product"]) && !empty($_POST["Quantity"])){
                                $sql="INSERT INTO Product(Customer_ID,Product,Quantity)
                                      VALUE('$id','$Product','$Quantity')";


                                     if(!mysqli_query($con,$sql)) {
                            die("ERROR". mysqli_error($con));

                                }else{
                               echo "Special Order Added";
                               }
                            }
                            mysqli_close($con);
                            ?>

我也尝试过使用 Last_Insert_ID()，但这只适用于一个查询，然后在我尝试将其添加到第二个查询时给出相同的错误消息。

Answer 1

在 mysqli_query 之后调用 mysqli_insert_id