attendance/StudentSignup.php at master · AttendanceManager/attendance · 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
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
<?php
    require 'connect.php';
 $JSONstr = file_get_contents('php://input');
//$JSONstr ='{"RollNo":"15BCS040", "SimID":"42342342","SNo":"ZY2222FXV5","Name":"Shivaak Tripathi", "EnrollmentNo":"422342","Semester":"2","Department":"Comp", "Password":"42342342","PhoneNo":"934234324"}';

class resp
{
        function resp(){
        $this->Name = null;
        $this->RollNo = null;
        $this->EnrollmentNo = null;
        $this->SimID = null;
        $this->SNo = null;
        $this->Department = null;
        $this->Password = null;
        $this->PhoneNo = null;
        $this->Semester = null;
        $this->error = null;
        $this->error_msg = null;
    }
}
    $response = new resp();

    $Object = json_decode($JSONstr);
    $response->error_msg = $JSONstr;
   // echo json_encode($response);
    @$Name = $Object->Name;
    @$RollNo =  strtoupper($Object->RollNo);
    @$Pass = md5(md5($Object->Password));
    @$Sem = (int)$Object->Semester;
    @$Enroll = str_replace("-","",$Object->EnrollmentNo);
    @$Sim = $Object->SimID;
    @$Serial = $Object->SNo;
    @$Phone = $Object->PhoneNo;
    @$Dept =  $Object->Department;

    $respFromDB = userExists($RollNo,$Name,$Serial);
   // echo  $respFromDB;
    if($respFromDB ==0)
    {
        $query = "INSERT INTO StudentBase (RollNo, Name, EnrollmentNo, Semester, Password, Department, PhoneNo,SNo, SimID) VALUES ('$RollNo', '$Name', '$Enroll',$Sem , '$Pass', '$Dept','$Phone','$Serial')";
        $result = $conn->query($query);

        $response->error = "0";
        $response->error_msg = "You are successfully registered.";

        echo json_encode($response);
     }

    else if($respFromDB ==2)
    {
        $response->error = "1";

        $query = "SELECT * FROM Students WHERE RollNo = '$RollNo'";
        $result = $conn->query($query);

        $row = $result->fetch_assoc();
        //echo $result->num_rows;
        echo $result->fetch_array();
        $response->error_msg = "This Roll number and Name already exists but with different phone. You cannot register from more than 1 phone. Details of the registered record is given below. To get any kind of help, feel free to contact us.\n\nName : " .$row['Name']."\nRollNo : ".$row['RollNo']."\nSemester : ".$row['Semester']."\nDepartment : ".$row['Department'];

        echo json_encode($response);
    }

    else if($respFromDB ==1)
    {
        $response->error = "1";

        $query = "SELECT * FROM Students WHERE RollNo = '$RollNo'";
        $result = $conn->query($query);
        $rows = $result->fetch_array();
        $response->error_msg = "You are already registered. No need to register more than once. Your details are:\n\nName : ".$rows['Name']."\nRollNo : ".$rows['RollNo']."\nSemester : ".$rows['Semester']."\nDepartment : ".$rows['Department'];

        echo json_encode($response);
    }

    else if($respFromDB ==3)
    {
        $response->error = "1";
        $query = "SELECT * FROM Students WHERE RollNo = '$RollNo'";
        if($result = $conn->query($query))
        {
            $row = $result->fetch_assoc();
            $response->error_msg = "This Roll number is already registered but with different Name. Details of the registered record is :\n\nName : " .$row['Name']."\nRollNo : ".$row['RollNo']."\nSemester : ".$row['Semester']."\nDepartment : ".$row['Department'];
        }
        echo json_encode($response);
    }
    else if($respFromDB ==4)
    {
        $response->error = "1";
        $query = "SELECT * FROM Students WHERE SNo = '$Serial'";
        if($result = $conn->query($query))
        {
            $row = $result->fetch_assoc();
            $response->error_msg = "This Phone has already been registered but by a different Person. Details of the registered record is :\n\nName : " .$row['Name']."\nRollNo : ".$row['RollNo']."\nSemester : ".$row['Semester']."\nDepartment : ".$row['Department'];
        }
        echo json_encode($response);
    }

    else if($respFromDB ==-1)
    {
        $response->error = "-1";
        $response->error_msg = "Internal Server Error. Try again later";
        echo json_encode($response);
    }

    function userExists($RollNo, $Name, $Serial)
    {
        require 'connect.php';
        $query = "SELECT * FROM StudentBase WHERE RollNo = '$RollNo'";
        $result = $conn->query($query);
        if($conn->query($query))
        {
            $row = $result->fetch_assoc();
            if($result->num_rows > 0)
            {
                if($row['Name'] == $Name)
                {
                    if($row['SNo'] == $Serial)
                        return 1;
                    else
                        return 2;
                }
                else
                    return 3;
            }
            else
            {
                $query = "SELECT * FROM StudentBase WHERE SNo = '$Serial'";
                $result = $conn->query($query);
                if($conn->query($query))
                {
                    $row = $result->fetch_assoc();
                    if($result->num_rows > 0)
                    {
                        return 4;
                    }
                    else
                        return 0;
                }
            }
        }
        else
        {
            return -1;
        }
    }
?>