Student-Mmanagement-System/studentUploadProcess.php at main · KusalAdithya/Student-Mmanagement-System · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
<?php
session_start();
require "connection.php";

if (isset($_SESSION["student"])) {
    $student = $_SESSION["student"];

    $asId = $_POST["asID"];

    if (isset($_FILES["uploadFile"])) {

        $uploadFile = $_FILES["uploadFile"];

        $extension = pathinfo($uploadFile["name"], PATHINFO_EXTENSION);

        $fileex = $uploadFile["type"];

        if (!in_array($extension, ['zip', 'pdf', 'docx'])) {
            echo "Please Select a valid file.";
        } else {

            $uniC = uniqid();
            $uploadFileName = "UploadFiles//" . $uniC . $uploadFile["name"];

            $file_name = $uniC . $uploadFile["name"];

            move_uploaded_file($uploadFile["tmp_name"], $uploadFileName);

            if ($student["section_id"] == "4") {  //A/L student

                $Up = Database::search("SELECT * FROM `a/l_results` WHERE `student_s_ad_no`='" . $student['s_ad_no'] . "' AND `a/l_assignment_id`='" .  $asId . "' ");
                $Up_nr = $Up->num_rows;

                if ($Up_nr == 1) {  //re upload assigment before end date

                    Database::iud("UPDATE `a/l_results` SET `file`='" .  $file_name . "' WHERE `student_s_ad_no`='" . $student['s_ad_no'] . "' AND `a/l_assignment_id`='" .  $asId . "' ");

                } else { //upload new assignment

                    Database::iud("INSERT INTO `a/l_results` (`student_s_ad_no`,`a/l_assignment_id`,`file`,`result`,`status_id`) VALUES ('" . $student['s_ad_no'] . "','" . $asId . "','" .  $file_name . "','Pending','2')");
                }

                echo "Assignment submitted successfully";

            } else {  //not A/L

                $Up = Database::search("SELECT * FROM `results` WHERE `student_s_ad_no`='" . $student['s_ad_no'] . "' AND `assignment_id`='" .  $asId . "' ");
                $Up_nr = $Up->num_rows;

                if ($Up_nr == 1) {  //re upload assigment before end date

                    Database::iud("UPDATE `results` SET `file`='" .  $file_name . "' WHERE `student_s_ad_no`='" . $student['s_ad_no'] . "' AND `assignment_id`='" .  $asId . "' ");

                } else { //upload new assignment

                    Database::iud("INSERT INTO `results` (`student_s_ad_no`,`assignment_id`,`file`,`result`,`status_id`) VALUES ('" . $student['s_ad_no'] . "','" . $asId . "','" .  $file_name . "','Pending','2')");
                }

                echo "Assignment submitted successfully";
            }

        }
    } else {
        echo "Please select a file";
    }
}