[Solved] CS251-Assignment 9-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.
   1. name : Maximum 20 characters with only english alphabets and space
   2. address: Maximum 100 characters
   3. email should be of the form [email protected] where leftside may contain english alphabets only and rightside must end with a .com domain name
   4. Mobile number is a 10-digit numeric value
   5. Bank account number is a 5-digit numeric value
   6. 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).
   1. If the same email already exists in the list of registrations (maintained in SQLite DB) the registration fails with a message Already registered.
   2. 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.