Website for registering students for a technical event organized at your institute using PHP. Design form for students to register user event. Admin should be able to add, update and delete event details. Students can view register for events. Admin should be able to see analysis about students registered based on their branch, college of students. For analysis, you need to show output in the form of graphs.
This project is done as an assignment for LAMP (Linux Apache MySQL PHP) elective.
This system has 2 actors:
- Student
- Admin
The student is able to log in, register, apply for a new password, register for an event, change the password and logout. The admin is able to log in, add a new event, delete an event, update the event, analyze the event by the graph showing the number of students registered for the event branch wise and logout.
First Name and Last Name: They should have only 1 capital letter and other lowercase letters and no spaces or any other characters.
Birthdate: The age of the student must be greater than or equal to 18 years.
Roll Number: It must be of the regular expression [0-9]{2}[B](IT|CE|CL|ME|EC|EE|IC|CI)[0-9]{2}[1-9]
Email id: Should be a proper email address and that email address should not have been used.
Username: Username does not have space and only have the following things - “A-Z”, “a-z”, “0-9”, “.” and ”_”.
Password: Password must have a minimum length of 8 and should have at least 1 uppercase letter, 1 lowercase letter, 1 numerical and 1 special character. Passwords must match to register. Passwords stored in database are encrypted by MD5 format.
Username and password should match the registered details. After logging in, the Cookies are set saving the username of the user.
Enter the registered username for a password reset. You will get a mail of new random password.
Agree to the terms for registration. It is a required field.
You can change password with original constraints.
Only 2 admins:
- admin - password
- admin2 - password2
Event Name: Event Name should not be present in the database. Also, it should not contain special characters.
Description: The description of the event is required and should be less than 100 characters.
Event Date: Date should be greater than today’s date.
Event Time: Time should be valid.
Event Name: Event Name should be present in the database.
The changes should not violate the Add Event rules. This page also has a graph for analysis.
To run the site on localhost, install XAMPP and start the server. Then go to phpmyadmin page and import the Sessional.sql file to your database. Copy the file to htdocs folder in the XAMPP(windows)/lampp(linux) folder and open the site login.php on your browser If you have kept the files in the folder do add the folder name before login.php.