  将限制只显示学生 ID 为 # 1，不包括其他一切内容

P粉415632319   采纳为最佳   2023-08-08 19:31:32 1楼

当用户点击学生 ID 为 1 的链接时，将获取该链接中的参数 id，然后在 PHP 中使用 global 变量 $_GET['id'] 来查询数据库，并在查询中使用 WHERE 子句。

// Get the student ID from the URL parameter
$studentId = isset($_GET['id']) ? $_GET['id'] : null;


// Prepare the SQL query with the WHERE clause to fetch the specific student's data
$query = "SELECT t1.ID, t1.student_id, t1.Subject, t1.1st_Grading, t1.2nd_Grading, t1.3rd_Grading, t1.4th_Grading, t1.Status, 
          SUM(t1.1st_Grading + t1.2nd_Grading + t1.3rd_Grading + t1.4th_Grading) / 4 as Average 
          FROM grading_system t1 
          LEFT JOIN studentdata t2 ON t1.student_Id = t2.ID 
          WHERE t1.student_id = $studentId
          GROUP BY t1.ID";

 赞 +0 添加回复