HTML/JavaScript Web Application Answers

QUESTION ONE

1.1 In this task, you are to create a simple registration form. Use the sample below:

USERNAME:

PASSWORD:

CONFIRM PASSWORD:

FIRSTNAME:

SURNAME:

EMAIL:

QUALIFICATION:

CELL NUMBER:

GENDER:

NATIONALITY:

CANCEL

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.

NB: You can set the cookie's expiration time to anything sensible. Also, keep in mind that if the user

logs out manually by clicking the "Log Out" button, the cookie should be erased (set the expiration to a

date in the past). 

QUESTION THREE

25 MARKS

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.

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.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.5

QUESTION TWO

25 MARKS

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.4

1 In this task, you are to create a simple registration form. Use the sample below:

1.2 Create MYSQL database called rgi_student and a table called student_reg which consist of the

following attributes:



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)

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 3

one SQL task is performed under registration form that is, INSERT operation where captured

information is sent to the created table called student_reg.

Bookmark Maker

In this assignment, let's build a Bookmark Maker by applying the concepts we learned till now.