php - php 中的查询返回 null 或空值

Question

我写了以下查询:

 $query1 = "SELECT * FROM session WHERE Id_session IN (SELECT * FROM students_in_session WHERE Username = '$email')";
   $res = mysqli_query($conn,$query1);
   $query2 ="SELECT * FROM students_in_session WHERE Username='$email'";
    $res2 = mysqli_query($conn,$query2);
    if (!$res) {
    die(mysqli_error($conn));
 }else{
     while ($row = mysqli_fetch_array($res)) {
       print_r($row);
     $course = $row['Degree'];
     $date = $row['Date'];
     $hour = $row['Hour'];
     $room = $row['Room'];
     }
}
if(!$res2){
    die(mysqli_error($conn));
}else{
    while ($row = mysqli_fetch_array($res2)) {
      print_r($row);
          $prof = $row['Professor'];
        $assis = $row['Assistent'];
    }
}
     return "\n\nDegree: ".$course."\n"."Date: ".$date."\n"."Hour: ".$hour."\n"."Room: ".$room."\n"."Prof: ".$prof."\n"."Assistent: ".$assis;
 }

目前使用phpmyadmin测试查询返回预期结果，但是在代码中使用查询变量都是空的。

这些是数据库的表:

session

|Id_Session|Date|Hour|Room|Degree|

students_in_session

|Id_Session|Code|Name|Surname|Username|Professor|Assistent|

Answer 1

在查询 1 中，您只是尝试将 Id_session 与您需要仅与 session ID 比较的整个表进行比较。

只是替换这个

$query1 = "SELECT * FROM session WHERE Id_session IN 
(SELECT * FROM students_in_session WHERE Username = '$email')";

与

$query1 = "SELECT * FROM session WHERE Id_session IN 
(SELECT Id_Session FROM students_in_session WHERE Username = '$email')";

我想它对你有用。