且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在MySQL php中将ID从一张表插入到另一张表

更新时间:2021-10-23 23:00:31

您的代码中存在一些问题,其中所有最后插入的 id 都无法在不执行第一个查询的情况下插入.

You have some issues in your code ist of all last inserted id cant insert at like that without executing first query.

你可以这样使用:

//Creating an sql query
$sql = "INSERT INTO information(name, weather, date, status, time_in, time_out) VALUES ('$name','$weather','$date', '$status', '$timeIn', '$timeOut')";

//Importing our db connection script
require_once('dbConnect.php');

//Executing query to database
if(mysqli_query($con,$sql)){
    echo 'Information Added Successfully';
    $lastid = mysqli_insert_id();       
    $sql = "INSERT INTO work_force (subcontractors, number_of_person, number_of_hours, twf) VALUES ('$subcontractors','$noPeople','$noHours',$lastid)";
    mysqli_query($con,$sql);
}else{
echo 'Could Not Add Information';
}