HTML/JavaScript Web Application Answers

The school of Computing and Mathematical Sciences is open for registration of ICT qualifications. Create a registration form that accepts a prospective student’s name, surname, race, gender, cellphone number, email address, home address and the ICT qualification the student wishes to apply for (Diploma in ICT: Applications Development, Advanced Diploma in ICT: Application Development, Post Graduate Diploma in ICT: Applications Development). Upon completion of the form, the prospective student must agree to the terms and conditions of the university by selecting a checkbox and submit the form. Insert this data into the database. Also include a delete and update button. 

NB: Please align your textboxes and text fields

4.1 A successful login should create a session variable that informs the server that the user has logged in. Set $_SESSION[‘loggedin'] to TRUE.

4.2 Check the session variable once the page has loaded. Display the welcome form instead of the login form if the user is already logged in.

4.3 Add a "Log Out" button to the welcome form that, when clicked, logs the user out by removing the session variable. The user should be sent to the same page after clicking the button, which now includes a login form.

4.4 Add an option to the login form that says "Remember me!" Save a cookie that identifies the user to the server if the box is ticked and the login is successful. Even if the browser is closed, the user should seem logged in on subsequent visits to the website.

3.5 Create another table called student_res in database rgi_student that stores below information:

 MODULE (TEXT)

 FINAL_MARK (INTERGER)

NB. Again use student_reg table to retrieve studentID, firstname and display as in the table above then also use student_res table to retrieve module name and final mark obtained. Request academic record button sends an email to Richfield results department requesting student academic record.

3.4 When the student is ready to check his results, he will select the result button. His studentID, firstname, and all modules results will show in the results table.

3.3 Create another table called student_info in database rgi_student that stores below information:

 STD_BALANCE (INTERGER)

 DUE_DATE (DATE)

 ATTENDANCE (INTERGER)

NB. Use student_reg table to retrieve studentID, firstname and display as in the table above then also use student_fees table to retrieve balance and its due. Return button takes the student back to the home page.

3.2 When the student “prominentm” clicks the fees button, the fees for that student will appear, along with the deadline for fee submission. The output should match the one below:

3.1 When a student login successfully, the student's home page appears first. It will display his username as well as three buttons showing the user's fees, attendance, and results. When he/she selects the fees, attendance, and result buttons, the fees, attendance, and results will be displayed.

2.1 In continuation of QUESTION ONE, in this task, you are to create a login form. Forms, submitting requests, and interacting with a MySQL database will all be covered.

2.2 Use information on MYSQL student_reg table to login making sure you are using proper credentials.

2.3 Register button should take the user to a new page that allows them to register if they are not registered in the system.

2.4 If student’s credentials do not match the one in the database when trying to login, the page should display login error message and only three attempts are permitted before the user is kicked out of the system for 30 minutes.

1.3 Once the information has been inputted by the student at the frontend (REGISTRATION FORM), all the fields need to be validated before being sent to the backend (MYSQL DATABASE). Only one SQL task is performed under registration form that is, INSERT operation where captured information is sent to the created table called student_reg.

CREATE DATABASE rgi_student;

CREATE TABLE student_reg (

STID INTEGER (4)

USERNAME VARCHAR(30)

PASSWORD HASH CHAR(25)

CONFIRM PASSWORD

FIRSTNAME VARCHAR(30)

SURNAME VARCHAR(30)

EMAIL TEXT

QUALIFICATION VARCHAR(15)

CELL NUMBER INTERGER(10)

GENDER VARCHAR(6)

NATIONALITY VARCHAR(25)

);