Ask a question from expert

Ask now

Website Development | Assignment

Create a website with user registration and login functionality using PHP and MySQL. The website should also have a logout feature and allow users to view their own information. Additional pages, such as a 'contact us' page, can earn extra credit. The project should be well commented and should not display error messages.

14 Pages1218 Words21 Views
   

Added on  2022-09-06

Website Development | Assignment

Create a website with user registration and login functionality using PHP and MySQL. The website should also have a logout feature and allow users to view their own information. Additional pages, such as a 'contact us' page, can earn extra credit. The project should be well commented and should not display error messages.

   Added on 2022-09-06

BookmarkShareRelated Documents
[Document title]
[DOCUMENT SUBTITLE]
[Year]
Website Development | Assignment_1
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
Website Development | Assignment_2
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).
Website Development | Assignment_3
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
);
Website Development | Assignment_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Computer Science Assignment: PHP and MySQL - Desklib
|19
|2163
|111

Contemporary Software Development
|21
|2755
|218

First National Bank - User Registration, Login, Account Management and Transactions
|9
|830
|301

Brothers Restaurant System
|10
|947
|27

Benefits for Online Web System Application
|40
|4587
|44

Code Functionality and Description
|5
|688
|46