CS251- Assignment 9 Solved

                                              Web and DB Technologies​

Q1. ​Create your homepage at ​www.cse.iitk.ac.in

 

Steps: 

1.              Login to turing.cse.iitk.ac.in

2.              Change directory into /homepages/global/<your cse ldap/

3.              Create  your homepage Sample page:

https://www.cse.iitk.ac.in/users/dhanajit/

 

Q2. ​Create an web application to automate the process of registration for an event organized by students of CS251 named as “Lets build stuff!”. You are required to use html, php and SQLite to build the site. 

 

The registration workflow is as follows. 

 

1.     Registration page containing text boxes asking for name, address, email, mobile number, bank account number and bank password and a submit button.  You should write javascript to validate the user input as per the following specifications.

a.     name : Maximum 20 characters with only english alphabets and space

b.     address: Maximum 100 characters

c.     email should be of the form “​[email protected]​” where leftside may contain english alphabets only and rightside must end with a “.com” domain name

d.     Mobile number is a 10-digit numeric value

e.     Bank account number is a 5-digit numeric value

f.      Bank password can be maximum 20 alphanumeric characters and should not be displayed when entered in the textbox.

2.     Once submitted, you should perform the following checks in a separate php file and display “Registration Successful” only if registration is successful (see the conditions below). 

a.     If the same email already exists in the list of registrations (maintained in SQLite DB) the registration fails with a message “Already registered”.

b.     You should check the account balance (maintained in a separate table) against the provided input and deduct registration fees (1000) from the account. Display “Insufficient Balance” if the account balance is less than 1000 and “Invalid Account/Password” if the account number and passwords do not match.

3.     In the registration page, a link to “See all registrations” takes the browser to a new page which asks for admin login and password. Once submitted and verified from by queries the “admin” table, all the registrations (so far) should be displayed in a tabular form with all  inputs provided in the registration page except for the password.  There should be a link named “Another Registration” for all of the pages except the main registration page.

You can get started by installing necessary softwares on your laptop.  If anyone need access to a development setup, do let me know as soon as possible.

Submission guidelines
 

One single archive containing two separate folders for question 1 and question 2. Expanded view of the archive should be as follows,

 

Rollno |

           |-----------q1

           |                |

           |                |-------- index.html (your page)            |                |-------- images            |                |-------  others ....

           |

           |-----------q2

                          |

                          |------- htmls and phps

                          |-------- javascript, images etc                           |------- sqlite db file                           |-------- others ...