从两个不同表的两个不同列中选择数据，并插入php中的一个表中 - Select data from two different column of two different table and insert into one table in php

Select data from two different column of two different table and insert into one table in php

当username="somevalue"时，我想从表1（user_info）中选择uid，当start_date="somedate"时，从表2（week）中选择wid，并将其分别插入表3（时间表）列uid和wid。你的帮助将是非常可观的。感谢

   <?php
    include "login.php";
    $connect = mysql_connect("localhost","root","") or die("Couldn't Connect");
    mysql_select_db("user_login") or die ("Couldn't Find Database"); 
    // set current date
    $startdate = $_GET["startDate"];
    $enddate = $_GET["endDate"];
    $mon=$_GET["mon"];
    $tue=$_GET["tue"];
    $wed=$_GET["wed"];
    $thur=$_GET["thur"];
    $fri=$_GET["fri"];
    $sat=$_GET["sat"];
    $sun=$_GET["sun"];
    $totalhour= $mon+$tue+$wed+$thur+$fri+$sat+$sun ;
    $insert_uid= "Insert into timesheet(uid) select uid from user_info where username=".$_SESSION['user']."";
    $result1= mysql_query($insert_uid);
    $insert_wid=  "insert into timesheet(wid) select wid from week where start_date= '$startdate'" ;
    $result2= mysql_query($insert_wid);
    $sql= "insert into timesheet(uid,wid,mon,tue,wed,thur,fri,sat,sun,totalhour) values('$result1','$result2','$mon','$tue','$wed','$thur','$fri','$sat','$sun',$totalhour)";
    mysql_query($sql);
    echo $sql;
      echo "<h2>Thanks! You Timesheet submitted successfully</h2>";
    ?>

使用mysqli_而不是mysql_

您使用的是mysql_函数，应该使用mysqli_，如下所示：

<?php
    include "login.php";
    $connect = mysqli_connect("localhost","root","","user_login");
    if(!$connect){die("Couldn't Connect");}
    // set current date
    $startdate = $_GET["startDate"];
    $enddate = $_GET["endDate"];
    $mon=$_GET["mon"];
    $tue=$_GET["tue"];
    $wed=$_GET["wed"];
    $thur=$_GET["thur"];
    $fri=$_GET["fri"];
    $sat=$_GET["sat"];
    $sun=$_GET["sun"];
    $totalhour= $mon+$tue+$wed+$thur+$fri+$sat+$sun ;
    $insert_uid= "Insert into timesheet(uid) select uid from user_info where username=".$_SESSION['user']."";
    $result1= mysqli_query($connect,$insert_uid);
    $insert_wid=  "insert into timesheet(wid) select wid from week where start_date= '$startdate'" ;
    $result2= mysqli_query($connect,$insert_wid);
    $sql= "insert into timesheet(uid,wid,mon,tue,wed,thur,fri,sat,sun,totalhour) values('$result1','$result2','$mon','$tue','$wed','$thur','$fri','$sat','$sun',$totalhour)";
    mysqli_query($connect,$sql);
    echo $sql;
      echo "<h2>Thanks! You Timesheet submitted successfully</h2>";
    ?>

从user_info中选择uid

$select1 = mysqli_fetch_assoc(mysqli_query($connect,"SELECT uid FROM user_info WHERE username='somevalue'"));
$uid = $select1['uid']; //assuming that you expect just one result from this query

从周中选择宽度

   $select2 = mysqli_fetch_assoc(mysqli_query($connect,"SELECT wid FROM week WHERE start_date=''"));
   $wid = $select2['wid']; //assuming that you expect just one result

插入数据库

mysqli_query($connect,"INSERT INTO timesheet(uid,wid) VALUES('".$uid."','".$wid."')");