Download - Allah Noor
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 1/47
ONLINE SHOPPING SITE
Submitted by:
Allah Noor
Muhammad Asif
Supervised by:
MR. Muhammad Ahmad Jan
Session: 2009-11
Institute of Computing &Information technology,
Gomal University D. I. Khan
1
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 2/47
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 3/47
ACKNOWLEDGMENT
First we offer our humble and sincere thanks to almighty
"ALLAH" who bested us the potential and ability to make use of
already existing ocean of knowledge.
It is a grate privilege and pleasure for us to express our
immense indebtedness, deepest gratitude and profound regard to the
venerable and respectable teacher and our supervisor Mr. Muhammad
Ahmad Jan for his constant encouragement, cooperation and helpful
suggestion in preparation of our project.
We would like to offer thanks to Mr. Bashir Ahmad, Director
ICIT, for providing us facilities to carry out our project. We are
thankful to him for providing good computer lab facility during our stay here at the department.
Special thanks to all teachers of ICIT for helping us in two
years degree.
3
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 4/47
APPROVAL CERTIFICATE
This is to certify that Mr Allah Noor and Mr Muhammad Asif
have completed their final Project at institute of computing and
information technology, Gomal university D.I.Khan. The project
report submitted by them is hereby approved in partial fulfillment of
the requirement for the degree of Master in computer science (MCS)
________________________
EXTERNAL EXAMINER:
MR. MUHAMMAD AMEER KHAN
Lecturer Govt. College No. 1
D.I.Khan
________________________
INTERNAL EXAMINER
MR. Muhammad Ahmad Jan
Lecturer ICIT
Gomal university
D.I.Khan
________________________
DIRECTOR
DR.BASHIR AHMAD
ICIT
Gomal University
D.I.Khan
4
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 5/47
PROJECT IN BRIEF
PROJECT TITLE
WEBSITE FOR ONLINE SHOPPING
OBJECTIVE
To facilitate the customers to purchase different products online.
UNDERTAKEN BY
Allah Noor
Muhammad Asif
SUPERVISED BY
Mr. Muhammad Ahmad Jan
Lecturer ICIT
Gomal University D.I.Khan
SOFTWARE USED
PHP
My Sql
Image Composer 1.5
Microsoft Front page 2003
5
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 6/47
CHAPTER Description Page No
Chapter 1 Introduction ……………………………………… 81.1 Internet history……………………………………………. 9
1.2 computer used in internet………………………………. 9
1.3 web pages…………………………………………………. 10
1.4 Introduction of online shopping………………………. 12
1.5 About Gomal online shopping site…………………… 13
1.6 Main features……………………………………………… 13
Chapter 2 Existing system …………………………….. …. 14
2.1 Introduction………………………………………………. 15
2.2 Disadvantages…………………………………………… 15
Chapter 3 Proposed system ……………………………….. 17
3.1 Introduction …………………………………………….. 183.2 Who can use the website? ....................................... 18
3.3 Customer registration…………………………………. 18
3.4 Features of proposed system………………………… 19
Chapter 4 System requirement specification……………… 20
4.1 Introduction …………………………………………….. 21
4.2 Input specification……………………………………... 214.3 process specification…………………………………. 22
4.4 output specification …………………………………… 22
6
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 7/47
CHAPTER Description Page No
Chapter 5 System Design…..………………………………. 23
5.1 Introduction ……………………………………………. 24
5.2 Data base design……………………………………… 24
5.3 logical data base design……………………………... 24
5.4 E R Diagram……………………………………………. 25
5.4 physical data base design………………………….... 26
Chapter 6 Front End Design ……………………………… 30
6.1 User interface…………………………………………. 31
6.2 Administrator interface……………………………… 39
Chapter 7 System testing and evaluation ………………... 45
7.1 Testing strategies…………………………………….. 46
7.2 Input testing…………………………………………… 46
7.3 Output testing…………………………………………. 46
7.4 Code testing…………………………………………… 46
7.5 Data base testing…………………………………….. 46
7.6 During development testing……………………….. 46
7.7 Evaluation of the software of the end user …….. 47
7
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 8/47
Chapter # 1
Introduction
8
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 9/47
History of Internet
Internet began in 1969, as an experimental four computer network
called ARPA Net. This was designed by the US defense department so
that research scientists could communicate to each other. In
approximately two years ARPA Net grew to about two dozen sites, and in
1981 it consists of almost tow hundred sites. In 1990 ARPA Net was
officially disband, and the network which was no consists of hundred of
websites was called internet. After some time commercial organizations
begin to recognize the use of such a network which converted the whole
world as a global village and allowed to access of all to business as well
as commercial data, and a host of other services such as email and e-
commerce. The rapid growth of the internet was due to networking giants,
like British telecom, Hyundai, AT&T and others setting up fast and rapid
networks, that encircles the globe. The networking giants were varying
clear about their goal. This was to setup and maintain, monitor and expand
existing networks.
Computers used in internet
There are two types of computers used in internet i.e
1. server
2. client
Server
Servers are the computers which provide services to the client. It is
the combination of hardware and software. Web server software is special
software installed on web server. It provide the following services
1. Receives request from client and process it.
2. Sends response back to the particular client who had made
request for it.
9
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 10/47
Some of the most popular software server software are,
• PWS (personal web server)
• IIS (internet information system)
• Apache
Client
Client is the computer which uses the services provides by web
server. A special software is installed on client machine called web
browser and provides the following services,
1. Send request to web server.
2. Receive response from web server.
3. Display contents of requested page.
Some special web browsers are,
• Internet explorer
• Mozilla firefox
• Opera
Webpage
Webpage is a file or document written within html or html and
Programming code, the programming code toll may be VB script, JAVA
script or any other.
There are two types of web pages.
• static web pages
• Dynamic web pages
10
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 11/47
Static pagesStatic web page can be defined as “ it is a document or file which is
written pure html”. It is saved with the extension of .html or .htm.
Characteristics
1. Contents of static web page always remain constant.
2. The user can not change its contents according to his requirements.
3. Static web page is unable to provide any kind of information.
4. User can not perform any kind of calculations.
5. They are processed on client machine.
6. Dynamic pages
The page that is generated dynamically at the time of request is
called dynamic web page. OR
A webpage which is developed in html and programming code, where
programming code may consists of client side programming or server side
programming. Programming tool may VB script, JAVA script, php, asp or
any other.
Characteristics
1. User can change the contents of dynamic page according tohis/her requirements.
2. User can perform any type of processing .
3. Mathematical, statistical, scientific and database operation can
be performed on dynamic web pages.
11
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 12/47
4. It is saved with the extension of .html if it contains client side
script other wise it is saved with the extension of .asp, .php etc.
Server side dynamic web pages are processed at web server.
Online shopping
It was a time of past to spared your business in market by
conventional methods. Old market is today converted in high tech markets.
Today if you want to purchase any item from abroad you need not to go or
you need not to call them for a sample. You can find their products and
see the catalogue on internet. Internet enables you to shop throughout
world from the comfort of your home. Internet has some special
characteristics which no other medium have. Only internet can provide you
such special information even no salesman can help you as internet helps.
Countless people can see products at a single movement, as well as they
can purchase the product same time. You can compare various product
and choose which is more useful for you, You have the facility to visit
websites as much as you like no restriction on you here you will find
approximately all world class brands and their products you have the
facility to compare them, arrange according to many types like by price, by
size, by category, by most salable item and many more. This facility
enables you to choose. This way of shopping provides a new way of
shopping.
Online shopping is the process whereby consumers directly buy
goods or services from a seller in real-time, without an intermediary
service, over the Internet. It is a form of electronic commerce. An online
shop, eshop, e-store, internet shop, webshop, webstore, online store, or
virtual store evokes the physical analogy of buying products or services at
a bricks-and-mortar retailer or in a shopping centre. The process is called
Business-to-Consumer (B2C) online shopping.
12
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 13/47
About Gomal Online shopping SystemGomal online shopping site offers facility to different users to buy
available products. Register customers can buy products while sitting in
their homes. Products may be of different types such as cameras, laptops,
and mobiles etc. This site will satisfy the needs of customers. It will save
the time and money, and customers will get their required products in
more easy way.
Main features
1. Keeps track of Customer’s personal information.
2. User security by authenticating customer.
3. Administration panel to update database.
4. Showing approximately all properties of products.
5. Easy to use interface.
13
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 14/47
Chapter # 2
EXISTING SYSTEM
14
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 15/47
Introduction
The idea of this project is taken from a shop, whose system wasvery interesting. This all system is done manually.
This shop is a store of valuable things. The whole system is
described by the two main factors
1. Shop administrator
2. buyer
shop’s administrator is a person who has the place where things can be
placed for sale.
People come to administrator to buy things are buyers.
If a person has to buy some thing then he come to the shop and ask for
his required thing. Now administrator will show him that thing and also tell
him its different varieties, its price, and features. The same process is
repeated for every customer. When the customer buy his required thing
then administrator will have to placed all products in its proper place.
Disadvantages of the existing system
There are many drawbacks in the existing system.
• The administrator has to maintain a list of registers of
products with there prices. Unreliable system due to greater
chances of information being destroyed or lost.
• Searching of a particular products in big shop is also very
time consuming activity.
• To describe the price, feature and varieties of every product
to every customer again and again, it is very time consuming
process.
• To show products to every customer and to set back in their
proper place is also a very time consuming and tedious job.
15
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 16/47
• There may also be a risk of the breaking of products while
showing to customer and setting back in to their proper
place.
16
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 17/47
Chapter # 3
PROPOSED SYSTEM
17
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 18/47
Introduction
It is the age of computer. Most of the business is being done online.Notable shops are doing business online. Now it is the sign of good shop
to have the business online.
The existing system of our shop was definitely having some
drawbacks. These drawbacks are directly effecting the business so the
administrator is interested to get his business on the web. In getting the
business online we will relief of a heavy burden.
Now our proposed system is to develop a website that can handle
online all transaction being done manually. The customer can buy product
online. The customer has no need to come physically for buying products,
because when a customer comes physically on shop he is really losing his
time.
Who can use the web site?
Every user whether he is registered or not can use the site and see
the products.Whenever a customer visit our site although he is allowed to see,
what available on site yet he unable to take the fun of our site. Our website
is quite friendly to registered customers. Only registered customer can put
their orders for available products.
All transactions are done online so first we start user registration.
Customer registration
Customer is more important entity for business, but before doingbusiness with any person you will wish to know about that person. So the
case is in online business we will get information from the person who
wants to do business with us. So customer must be registered with
website.-
18
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 19/47
Features of proposed system
• Attractive and user friendly interfaceThe efforts have really dedicated for making interface of the site more
attractive and user friendly. This thing has been kept in mind that the
interface must be consistent in its appearance color scheme has been
selected that catches the eyes almost the look of the site is kept so same,
the user can feel that he is visiting the same site.
• Fair administration
The administration of the site is critical job. So the administration is
provided full authorities for site handling. He has to handle all the
transactions on the site, so he is provided with an interface that is easy to
use for him.
• Simple way of ordering
In this proposed system we have adopt so simple way so that a common
person can easily ordered for any available products.
19
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 20/47
Chapter # 4
System requirement
specification
20
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 21/47
System Requirement Specification
The main purpose of online shopping site is to facilitate costumersto buy products and services while sitting in there homes.
The requirements of online shopping software are specified as input,
process and output to understand and work further. The online system will
be designed on the required specifications and categorized here as
1. Input specification: In this section all the required inputs will be
specified, which are record online from remote locations.
2. Output specification: These are the reports or information which are
needed to show costumers such as products properties and many
others.
3. Process specifications: The functions which software is required to
perform will be clearly defined like registering etc.
Several interviews with end users have been carried out for gathering
requirements to clearly define there inputs and outputs. However onsite observation was also done and met with whole Human Right
section for better under standing of requirement and manual system.
The final input and output specifications are as follow:
Input Specification
Product category entry
Description: New products can be entered for product categorization.
One category of product can have different products subjects, so product
code and name will be defined separately.
Customer Entry
Description: customer personal information is required to input for
customer registration which may include name, address, phone, email id,
password etc. This information of customers is required to register their
orders for any product.
21
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 22/47
Products:
Description: products are the heart of this system. All possible the
information about any product is required so that customer can select the
product of his/her choice.
Process Specifications
Product selection: This function will show products selected from
database with all information about the product for the customer. The
products are selected based on the category of the product..
Registering orders: When customer order for any product then the
function will first check that whether the customer is registered or not, if it
is a registered customer then his/her order will be accepted by system by
showing a message otherwise it will be rejected.
Output Specification
Registered orders: All the orders will be shown to administrator and he
will print and confirm the orders. An order contains the information about
customer’ product, quantity and order date etc.
22
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 23/47
Chapter # 5
System design
23
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 24/47
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 25/47
E R diagram
25
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 26/47
Physical database design
Table Name: MemberDescription: This table contains all the information of customers.
Primary key: id
Field Name Data type Descriptionid Begint Primary key(auto increment)
First name Varchar (255) First name of customer
Last name Varchar (255) Last name of customer
cnic Varchar(50) Cnic # of customer
Gender Varchar(20) Gender of customer
contactno Varchar(255) Contact # of customerAddress text Address of customer
Email_id Varchar(255) Valid email id of customer
password Varchar(255) Password of customer
26
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 27/47
Table Name: Admin
Description: This table contains information about administrators. It consists of
id, name and password.
Primary key: id
Table Name: Pro_category
Description: It contains information about the category of products. This table
contains id, cat_name and description about category.
Primary key: id
Field Data type Descriptionid Bigint Primary key (auto increment)
cat_name Varchar(255) Name of product’s category
description Varchar(255) Description of category
Field Data type Descriptionid Bigint Primarykey (autoincrement)
name Varchar(255) Name of administrator
password Varchar(255) Password of administrator
27
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 28/47
Table Name: Products
Description: This table contains information about the products. It consists of
pro_id, pro_name, comp_name, pro_model, description, price and picture.
Primary key: pro_id
Field Data type Descriptionpro_id bigint Primary key (auto increment)
pro_name Varchar(255) Product’s name
comp_name Varchar(255) Company name of the productpro_model Varchar(255) Product’s model
description text Description of product
price bigint Price of the product
picture text Picture of product
28
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 29/47
Table Name: Orders
Description: This table contains the orders registered by costumers. It consists of
order_id, uid, pro_id, units, address, orderdate, modeofpayment and confirm.
Primary key: order_id
Foreign key: uid, pro_id
Field Data type Descriptionorder_id Bigint Primary key (auto increment)
uid Bigint Costumer id
Pro_id Bigint Product id
units int Quantity of product
address text If costumer change his delivery
address
orderdate date The date of order
modeofpayment Varchar(255) Mode of payment
confirm Varchar(255) Confirmation of order
29
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 30/47
Chapter # 6
Front End Design
30
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 31/47
User interfaceIndex page:
PURPOSE:
This is the index page of the site which leads to the different pages
of the website.
31
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 32/47
FAQ page:
PURPOSE:
This page contains the frequently asked questions.
32
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 33/47
User Registration Page:
PURPOSE:
This is the User Registration page of the online shopping website.
33
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 34/47
User Login Page:
PURPOSE:
This is the login page for customer. Email id and password are required
for login.
34
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 35/47
Products page:
PURPOSE:
When customer clicks on any product link, Then it will show
different products of the selected type.
35
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 36/47
Order Not Register:
PURPOSE:
If the customer is not login to the website yet he can see the
products but cannot ordered, and the order can not be further processed.
36
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 37/47
Order page:
PURPOSE:
When any customer is login to the website and click on the “Buy
Now” button of any product, then in this page user can enter no: of units of
product, delivery address, and mode of payment.
37
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 38/47
Order Verify Page:
PURPOSE:
When user click on “Order Now” button, then this page will be
appeared which show the confirmation of order.
38
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 39/47
Administrator’s pages
39
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 40/47
Log in Page:
PURPOSE:
This page is used for login to administrator pages. No Admin page
can be seen with out login.
40
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 41/47
Add Products:
PORPUSE:This page is used to add products.
41
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 42/47
Add Administrator:
PURPOSE:
This page is used to add new administrators.
42
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 43/47
Confirm orders:
PURPOSE:
This page shows all orders one by one which are not confirmed, and
administrator can confirm it by clicking on the button “confirm order and goto
next”.
The below link “see all orders” shows all the orders whether confirm or not.
43
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 44/47
All Orders:
PURPOSE:
This page shows all the orders whether confirmed or not.
44
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 45/47
Chapter # 7
SYSTEM TESTING AND
EVALUATION
45
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 46/47
Testing Strategies:The hallmark is the performance of any software is the testing strategies.
These testing strategies play major role to satisfy the further performance
Of the soft ware. The following strategies provide testing of software for
Better and efficient implementation of the soft ware.
Input Testing:
It is the process to test whether the proposed soft ware can take the valid
input and check blocks in valid entry of the data, And in this way the soft
ware Provide best performance.
Output Testing:
It is the process to test the output generated by the soft ware and to
specify that either the soft ware is providing the required output or not.
Output Testing plays the major role because it indicates all those factors
that ay create problems in the implementation and working of the Soft
ware.
Code Testing:
It is the process to test the coding and to specify that either the coding is
Error less and check the developed soft ware provides the quick flow of
Data and either the code designing satisfy the performance of the Soft
ware.
Data Base Testing:
Data base design for the soft ware is tested and its performance is
identified Such that either the soft ware provides effective storage or not .
The testing Of the data base plays the major role as it is the stage to
indicate that either The soft ware is satisfying the user of organization.
During Development Testing:
During the development of the any software, due to nature and capabilities
of tools used, Testing was performed simultaneously along with
46
8/3/2019 Allah Noor
http://slidepdf.com/reader/full/allah-noor 47/47
development. Rests of the bunks were removed in One week period after
soft ware had been completely developed. Each Interface was tested
independently of the others to verify the correct behaviors and processing
of data.
Evaluation of the Soft Ware of the End User
The system has been tested and evaluated by end user. To serve this
purpose the evaluation was implemented on the user system. During
evaluations Period the user has found many deficiencies and bug in the
systems, which were removed on the daily basis.
The bugs related to the following categories
1. Problems with connecting with data base.
2. Reports Generation omissions.
Fixes Of Bugs:
All of bugs have been removed successfully.
Conclusion:
Different conclusions can be drawn after system testing and evaluation of
the proposed system. These conclusions are based on the testing results.
The Major conclusions are as under:
. The proposed system provides effective input data entry in order to
facilitate the user.
. Outputs are generated randomly and user can easily operate and get the
required data quickly.
. Versatile interface provides easy operations of the proposed system such
that a friendly environment is established.