There are 36 students in the web technology class. The students will demonstrate their projects at six different one-hour long time slots. Up to 6 students can give their demonstrations in a given time slot. The professor decides to have a registration webpage to allow students to sign up for one of the time slots. A student visiting the page should be able to submit his/her UMID, first name, last name, project title, email address, phone number, and book a seat in one of the available time slots. A student is uniquely identified by his/her UMID.The submitted data should be stored in a MySQL database which is maintained on a server. The webpage and the server should interact with each other at every step of the registration process. The page should show how many free seats are available in each time slot, announcing and blocking all fully booked time slots. After a student makes a data submission, it should check whether the student has been already registered. If not, the data is stored on the server and the student is notified about her registration. Otherwise, if already registered, the student should be prompted to ensure that she wants to change her registration to the new section (and removed from the current one she is registered for). For example, the time slots may look like the following list:1. 12/9/19, 6:00 PM - 7:00 PM, 6 seats remaining 2. 12/9/19, 7:00 PM – 8:00 PM, 5 seats remaining 3. 12/9/19, 8:00 PM - 9:00 PM, 3 seats remaining 4. 12/10/19, 6:00 PM – 7:00 PM, 2 seats remaining 5. 12/10/19, 7:00 PM – 8:00 PM, 4 seats remaining 6. 12/10/19, 8:00 PM – 9:00 PM, 0 seats remainingIn addition, you need to write a separate webpage that will display the list of students (including their UMIDs, names, project titles, email addresses, phone numbers, and time slots) who are registered, after querying the database.Requirements 1. For your assignment, you should use HTML, CSS, JavaScript, PHP, and MySQL. 2. The database must fully implement the registration process, maintaining the submitted information. The server and page behavior must meet the requirements listed above. 3. The specific look and feel of the pages as well as the database implementation is left intentionally vague, allowing considerable design freedom on your part. However, the page should have a nice look and the code should satisfy common standards. 4. User inputs must be validated at the server side in PHP. The validation at the client side in JavaScript is optional. The first and last name fields cannot be empty and consist of alpha letters only. UMID must be exactly 8 digits. Email must be a valid email address.



Answer :

Other Questions