'$c_date' OR Lab_Report_ID IN (SELECT `Lab_Report_ID` FROM `extended_deadlines_table` WHERE Student_ID=$student_id AND Extended_Deadline_Date > '$c_date' AND Lab_Report_ID IN (SELECT Lab_Report_ID FROM lab_reports_table WHERE Course_ID=$course_id)))" . " AND Lab_Report_ID NOT IN (SELECT Lab_Report_ID FROM lab_report_submissions WHERE Course_Group_id IN (SELECT Course_Group_id FROM course_group_members_table WHERE Student_ID=$student_id))" . " ORDER BY Lab_Report_ID DESC"; $result1 = mysqli_query($con, $var); if (mysqli_num_rows($result1) == 0) { echo "No active assignments for this course so far."; } else { while ($row = mysqli_fetch_assoc($result1)) { $title = $row['Title']; $type = $row['Type']; $Marks = $row['Marks']; $ins = $row['Instructions']; $posted = $row['Posted_Date']; $deadline = $row['Deadline']; $att1 = $row['Attachment_link_1']; $att2 = $row['Attachment_link_2']; $att3 = $row['Attachment_link_3']; $att4 = $row['Attachment_link_4']; $labid = $row['Lab_Report_ID']; $full_link = "$att1"; if ($att2 != "") { $full_link = $full_link . "| $att2"; } if ($att3 != "") { $full_link = $full_link . "| $att3"; } if ($att4 != "") { $full_link = $full_link . "| $att4"; } echo "

$title ($type)
$ins
Posted : $posted Deadline : $deadline ($Marks Marks) Submit Lab Report
Attachments : $full_link

"; } } echo ""; ?>

$att1"; if ($att2 != "") { $full_link = $full_link . "| $att2"; } if ($att3 != "") { $full_link = $full_link . "| $att3"; } if ($att4 != "") { $full_link = $full_link . "| $att4"; }; echo "

MISSED $title ($marks Marks)
$ins
Posted: $posted
Deadline: $deadline
Attachments : $full_link

"; } } echo ""; ?>

Re-Submit "; } $full_link = "$att1"; if ($att2 != "") { $full_link = $full_link . "| $att2"; } if ($att3 != "") { $full_link = $full_link . "| $att3"; } if ($att4 != "") { $full_link = $full_link . "| $att4"; } echo "

$title
$ins
Posted : $posted Deadline : $deadline ($marks Marks) $submittedx Submitted
Submitted files: "; $Sub_result = mysqli_query($con, "SELECT `Submission_ID`, `Submission_Date`, lab_report_submissions.Lab_Report_ID, lab_report_submissions.Student_id sub_std, lab_report_submissions.Course_Group_id, `Attachment1`, `Notes`, `Attachment2`, `Attachment3`, `Attachment4`, `Marks`, lab_report_submissions.Status, `Title`,users_table.Full_Name,course_group_members_table.Student_ID FROM `lab_report_submissions` Left JOIN users_table on users_table.Student_ID=lab_report_submissions.Student_id left JOIN course_group_members_table on course_group_members_table.Course_Group_id=lab_report_submissions.Course_Group_id where Lab_Report_ID=$lab_repo_id and (lab_report_submissions.Student_id='$student_id')"); if (mysqli_num_rows($Sub_result) == 0) { echo "No Attachments found."; } else { while ($row = mysqli_fetch_assoc($Sub_result)) { $at1 = $row['Attachment1']; $at2 = $row['Attachment2']; $at3 = $row['Attachment3']; $at4 = $row['Attachment4']; $base_at1 = basename($at1); $base_at2 = basename($at2); $base_at3 = basename($at3); $base_at4 = basename($at4); $full_link = "$base_at1"; // prevent students from directly accessing their classmates' submissions if ($at2 != "") { $full_link = $full_link . " | $base_at2"; } if ($at3 != "") { $full_link = $full_link . " | $base_at3"; } if ($at4 != "") { $full_link = $full_link . " | $base_at4"; } echo $full_link; } } echo "

"; } } echo ""; ?>

Request Remarking "; } if ($status == 'Remarking') { $remarking = " Remarking Request sent
Remarking Reason:$remarking_reason
"; } echo "

$title ($marks Marks out of $Originalmarks)
Lecturer Feedback : $notes $remarking
Submission files :"; $Sub_result = mysqli_query($con, "SELECT `Submission_ID`, `Submission_Date`, lab_report_submissions.Lab_Report_ID, lab_report_submissions.Student_id sub_std, lab_report_submissions.Course_Group_id, `Attachment1`, `Notes`, `Attachment2`, `Attachment3`, `Attachment4`, `Marks`, lab_report_submissions.Status, `Title`,users_table.Full_Name,course_group_members_table.Student_ID FROM `lab_report_submissions` Left JOIN users_table on users_table.Student_ID=lab_report_submissions.Student_id left JOIN course_group_members_table on course_group_members_table.Course_Group_id=lab_report_submissions.Course_Group_id where Lab_Report_ID=$id and lab_report_submissions.Student_id='$student_id'"); if (mysqli_num_rows($Sub_result) == 0) { echo "No Attachments found."; } else { while ($row = mysqli_fetch_assoc($Sub_result)) { $at1 = $row['Attachment1']; $at2 = $row['Attachment2']; $at3 = $row['Attachment3']; $at4 = $row['Attachment4']; $full_link = "$at1"; if ($at2 != "") { $full_link = $full_link . "| $at2"; } if ($at3 != "") { $full_link = $full_link . "| $at3"; } if ($at4 != "") { $full_link = $full_link . "| $at4"; } echo $full_link; } } } } echo "

"; ?>

Please confirm!

Class Groups