我有两个表:
发票,发票部分
我使用两个表的原因是因为我不想将发票部分数组保存到发票表上的一条记录中，我不想将其保存到发票表上的多条记录中。
当我提交数据到两个表，我怎么能链接两个表与ID如果我没有ID还在一起?
$result = mysqli_query($mysqli, "INSERT INTO invoices(labelwarning, status, todaysdate, todaystime, todaysdatetime, avatar, firstname, lastname, mwaid, nextgenid, manager, manageremail, dispatcher, dispatcheremail, techemail, tag, serialnumber, currentequipment, company, address, city, state, zip, contactperson, contactnumber , currentdate, timearrived, timecompleted, login_id) VALUES('$labelwarning', '$status', '$todaysdate', '$todaystime', '$todaysdatetime', '$avatar', '$firstname', '$lastname', '$mwaid', '$nextgenid', '$manager', '$manageremail', '$dispatcher', '$dispatcheremail', '$techemail', '$tag', '$serialnumber', '$currentequipment', '$company', '$address', '$city', '$state', '$zip', '$contactperson', '$contactnumber ', '$currentdate', '$timearrived', '$loginId')");
$result2 = mysqli_query($mysqli, "INSERT INTO invoiceparts(partnumber, partdescription, partprice, partquantity, partdb, login_id) VALUES '$partnumberstring', '$partdescriptionstring', '$partpricestring', '$partquantitystring', '$partdbstring', '$loginId')");
如果你需要链接"login_id"并且login_id是由AUTO_INCREMENT生成的，那么你可以通过
- 为Mysqli连接，mysqli_insert_id($ Mysqli);$mysqli->lastInsertId();
如果login_id不是AUTO_INCREMENT字段，则可以通过
- SELECT login_id FROM invoices ORDER BY login_id DESC LIMIT 1;
它会返回最后插入的行我们可以获取login_id