(PHP CODE)

COVID 19 Student Tracking System

At the entrance of each class will have a qr-code which is when scanned will read

serveraddress/projectName/add.php?roomno=rno where boldfaced text could vary but basically a php page named add.php with changing room numbers.

a. Create an HTML page which will accept text and return qrcode that could be printed.

b. When the page add.php loaded romm number will be displayed and telephone number will be asked, together with the current time and date the information should be stored within a database table.

Within the database table: RoomNumber, TelephoneNumber, Time, Date, and an optional Name Surname should be stored for each student, who visited the class, in minimum.

For Listing the records stored, we need username & password authentication and authorization, where a single user with a fixed password is welcome as a minimum requirement.

c. A PHP page where; to query and display the list of all students for a specific room at a specific date and ordered by time is possible.

d. A PHP page where; to query and display the list of all students for all rooms between two dates ordered by date and time is possible.