Website Development | Assignment

[Document title]
[DOCUMENT SUBTITLE]
[Year]

Contents
Introduction:............................................................................................................... 2
1. Database:............................................................................................................... 2
2. Home:..................................................................................................................... 4
3. Registration System:.............................................................................................. 5
4. Login/Logout System:............................................................................................. 8
5. User Authorization:............................................................................................... 11
6. Extra credit:.......................................................................................................... 12

Introduction:
For this assignment XAMMP is installed, as XAMMP is complete package for web
development. XAMMP provides service for PHP as well as for MySQL. The database
is created in MySQL with the help of phpmyadmin. The web pages created in PHP
are stored in the folder \xampp\htdocs\.
In this assignment, Website is developed for Music store, when user visit the
website then Login web is shown to login the website, if user is already register than
user can enter the valid credentials and login to the website and if new user then
can register himself/herself by using sign up option. The sign up option has
important fields such as username, firstname, lastname and phone number. Once
entered all thses details user is registed and redirected to login page from where
user can login to website. For authorized user once login can view the registration
details on home page. This website has features to reset password as well as log
out from the website. Additionally Contact us, About us and News pages created. All
this features will be explained in below sections. The contact us page has form
which has the details of the user and user can enter the comment and that
comment will have the query or feedback from the user and when user submits
then it can be stored.
1. Database:
The database is created in MySQL and the name of the database is “finalproject”.
Two tables are created first table “users” is created to store the registration of the
users and authorize the users to login to the system, the second table
“MusicDetails” is created to save the details of Music albums and their price.
Below snapshot shows the two tables and their data (along with the table creation
script).

In the database the password is stored in the form of Hash, so that nobody can get
the password details of the user from the database.
CREATE TABLE users (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(50) NOT NULL UNIQUE,
password VARCHAR(255) NOT NULL,
fname VARCHAR(255) NOT NULL,
lname VARCHAR(255) NOT NULL,
phone VARCHAR(255) NOT NULL,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);